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 = '368e2e9ada9533e195e17b1653' AND expire > 1775392446

SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://xn-----6kckbnadjqvmwhoa7a0jf9e5c.xn--p1ai/'

SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '5' 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 = '122') 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 = '122') 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 'golovka-tortsevaya-iskrobezopasnaya-1_4102-9-becu-hortz'

SELECT * FROM oc_store_add WHERE store_id = 5

SELECT * FROM oc_store_add WHERE store_id = 5

SELECT * FROM oc_store_add WHERE store_id = 5

SELECT * FROM oc_translation WHERE store_id = '5' AND language_id = '1' AND (route = 'product/product' 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 = '170' AND cd.language_id = '1' AND c2s.store_id = '5' 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 = '172' AND cd.language_id = '1' AND c2s.store_id = '5' 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 = '173' AND cd.language_id = '1' AND c2s.store_id = '5' AND c.status = '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 = '177078' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '5'

SELECT `price_add` FROM oc_store_add WHERE store_id = 5

SELECT noindex FROM oc_product WHERE product_id = 177078

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

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

SELECT * FROM oc_product_to_category WHERE product_id = '177078'

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 = '4' AND cd.language_id = '1' AND c2s.store_id = '5' 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 = '1' AND cd.language_id = '1' AND c2s.store_id = '5' 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 = '5' AND cd.language_id = '1' AND c2s.store_id = '5' 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 = '1113' AND cd.language_id = '1' AND c2s.store_id = '5' 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 = '170' AND cd.language_id = '1' AND c2s.store_id = '5' 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 = '173' AND cd.language_id = '1' AND c2s.store_id = '5' AND c.status = '1'

SELECT r.review_id, r.author, r.rating, r.text, r.reply, p.product_id, pd.name, p.price, p.image, r.date_added 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) WHERE p.product_id = '177078' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,20

SELECT DISTINCT * FROM `oc_oct_product_extra_tabs` pet LEFT JOIN `oc_oct_extra_tabs` et ON (et.extra_tab_id = pet.extra_tab_id) LEFT JOIN `oc_oct_extra_tabs_description` etd ON (etd.extra_tab_id = pet.extra_tab_id) WHERE pet.product_id = '177078' AND pet.language_id = '1' AND etd.language_id = '1' AND et.status = '1' ORDER BY et.sort_order ASC

SELECT * FROM oc_product_image WHERE product_id = '177078' ORDER BY sort_order ASC

SELECT DISTINCT * FROM `oc_oct_product_extra_tabs` pet LEFT JOIN `oc_oct_extra_tabs` et ON (et.extra_tab_id = pet.extra_tab_id) LEFT JOIN `oc_oct_extra_tabs_description` etd ON (etd.extra_tab_id = pet.extra_tab_id) WHERE pet.product_id = '177078' AND pet.language_id = '1' AND etd.language_id = '1' AND et.status = '1' ORDER BY et.sort_order ASC

SELECT * FROM oc_product_discount WHERE product_id = '177078' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC

SELECT `product_id` as `id`,(SELECT `article` FROM `oc_product` WHERE `product_id` = `id`) as `article` FROM `oc_product_add_article_to_description` WHERE `product_id` = 177078

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

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

SELECT url, store, (select name from other_store_id where store_id = store) as store_name FROM `other_store` where `article` = 1134950

SELECT pu1.text1 as `url`, hl.meta_h1 as `name` FROM `oc_product_all_tags_products` pu left join `oc_product_all_tags_urls_products` pu1 ON pu.link_id = pu1.id left join `oc_filter_vier_hl_lang` hl on hl.id = pu1.id WHERE `product_id` = 177078

SELECT `url` FROM `oc_product_sert` WHERE `article` = 1134950

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

SELECT `description` FROM `oc_product_sostav_naborov` WHERE `article` = 1134950

SELECT * FROM `oc_product_sert2` WHERE `product_id` = 177078

SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '177078' AND od.language_id = '1' ORDER BY o.sort_order

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

SELECT COUNT(*) AS total 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) WHERE p.product_id = '177078' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'

SELECT r.review_id, r.author, r.rating, r.text, r.reply, p.product_id, pd.name, p.price, p.image, r.date_added 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) WHERE p.product_id = '177078' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5

SELECT * FROM oc_theme WHERE store_id = '5' AND theme = 'oct_remarket' AND route = 'product/review'

SELECT rating FROM oc_review WHERE product_id ='177078' AND status = '1'

select `cache_text` FROM `oc_product_cache3` WHERE `product_id` = 177078

SELECT DISTINCT p.product_id as `id`, p.article as `art_razmer`, (SELECT `keyword` FROM `oc_seo_url` WHERE `query` = CONCAT('product_id=',`id`) && `store_id` = 0 LIMIT 1) as `url`,pa.text FROM oc_product p LEFT JOIN oc_product_to_category ptc on ptc.product_id = p.product_id LEFT JOIN oc_product_attribute pa on pa.product_id = p.product_id WHERE `ptc`.`category_id` = 173 && `ptc`.`main_category` = 1 && pa.attribute_id = 155 && p.status = 1 && p.manufacturer_id = 573 && p.product_id IN (SELECT `product_id` FROM `oc_product_attribute` WHERE `attribute_id` = 163 && `text` = 'BeCu') ORDER BY CAST(pa.text AS UNSIGNED)

SELECT DISTINCT `text` FROM `oc_product_attribute` WHERE `product_id` = 177078 && `attribute_id` = 155

SELECT DISTINCT p.product_id as `id`, p.article as `art_razmer`, (SELECT `keyword` FROM `oc_seo_url` WHERE `query` = CONCAT('product_id=',`id`) && `store_id` = 0 LIMIT 1) as `url`,pa.text, (SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 155 && `text` LIKE '%-%' && `product_id` = `id` limit 1) as `dop_text1` FROM oc_product p LEFT JOIN oc_product_to_category ptc on ptc.product_id = p.product_id LEFT JOIN oc_product_attribute pa on pa.product_id = p.product_id WHERE `ptc`.`category_id` = 173 && `ptc`.`main_category` = 1 && pa.attribute_id = 182 && p.status = 1 && p.manufacturer_id = 573 && p.product_id IN (SELECT `product_id` FROM `oc_product_attribute` WHERE `attribute_id` = 163 && `text` = 'BeCu') ORDER BY CAST(pa.text AS UNSIGNED)

SELECT DISTINCT * FROM oc_product_to_category ptc LEFT JOIN oc_product p ON (ptc.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.product_id != '177078' AND p.status = '1' AND ptc.category_id = '173' AND p.date_available <= NOW() AND p2s.store_id = '5' AND p.price > 0 AND p.quantity > 0 ORDER BY RAND() LIMIT 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 = '21488' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '5'

SELECT `price_add` FROM oc_store_add WHERE store_id = 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 = '21501' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '5'

SELECT `price_add` FROM oc_store_add WHERE store_id = 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 = '25382' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '5'

SELECT `price_add` FROM oc_store_add WHERE store_id = 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 = '21487' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '5'

SELECT `price_add` FROM oc_store_add WHERE store_id = 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 = '21502' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '5'

SELECT `price_add` FROM oc_store_add WHERE store_id = 5

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

SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 177078 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC

SELECT * FROM `oc_module` WHERE `code` LIKE 'oct_product_views'

UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '177078'

SELECT * FROM oc_product_to_category WHERE product_id = '177078'

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 = '173' AND cd.language_id = '1' AND c2s.store_id = '5' AND c.status = '1'

SELECT short_code FROM oc_product_video WHERE product_id = 177078

SELECT * FROM oc_product_to_layout WHERE product_id = '177078' AND store_id = '5'

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

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

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

SELECT * FROM oc_product_to_layout WHERE product_id = '177078' AND store_id = '5'

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

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

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

SELECT * FROM oc_product_to_layout WHERE product_id = '177078' AND store_id = '5'

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

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

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

SELECT * FROM oc_product_to_layout WHERE product_id = '177078' AND store_id = '5'

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

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

SELECT * FROM oc_module WHERE module_id = '39'

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

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 = '177787' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '5'

SELECT `price_add` FROM oc_store_add WHERE store_id = 5

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

SELECT * FROM oc_module WHERE module_id = '34'

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

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

SELECT * FROM oc_translation WHERE store_id = '5' 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 = '5' AND i.status = '1'

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

SELECT * FROM oc_translation WHERE store_id = '5' 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 = '5' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC

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

SELECT * FROM oc_theme WHERE store_id = '5' 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 = '5' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')

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

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

SELECT * FROM oc_translation WHERE store_id = '5' 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 = '368e2e9ada9533e195e17b1653'

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

SELECT * FROM oc_translation WHERE store_id = '5' 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 = '368e2e9ada9533e195e17b1653'

SELECT * FROM oc_translation WHERE store_id = '5' 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 = '5' 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 = '368e2e9ada9533e195e17b1653'

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '368e2e9ada9533e195e17b1653'

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '368e2e9ada9533e195e17b1653'

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

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

SELECT * FROM oc_translation WHERE store_id = '5' 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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '596' AND cd.language_id = '1' AND c2s.store_id = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

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

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

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

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

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

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_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 = '1849' AND cd.language_id = '1' AND c2s.store_id = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (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 = '5' 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 = '5' AND omd.language_id = '1' ORDER BY om.sort_order ASC

SELECT * FROM oc_theme WHERE store_id = '5' 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 = '5' AND language_id = '1' AND (route = 'extension/module/formcreator' OR route = 'ru-ru')

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

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

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

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

SELECT * FROM oc_store_add WHERE store_id = 5

SELECT * FROM oc_store_add WHERE store_id = 5

SELECT `url` FROM `oc_product_poverka` WHERE `article` = 1134950

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

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

Головка торцевая искробезопасная (1/4)102-9 BeCu, HORTZ 1134950 купить, узнать цены, характеристики и отзывы в Воронеже
Меню
Список сравнения 0

Головка торцевая искробезопасная (1/4")102-9 BeCu, HORTZ

Фото может не соответствовать внешнему виду. Производитель оставляет за собой право изменять внешний вид изделия с целью улучшения эксплуатационных характеристик.
Характеристики: (смотреть все)
Материал
Тип головок
Штрихкод
4680781409252
Производитель: Hortz
Артикул: 1134950
Отзывы: (0)
3 263 руб. без НДС
3 981 руб. с НДС
Головка торцевая искробезопасная HORTZ. Торцевая искробезопасная головка предназначена для выполнения слесарно-монтажных работ в потенциально взрывоопасных зонах. Изготавливается в двух вариантах сплавов: алюминиевая бронза и бериллиевая бронза (AL-Cu & Be-Cu). Торцевые головки обладают высокой прочностью и точностью исполнения, что обеспечивает надёжный захват болтов и гаек. Инструменты из состава алюминиевая бронза и бериллиевая бронза подходят для использования в более сложных и опасных средах, где уровня защиты омедненных инструментов недостаточно для проведения работ. Сертифицирован в соответствии со стандартами взрывобезопасности ТР ТС 012/2011.
Характеристики
Материал
Тип головок
Штрихкод
4680781409252
Гарантия производителя 1 год
Отзывы
0/ 5
средний рейтинг товара
0
0
0
0
0
Нет отзывов о данном товаре. Станьте первым, оставьте свой отзыв.

Получить товар в Воронеже можно следующими способами:
  1. Забрать из пункта выдачи ТК "Деловые линии" по адресу ул. Брусилова, д.4Б. Время в пути от 1 дня. Стоимость доставки "Деловыми линиями" от 762 ₽.
  2. Доставка «до дверей» по г. Воронежу согласовывается в индивидуальном порядке с персональным менеджером. Доставка от склада Ситомо до транспортных компаний в г. Москва осуществляется бесплатно.


Рекомендуемые перевозчики:


      


Для физических лиц:
  • Оплата по ссылке или QR-коду, которые менеджер отправляет на электронную почту
  • Товар бронируется на 3 рабочих дня после оформления заказа
  • После оплаты клиент получает чек от платежной системы и УПД
Для юридических лиц и ИП:
  • Оплата по счету (безналичный расчет)
  • Для российских организаций работаем с НДС
  • После оплаты отправляется товар с полным комплектом документов (УПД, счёт-фактура при необходимости)
Для компаний из Республики Беларусь и Республики Казахстан:
  • Работаем без НДС
Этот товар содержится в каталогах
Показать ещё
Рекомендуемые товары
Вы смотрели
Артикул 355779
Головка торцевая, 10 мм, шестигранная, CrV, под квадрат 1/2, хромированная Matrix
0

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

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

REPLACE INTO `oc_session` SET session_id = '368e2e9ada9533e195e17b1653', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\",\"formcreator_email\":\"sitomo@sitomo.ru\"}', expire = '2026-04-05 15:58:07'