Components
Your shopping cart is empty!
Drag items here to add to cart
string(486) "SELECT MAX(p.price) as price_max_limit, MIN(p.price) as price_min_limit, tax_class_id FROM product p LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_option_value pov ON (p.product_id = pov.product_id) LEFT JOIN product_attribute pa ON (p.product_id = pa.product_id) WHERE p2s.store_id = 0 AND p2c.category_id IN (25,28,29,30,31,32,35,36) LIMIT 1"
string(558) "SELECT MAX(ps.price) as price_max_limit, MIN(ps.price) as price_min_limit, tax_class_id FROM product p INNER JOIN product_special ps ON (p.product_id = ps.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_option_value pov ON (p.product_id = pov.product_id) LEFT JOIN product_attribute pa ON (p.product_id = pa.product_id) WHERE p2s.store_id = 0 AND p2c.category_id IN (25,28,29,30,31,32,35,36) LIMIT 1"
string(606) "SELECT *,m.image as image FROM manufacturer m LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) INNER JOIN product p ON (m.manufacturer_id = p.manufacturer_id) LEFT JOIN product_special ps ON (p.product_id = ps.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_option_value pov ON (p.product_id = pov.product_id) LEFT JOIN product_attribute pa ON (p.product_id = pa.product_id) WHERE m2s.store_id = 0 AND p2c.category_id IN (25,28,29,30,31,32,35,36) GROUP BY(m.manufacturer_id)"
string(470) "SELECT *,c.category_id as category_id,count(p2c.product_id) as prod_count FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN product_to_category p2c ON (c.category_id = p2c.category_id) WHERE c.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0 ' AND c.status = '1' GROUP BY c.category_id ORDER BY c.sort_order, LCASE(cd.name)"
string(855) "SELECT *,od.name as option_name, ovd.name as value_name, ov.image as value_image, count(p.product_id) as prod_count FROM product_option_value pov LEFT JOIN option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) LEFT JOIN `option` po ON (pov.option_id = po.option_id) LEFT JOIN option_description od ON (po.option_id = od.option_id) INNER JOIN product_to_category p2c ON (pov.product_id = p2c.product_id AND p2c.category_id = 25) LEFT JOIN product_attribute pa ON (pov.product_id = pa.product_id) INNER JOIN product p ON (p.product_id = p2c.product_id) LEFT JOIN product_special ps ON (p.product_id = ps.product_id) WHERE ovd.language_id = '1' AND p2c.category_id IN (25,28,29,30,31,32,35,36) GROUP BY ov.option_value_id"
string(494) "SELECT pa1.attribute_id, ad.name, pa1.text,count(pa1.product_id) as prod_count FROM product_attribute pa1 LEFT JOIN attribute_description ad ON (pa1.attribute_id = ad.attribute_id) WHERE ad.language_id = '1' AND pa1.language_id = '1' AND product_id IN ( SELECT p.product_id FROM product p INNER JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (25,28,29,30,31,32,35,36)) GROUP BY pa1.attribute_id,text ORDER BY ad.name"
array(0) { }
AND p2c.category_id IN (25,28,29,30,31,32,35,36)
Drag items here to add to cart
The import tool overwrites your store settings such as product images and module configuration, please make backups before using and preferably use on a new opencart installation
About
Twitter
Facebook