test 4
There are no products to list in this category.
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 = 38 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 = 38 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 = 38 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 = '38' 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 = 38) 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 = 38 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 = 38) GROUP BY pa1.attribute_id,text ORDER BY ad.name"
array(0) { }
AND p2c.category_id = 38
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
Anne.
You can change this text from Control Panel > Social band > About text
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