string(463) "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 = 31 LIMIT 1"
string(535) "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 = 31 LIMIT 1"
string(583) "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 = 31 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 = '31' 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(832) "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 = 31) 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 = 31 GROUP BY ov.option_value_id"
string(471) "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 = 31) GROUP BY pa1.attribute_id,text ORDER BY ad.name"
array(0) { }
AND p2c.category_id = 31
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
Chicharrones cliche scenester waistcoat you probably haven't heard of them. Freegan affogato cred, bicycle rights vegan distillery retro heirloom sartorial seitan trust fund ennui waistcoat.
Twitter
Facebook