SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type'

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')

SELECT * FROM oc_extension WHERE `type` = 'openbay'

SELECT `data` FROM `oc_session` WHERE session_id = '9d47dfa40ec62593c8576b8dc4' AND expire > 1791015037

SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://sitomonnov.ru/'

SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '3' ORDER BY store_id ASC

SELECT * FROM oc_currency

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '88') ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '88') ORDER BY tr1.priority ASC

SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'

SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'

DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

SELECT * FROM oc_extension WHERE `type` = 'openbay'

SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC

SELECT `query`, `keyword` FROM `oc_seo_url_redirect` WHERE `query` LIKE 'metallorukav-75-mm'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '3787'

select * from oc_filter_vier_hl f1 left join oc_filter_vier_hl_lang f2 on(f1.id=f2.id) where f1.short_link='metallorukav-75-mm'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3631' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3636' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3677' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3729' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3787' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3631' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3636' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3677' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3729' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '3729'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3787' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

select * from oc_filter_vier_hl f1 left join oc_filter_vier_hl_lang f2 on(f1.id=f2.id) where f1.short_link='metallorukav-75-mm'

SELECT `meta_title`, `meta_description`, `description` FROM `oc_category_description_title` WHERE `category_id` = 3787 && `store_id` = 3

SELECT `category_id` as `id` FROM `oc_category_add_article_to_description` WHERE `category_id` = 3787

select `count` as total from `oc_category_count` where `category_id` = '3787'

SELECT `gost` FROM `oc_category_gost` WHERE `category_id` = 3787

SELECT * FROM oc_category_description_store WHERE category_id = '3787' AND store_id = '3' AND language_id = '1'

select `count` as total from `oc_category_count` where `category_id` = '3787'

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3729' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1'

select `count` as total, min_price, max_price from `oc_category_count` where `category_id` = '3787'

select * from `oc_category_count` where `category_id` = '3787'

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '3787' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"3787"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT `path_id` FROM `oc_category_path` WHERE `category_id` = 3787 && `level` = 0

SELECT `layout_id` FROM `oc_category_to_layout` WHERE `category_id` = 3787 AND `store_id` = 3 LIMIT 1

SELECT `layout_id` FROM `oc_layout_route` WHERE 'product/category' LIKE `route` AND `store_id` = 3 ORDER BY `route` DESC LIMIT 1

SELECT `layout_module_id` FROM `oc_layout_module` WHERE `layout_id` = 3 AND `code` = 'filter_vier' LIMIT 1

SELECT COUNT(DISTINCT p.`product_id`) AS `total` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) LEFT JOIN `oc_category_count` AS cc ON (cc.`category_id` = p2c.`category_id`) WHERE p2c.`category_id` = 3787 AND p.`status` = 1 AND p2s.`store_id` = 3 AND cc.`category_id` = 3787

SELECT p.`product_id` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) LEFT JOIN `oc_product_description` pd ON (p.`product_id` = pd.`product_id`) WHERE p2c.`category_id` = 3787 AND p.`status` = 1 AND p2s.`store_id` = 3 AND pd.`language_id` = 1 GROUP BY p.`product_id` ORDER BY CASE WHEN EXISTS (SELECT 1 FROM oc_product_special sp WHERE sp.product_id = p.product_id AND sp.date_end = '2026-10-31') THEN 0 ELSE 1 END, IF(p.`price` = '0', 1, 0) ASC, (p.`quantity` > 0) DESC, p.viewed DESC, IF(p.`image` != 'NULL', 0, 1) ASC, CASE WHEN EXISTS (SELECT 1 FROM oc_product_special sp WHERE sp.product_id = p.product_id AND sp.date_end != "2026-10-31") THEN 2 ELSE 3 END,FIELD(p.manufacturer_id,573,570,563) DESC,p.product_id ASC, (p.`quantity` > 0) DESC, LCASE(pd.name) DESC LIMIT 0,48

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241303' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239104' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239072' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '242972' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240925' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '242955' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241216' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

select * from oc_filter_vier_hl f1 left join oc_filter_vier_hl_lang f2 on(f1.id=f2.id) where f1.short_link='metallorukav-75-mm'

SELECT noindex FROM oc_category WHERE category_id = 3787

select * from oc_filter_vier_hl where route='category_id' and route_id=3787

select `faq_id`,`text`, `answer`, `is_category` from `oc_category_faq` where `category_id`=3787

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '3729' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"3729"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3' AND cp.path_id = '3773' GROUP BY p.product_id ORDER BY p.price = 0 ASC, p.quantity > 0 DESC, LCASE(pd.name) DESC, LCASE(pd.name) DESC LIMIT 0,41

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239233' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240099' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240018' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239953' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241201' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240025' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240216' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241316' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241268' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240927' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240936' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241254' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '242006' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241183' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241283' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239218' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '243071' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3' AND cp.path_id = '3774' GROUP BY p.product_id ORDER BY p.price = 0 ASC, p.quantity > 0 DESC, LCASE(pd.name) DESC, LCASE(pd.name) DESC LIMIT 0,24

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240940' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241231' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239181' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239396' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '242014' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239979' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3' AND cp.path_id = '3775' GROUP BY p.product_id ORDER BY p.price = 0 ASC, p.quantity > 0 DESC, LCASE(pd.name) DESC, LCASE(pd.name) DESC LIMIT 0,1

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241831' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077280 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1078344 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1078244 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1078162 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093193 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1078251 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1078487 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093643 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093575 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1089305 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1089316 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093554 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1131344 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093174 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093597 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077264 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1131445 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1089321 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093524 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077219 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077478 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1131396 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1078193 AND IS_PARTNER = 1

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1122241 AND IS_PARTNER = 1

SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3' AND cp.path_id = '3787' GROUP BY p.product_id ORDER BY RAND(), p.price = 0 ASC, p.quantity > 0 DESC, LCASE(pd.name) DESC, LCASE(pd.name) DESC LIMIT 0,5

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239104' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '242972' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '242955' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '239072' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT DISTINCT *, (p.price) as price_m, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '240925' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '3'

SELECT `price_add` FROM oc_store_add WHERE store_id = 3

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'octemplates/module/oct_products_modules'

SELECT `gost` FROM `oc_product_gost` WHERE `product_id` = 241303

SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 279 && `product_id` = 241303

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093622 AND IS_PARTNER = 1

SELECT `gost` FROM `oc_product_gost` WHERE `product_id` = 239104

SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 279 && `product_id` = 239104

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077125 AND IS_PARTNER = 1

SELECT `gost` FROM `oc_product_gost` WHERE `product_id` = 239072

SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 279 && `product_id` = 239072

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077080 AND IS_PARTNER = 1

SELECT `gost` FROM `oc_product_gost` WHERE `product_id` = 242972

SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 279 && `product_id` = 242972

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077705 AND IS_PARTNER = 1

SELECT `gost` FROM `oc_product_gost` WHERE `product_id` = 240925

SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 279 && `product_id` = 240925

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1089303 AND IS_PARTNER = 1

SELECT `gost` FROM `oc_product_gost` WHERE `product_id` = 242955

SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 279 && `product_id` = 242955

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1077290 AND IS_PARTNER = 1

SELECT `gost` FROM `oc_product_gost` WHERE `product_id` = 241216

SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 279 && `product_id` = 241216

SELECT `PARTNER_ARTICLE` FROM `FROM_CHEESECAKE_TO_SITE` WHERE `ID` = 1093210 AND IS_PARTNER = 1

SELECT * FROM oc_category_to_layout WHERE category_id = '3787' AND store_id = '3'

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '3' ORDER BY route DESC LIMIT 1

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order

SELECT * FROM oc_module WHERE module_id = '30'

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `route` = 'category_id' AND `route_id` = 3787

SELECT p.`product_id` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 3787 AND p.`status` = 1 AND p2s.`store_id` = 3 GROUP BY p.`product_id`

SELECT p.`manufacturer_id`, 1 AS total FROM `oc_product` p LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (3787)) AND p2s.`store_id` = 3 AND p.`status` = 1 GROUP BY p.`manufacturer_id`

SELECT m.`manufacturer_id`, m.`name`, m.`image` FROM `oc_manufacturer` m , `oc_product` p , `oc_manufacturer_to_store` m2s , `oc_product_to_store` p2s WHERE m.`manufacturer_id` = p.`manufacturer_id` AND p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (3787)) AND m.`manufacturer_id` = m2s.`manufacturer_id` AND m2s.`store_id` = 3 AND p.`product_id` = p2s.`product_id` AND p2s.`store_id` = 3 AND p.`status` = 1 GROUP BY m.`manufacturer_id` ORDER BY m.`sort_order`, m.`name` ASC

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'proizvoditeli~fortisflex' AND `route` = 'category_id' AND `route_id` = 3787 LIMIT 1

SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (3787)) AND afv.`attribute_id` IN (138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,162,163,171,172,173,174,175,177,178,179,181,182,183,184,185,186,187,188,189,190,191,192,193,200,206,207,208,209,210,213,214,215,216,217,218,224,225,227,228,229,230,231,232,234,239,240,241,242,244,246,247,248,249,250,251,252,255,258,259,261,262,263,264,265,266,267,268,269,273,274,275,276,277,278,280,281,282,283,284,285,286,287,289,290,291,292,293,295,296,297,298,299,300,301,307,308,309,311,312,314,318,319,320,321,322,326,327,328,329,330,331,332,333,334,335,336,337,338,341,342,343,345,346,347,348,349,350,351,352,353,407,643,653,655,656,666,670,671,672,675,676,683,684,685,686,687,707,708,709,710,711,712,713,714,716,717,719,720,735,736,742,743,744,745,746,750,753,754,757,798,799) AND p2s.`store_id` = 3 AND p.`status` = 1 GROUP BY `attr_text`

SELECT agd.`attribute_group_id` ,agd.`name` AS name_group ,tfv.`attribute_id` ,tfv.`text_id` ,ad.`name` ,afvl.`text` , tfv.`attr_text` FROM (SELECT DISTINCT afv.`attribute_id`, afv.`text_id`, afv.`attr_text` FROM `oc_attribute_filter_vier` afv , `oc_product` p , `oc_product_to_store` p2s WHERE afv.`product_id` = p.`product_id` AND p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (3787)) AND afv.`attribute_id` IN (138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,162,163,171,172,173,174,175,177,178,179,181,182,183,184,185,186,187,188,189,190,191,192,193,200,206,207,208,209,210,213,214,215,216,217,218,224,225,227,228,229,230,231,232,234,239,240,241,242,244,246,247,248,249,250,251,252,255,258,259,261,262,263,264,265,266,267,268,269,273,274,275,276,277,278,280,281,282,283,284,285,286,287,289,290,291,292,293,295,296,297,298,299,300,301,307,308,309,311,312,314,318,319,320,321,322,326,327,328,329,330,331,332,333,334,335,336,337,338,341,342,343,345,346,347,348,349,350,351,352,353,407,643,653,655,656,666,670,671,672,675,676,683,684,685,686,687,707,708,709,710,711,712,713,714,716,717,719,720,735,736,742,743,744,745,746,750,753,754,757,798,799) AND p.`product_id` = p2s.`product_id` AND p2s.`store_id` = 3 AND p.`status` = 1 ) tfv LEFT JOIN `oc_attribute_filter_vier_lang` afvl ON (tfv.`attr_text` = afvl.`attr_text` AND afvl.`language_id` = 1) LEFT JOIN `oc_attribute` a ON (tfv.`attribute_id` = a.`attribute_id`) LEFT JOIN `oc_attribute_description` ad ON (a.`attribute_id` = ad.`attribute_id`) LEFT JOIN `oc_attribute_group_description` agd ON (a.`attribute_group_id` = agd.`attribute_group_id`) LEFT JOIN `oc_attribute_group` ag ON (agd.`attribute_group_id` = ag.`attribute_group_id`) WHERE ad.`language_id` = 1 AND agd.`language_id` = 1 ORDER BY ag.`sort_order`, a.`sort_order`, ad.`name`, (afvl.`text`+0), afvl.`text`

SELECT MIN( p.`price`) AS price_min, MAX( p.`price`) AS price_max FROM `oc_product` p LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (3787)) AND p.`status` = 1 AND p2s.`store_id` = 3

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'cena~slider_prs' AND `route` = 'category_id' AND `route_id` = 3787 LIMIT 1

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'extension/module/filter_vier/filter_vier'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/column_left'

SELECT * FROM oc_category_to_layout WHERE category_id = '3787' AND store_id = '3'

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '3' ORDER BY route DESC LIMIT 1

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/column_right'

SELECT * FROM oc_category_to_layout WHERE category_id = '3787' AND store_id = '3'

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '3' ORDER BY route DESC LIMIT 1

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/content_top'

SELECT * FROM oc_category_to_layout WHERE category_id = '3787' AND store_id = '3'

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '3' ORDER BY route DESC LIMIT 1

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order

SELECT * FROM oc_module WHERE module_id = '55'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'extension/module/ex_reviews_carousel' OR route = 'ru-ru')

SELECT DISTINCT * FROM ( ( SELECT DISTINCT r.*, pd.name, p.image FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' AND p2c.category_id = '3787' ORDER BY date_added DESC LIMIT 0, 4)) a LIMIT 4

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'extension/module/ex_reviews/ex_reviews_carousel_slick'

SELECT * FROM oc_module WHERE module_id = '39'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'octemplates/module/oct_product_views' OR route = 'ru-ru')

SELECT * FROM oc_module WHERE module_id = '34'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'octemplates/module/oct_benefits'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/content_bottom'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'octemplates/module/oct_subscribe' OR route = 'ru-ru')

SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '3' AND i.status = '1'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'octemplates/module/oct_static_subscribe'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')

SELECT * FROM oc_city ORDER BY name ASC

SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '3' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/footer'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'octemplates/menu/oct_sidebar_mobile'

SELECT * FROM oc_extension WHERE `type` = 'analytics'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/search'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9d47dfa40ec62593c8576b8dc4'

SELECT * FROM oc_extension WHERE `type` = 'total'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9d47dfa40ec62593c8576b8dc4'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')

SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9d47dfa40ec62593c8576b8dc4'

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9d47dfa40ec62593c8576b8dc4'

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9d47dfa40ec62593c8576b8dc4'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/cart'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'octemplates/menu/oct_menu' OR route = 'ru-ru')

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'octemplates/module/oct_popup_login' OR route = 'ru-ru')

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c.top = 1 AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '16' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1038' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1041' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '9' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '622' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1099' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '11' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '58' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1100' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '69' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1076' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '106' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '107' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '112' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4334' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '169' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1118' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1042' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '167' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1079' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '168' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '501' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '170' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"170"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '171' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1022' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '172' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '175' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1715' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2451' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1723' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '176' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2453' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '195' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1714' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '200' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '201' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '203' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1030' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1718' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1719' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1716' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '209' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1742' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1721' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1722' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2454' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1720' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1717' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1724' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2452' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '216' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"216"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1018' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '218' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '228' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '229' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '221' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1120' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '342' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '236' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '245' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '255' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '268' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '270' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '414' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '291' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '307' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '327' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '331' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '332' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '333' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '343' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '345' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '347' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '358' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '354' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '359' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '360' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '362' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '369' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '376' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '382' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '383' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '395' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '355' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '417' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"417"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '418' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '153' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '422' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '445' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '471' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '446' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '502' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1102' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1127' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '545' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '579' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"579"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '582' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '583' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '584' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '586' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '588' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '589' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '581' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '140' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1040' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '595' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"595"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '630' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4278' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '599' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '622' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2450' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '596' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '602' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '597' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '635' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '600' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '712' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '639' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '637' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '805' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"805"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '807' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1122' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1126' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2112' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '824' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '825' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '828' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '829' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1117' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2114' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '843' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '850' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1133' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '853' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"853"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '854' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '924' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1317' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1317"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1319' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1466' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1443' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2447' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1462' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1321' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1463' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1447' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1448' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1496' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1451' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1499' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1446' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1468' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1506' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1507' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1455' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1457' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1441' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1445' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1453' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1458' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1459' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1460' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1534' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1712' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1756' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1756"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1757' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1770' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1759' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1767' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1768' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1771' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1772' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1773' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1774' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1780' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1784' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1797' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1809' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1813' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1814' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1819' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1318' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1318"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1327' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1330' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1328' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1325' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1323' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1324' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1329' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1326' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '2207' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"2207"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2208' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2081' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2302' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1041' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2319' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2325' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2326' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2224' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2346' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2347' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2357' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2359' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2286' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2360' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2375' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2376' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2377' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2378' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2379' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2385' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2261' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1136' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1136"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1259' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2386' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1276' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1248' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1286' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1156' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1222' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1195' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1230' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1137' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1149' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1743' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1743"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1744' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1747' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1748' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1749' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1751' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1753' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2196' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1755' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1826' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1826"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1827' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1828' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1831' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1832' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1833' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1834' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1835' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1836' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1838' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '1841' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"1841"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1842' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1862' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1874' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1889' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1909' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1932' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1942' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1946' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1955' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1956' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1957' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1969' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2048' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2061' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2136' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2200' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '4273' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"4273"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '631' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '446' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '2458' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"2458"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2459' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2464' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2465' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2466' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2479' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2486' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2467' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2495' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2484' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2470' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2487' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2485' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2490' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2476' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2496' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2480' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2474' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3629' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2489' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2482' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2497' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2492' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2483' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2468' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2473' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2472' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2475' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2471' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2481' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2477' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2498' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2488' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2478' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2469' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '3299' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"3299"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3301' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3304' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3427' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3319' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3501' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3506' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3531' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1585' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3509' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3513' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3522' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3445' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3518' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3491' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3495' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3567' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3423' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4187' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3403' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3440' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3486' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3451' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3325' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3597' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3600' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3603' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1645' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1416' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1700' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3478' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3613' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3619' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '3631' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"3631"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3632' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3633' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3634' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2107' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3635' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3636' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3637' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_category_count` ccnt ON (ccnt.category_id = c.category_id) WHERE ccnt.count > 0 AND ((c.parent_id = '4189' OR c.category_id IN (SELECT DISTINCT `category_id` FROM oc_category WHERE JSON_CONTAINS(parent_categories, '"4189"'))) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1') ORDER BY LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4193' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4192' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4190' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4191' AND cd.language_id = '1' AND c2s.store_id = '3' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_oct_menu` om LEFT JOIN `oc_oct_menu_description` omd ON (om.oct_menu_id = omd.oct_menu_id) LEFT JOIN `oc_oct_menu_to_customer_group` omc ON (om.oct_menu_id = omc.oct_menu_id) LEFT JOIN `oc_oct_menu_to_store` oms ON (om.oct_menu_id = oms.oct_menu_id) WHERE om.status = '1' AND om.type IN ('category','manufacturer','oct_blogcategory','link') AND omc.customer_group_id = '1' AND oms.store_id = '3' AND omd.language_id = '1' ORDER BY om.sort_order ASC

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'octemplates/menu/oct_menu'

SELECT * FROM oc_module WHERE module_id = '54'

SELECT * FROM oc_translation WHERE store_id = '3' AND language_id = '1' AND (route = 'extension/module/formcreator' OR route = 'ru-ru')

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'extension/module/formcreator_modal'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'common/header'

SELECT * FROM oc_setting WHERE store_id = '3' AND `code` = 'advertise_google'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'octemplates/module/oct_breadcrumbs'

select `count` as total, min_price, max_price from `oc_category_count` where `category_id` = '3787'

SELECT * FROM oc_theme WHERE store_id = '3' AND theme = 'oct_remarket' AND route = 'product/category'

SELECT * FROM oc_setting WHERE store_id = '3' AND `code` = 'advertise_google'

Металлорукав 75 мм купить по выгодной цене в Нижнем Новгороде на официальном сайте СИТОМО
Меню
8 (831) 429-03-34 info@sitomonnov.ru
Скопировать почту
Список сравнения 0

Металлорукав 75 мм

Найдено 7 товаров
Артикул
Наименование
Количество
Цена (без НДС)
1093622
0
в наличии 400 шт.
755 руб. без НДС
1077125
0
в наличии 60 шт.
651 руб. без НДС
1077080
0
в наличии 140 шт.
8 148 руб. без НДС
1077705
0
в наличии 520 шт.
835 руб. без НДС
1089303
0
в наличии 50 шт.
880 руб. без НДС
1077290
0
в наличии 380 шт.
770 руб. без НДС
Рекомендуем
1077280
0
в наличии 1395 шт.
85 руб.
1078344
0
в наличии 511 шт.
79 руб.
1078244
0
в наличии 2900 шт.
86 руб.
1078162
0
в наличии 12733 шт.
81 руб.
1093193
0
в наличии 800 шт.
107 руб.
1078251
0
в наличии 4200 шт.
97 руб.
1078487
0
в наличии 4200 шт.
87 руб.
1093643
1093575
0
в наличии 4200 шт.
84 руб.
1089305
1089316
0
в наличии 315 шт.
70 руб.
1093554
0
в наличии 1234 шт.
80 руб.
1131344
0
в наличии 35 шт.
191 руб.
1093174
0
Нет в наличии
78 руб.
1093597
0
Нет в наличии
77 руб.
1077264
0
Нет в наличии
185 руб.
1131445
0
Нет в наличии
269 руб.
1089321
0
в наличии 40 шт.
1 722 руб.
1093524
0
в наличии 30 шт.
1 214 руб.
1077219
0
Нет в наличии
1 140 руб.
1077478
0
Нет в наличии
1 227 руб.
1131396
0
Нет в наличии
1 940 руб.
1078193
0
Нет в наличии
1 886 руб.
Популярные товары

Преимущества

Выставление счета в день заказа Чёткое соблюдение сроков отгрузки
Комплексные поставки 50 000 товаров на нашем сайте
Гибкая система скидок Следите за акциями на сайте
Эксклюзивные позиции товаров Редкие размеры. Соотвествие ГОСТу
Всегда актуальные цены Информация об остатках
Работаем с 2002 года На рынке инструментов

REPLACE INTO `oc_session` SET session_id = '9d47dfa40ec62593c8576b8dc4', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\",\"formcreator_email\":\"sitomo@sitomo.ru\"}', expire = '2026-10-03 11:34:38'