Наборы комбинированных ключей купить по доступной цене в АО "ХОРТС Групп Мск"

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 = '56bba3c3fa56e3c49f66472af7' AND expire > 1771400044SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://hortz.ru/'SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '1' ORDER BY store_id ASCSELECT * FROM oc_currencySELECT 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 = '0') ORDER BY tr1.priority ASCSELECT 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 = '0') ORDER BY tr1.priority ASCSELECT * 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` ASCSELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'razmer_17h19' LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'forma_dvuhstoronnie' LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'proizvoditeli_kzsmi' LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '1' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '16' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '17' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1050' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'SELECT `layout_id` FROM `oc_category_to_layout` WHERE `category_id` = 1050 AND `store_id` = 1 LIMIT 1SELECT `layout_id` FROM `oc_layout_route` WHERE 'product/category' LIKE `route` AND `store_id` = 1 ORDER BY `route` DESC LIMIT 1SELECT `layout_module_id` FROM `oc_layout_module` WHERE `layout_id` = 21 AND `code` = 'filter_vier' LIMIT 1SELECT COUNT(DISTINCT p.`product_id`) AS `total` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 190 AND afv.`attr_text` IN ('190_8') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_1575') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 1050 AND p.`manufacturer_id` IN (583) AND p.`status` = 1 AND p2s.`store_id` = 1 SELECT p.`product_id` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 190 AND afv.`attr_text` IN ('190_8') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_1575') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 1050 AND p.`manufacturer_id` IN (583) AND p.`status` = 1 AND p2s.`store_id` = 1 GROUP BY p.`product_id` ORDER BY p.`quantity` DESC, IF(p.`price` = '0', 0, 1) DESC, `sort_order` ASC, (p.`quantity` > 0) DESC, p.viewed DESC LIMIT 0,30SELECT DISTINCT *, 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_hortz 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 = '30365' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'select * from oc_filter_vier_hl f1 left join oc_filter_vier_hl_lang f2 on(f1.id=f2.id) where f1.short_link='proizvoditeli_kzsmi'SELECT noindex FROM oc_category WHERE category_id = 1050select * from oc_filter_vier_hl where route='category_id' and route_id=1050select * from oc_filter_vier_hl_lang where keywords!=1 and id=77select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select * from oc_filter_vier_hl_lang where keywords!=1 and id=78select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select * from oc_filter_vier_hl_lang where keywords!=1 and id=79select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select * from oc_filter_vier_hl_lang where keywords!=1 and id=80select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select * from oc_filter_vier_hl_lang where keywords!=1 and id=81select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select * from oc_filter_vier_hl_lang where keywords!=1 and id=82select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select * from oc_filter_vier_hl_lang where keywords!=1 and id=83select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select * from oc_filter_vier_hl_lang where keywords!=1 and id=84select name,(select main_id from oc_url_filter_vier where seo_url = 'razmer') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'razmer')select `faq_id`,`text`, `answer`, `is_category` from `oc_category_faq` where `customer_id` = 1 && `category_id`=1050SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '19' GROUP BY p.product_id ORDER BY (p.quantity > 0) DESC, p.viewed DESC, LCASE(pd.name) DESC, p.price = 0 ASC LIMIT 0,29SELECT DISTINCT *, 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_hortz 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 = '22686' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '22693' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '22692' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '22691' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '22690' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '22688' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '22687' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '22689' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '20' GROUP BY p.product_id ORDER BY (p.quantity > 0) DESC, p.viewed DESC, LCASE(pd.name) DESC, p.price = 0 ASC LIMIT 0,21SELECT DISTINCT *, 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_hortz 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 = '204400' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '204414' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '204426' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '216642' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '204422' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '204423' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '204425' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '204427' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178926' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178915' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178013' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178087' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178237' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178244' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178243' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178240' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178246' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178245' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178920' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178052' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT DISTINCT *, 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_hortz 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 = '178054' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT * FROM oc_category_to_layout WHERE category_id = '1050' AND store_id = '1'SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1SELECT * FROM oc_layout_module WHERE layout_id = '21' AND position = 'column_left' ORDER BY sort_orderSELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `route` = 'category_id' AND `route_id` = 1050 SELECT p.`product_id` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 190 AND afv.`attr_text` IN ('190_8') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_1575') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 1050 AND p.`manufacturer_id` IN (583) AND p.`status` = 1 AND p2s.`store_id` = 1 GROUP BY p.`product_id` SELECT p.`manufacturer_id`, 1 AS total FROM `oc_product` p JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 190 AND afv.`attr_text` IN ('190_8') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_1575') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (1050)) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY p.`manufacturer_id`SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_hortz~kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_sitomo~kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi~bez-tm' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi~kvt' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 190 AND afv.`attr_text` IN ('190_8') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_1575') ) tafv ON (afv.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (1050)) AND afv.`attribute_id` IN (147,163,189,192,197,207,290,291,322,326) AND p.`manufacturer_id` IN (583) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY `attr_text`SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 190 AND afv.`attr_text` IN ('190_8') ) tafv ON (afv.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (1050)) AND p.`manufacturer_id` IN (583) AND afv.`attribute_id` IN (155) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY `attr_text`SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_1575') ) tafv ON (afv.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (1050)) AND p.`manufacturer_id` IN (583) AND afv.`attribute_id` IN (190) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY `attr_text`SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/material_stal-hrom-vanadievaya/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'pokritie_nikelirovanie/razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'pokritie_oksidirovannoe/razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'pokritie_omednennoe/razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'pokritie_oskidirovannoe/razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'pokritie_ocinkovannoe/razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'pokritie_satin-finish/razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'pokritie_hromirovannoe/razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/tip-klyucha_kombinirovannie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_5-32~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6-22~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6-24~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~6-27/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~6-30/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6-32~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~6h6/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~6h6-/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_7~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_7-22~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_7-32~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~7h7/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-14~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-17~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-19~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-22~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-24~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-27~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-32~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-36~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-55~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8h10~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~8h8/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~8h9/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_9~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~9h11/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~9h9/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10-19~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10-24~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10-30~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10-32~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10-36~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~10h10/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10h12~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_11~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~11h11/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_12~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~12h12/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~12h13/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_13~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~13h13/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~13h14/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_14~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~14h14/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~14h17/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_15~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~15h15/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~16h16/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~17h17/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_18~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~18h18/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_19~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~19h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~19h19-21h21/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~19h22/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~20h20/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~21h21/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_22~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_22-36~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~22h22/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~22h24/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~23h23/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24-46~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~24h24/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~24h27/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~25h25/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~26h26/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_27~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~27h27/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~28h28/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~29h29/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~30h30/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~32-55/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~32h32/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_34h34~17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~36h36/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~38h38/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~41h41/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~46h46/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~50h50/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19~55h55/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/primenenie_dlya-avtomobilya/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/primenenie_dlya-gruzovogo-avtomobilya/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/primenenie_dlya-kabineta-tehnologii/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/primenenie_universalnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-min--mm_6/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-min--mm_8/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-min--mm_10/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-min--mm_32/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_14/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_19/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_22/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_24/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_27/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_30/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_32/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_36/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/razmer-max--mm_55/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie~bolshie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie~malenkie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_140/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_200/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_225/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_240/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_250/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_290/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_300/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_310/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_315/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_330/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_340/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_350/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_355/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_365/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_370/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_390/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_395/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_425/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_430/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_440/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_445/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_500/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_550/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_610/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_650/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/dlina--mm_700/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/treschotka_da/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/treschotka_net/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT MIN( p.`price`) AS price_min, MAX( p.`price`) AS price_max FROM `oc_product` p LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 190 AND afv.`attr_text` IN ('190_8') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_1575') ) tafv ON (p.`product_id` = tafv.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (1050)) AND p.`manufacturer_id` IN (583) AND p.`status` = 1 AND p2s.`store_id` = 1 SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi/cena_slider_prs' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT 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 = '1050' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'extension/module/filter_vier/filter_vier'SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/column_left'SELECT * FROM oc_category_to_layout WHERE category_id = '1050' AND store_id = '1'SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1SELECT * FROM oc_layout_module WHERE layout_id = '21' AND position = 'column_right' ORDER BY sort_orderSELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/column_right'SELECT * FROM oc_category_to_layout WHERE category_id = '1050' AND store_id = '1'SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1SELECT * FROM oc_layout_module WHERE layout_id = '21' AND position = 'content_top' ORDER BY sort_orderSELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/content_top'SELECT * FROM oc_category_to_layout WHERE category_id = '1050' AND store_id = '1'SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1SELECT * FROM oc_layout_module WHERE layout_id = '21' AND position = 'content_bottom' ORDER BY sort_orderSELECT * FROM oc_module WHERE module_id = '45'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_viewed' OR route = 'ru-ru')SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/content_bottom'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')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 = '1' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASCSELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'extension/module/uni_notification'SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/footer'SELECT * FROM oc_extension WHERE `type` = 'analytics'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/language'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/forma_dvuhstoronnie/proizvoditeli_kzsmi' AND `route` = 'category_id' AND `route_id` = 1050 LIMIT 1SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/currency'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/search'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')SELECT * FROM oc_translation WHERE store_id = '1' 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 = '56bba3c3fa56e3c49f66472af7'SELECT * FROM oc_extension WHERE `type` = 'total'SELECT * FROM oc_translation WHERE store_id = '1' 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 = '56bba3c3fa56e3c49f66472af7'SELECT * FROM oc_translation WHERE store_id = '1' 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 = '1' 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 = '56bba3c3fa56e3c49f66472af7'SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/cart'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/menu' 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 c2s.store_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1038' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '4' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1041' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '9' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1099' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '11' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '16' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '58' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '64' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1100' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '69' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1076' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '106' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '107' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '112' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '169' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1118' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1042' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1079' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '168' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '170' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1022' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '172' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '175' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1715' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1723' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '176' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '195' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1714' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '200' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '201' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '203' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1030' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1718' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1719' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1716' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '209' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1742' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1721' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1722' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1720' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1717' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1724' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '216' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '218' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '228' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '229' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '221' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1120' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '342' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '236' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '245' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '255' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '268' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '270' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '414' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '291' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '307' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '327' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '331' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '332' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '333' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '343' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '345' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '347' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '358' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '354' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '359' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '360' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '362' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '369' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '376' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '382' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '383' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '395' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '355' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '417' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '422' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '445' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '471' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '446' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '502' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1102' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1127' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '545' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '579' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '583' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '584' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '586' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '588' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '589' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '581' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '140' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1040' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '595' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '602' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '611' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '597' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '639' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '805' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1122' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1126' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '824' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '825' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '828' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '829' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1117' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '843' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '850' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1133' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '853' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '924' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1317' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1443' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1444' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1321' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1442' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1454' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1450' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1452' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1463' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1447' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1448' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1451' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1446' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1455' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1320' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1457' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1441' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1445' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1453' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1458' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1459' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1460' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1756' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1758' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1759' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1767' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1768' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1769' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1771' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1772' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1773' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1774' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1780' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1783' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1784' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1792' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1795' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1797' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1804' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1809' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1812' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1813' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1814' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1819' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1318' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1330' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1328' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1325' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1323' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1324' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1322' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1329' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1326' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2207' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '2293' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2294' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2299' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2302' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2306' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2319' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2325' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2326' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2224' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2339' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2344' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2345' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2346' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2347' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2348' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2357' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2358' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2359' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2286' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2360' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2374' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2375' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2376' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2377' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2378' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2379' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2384' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2385' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2261' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1136' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '2386' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1276' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1248' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1286' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1156' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1222' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1195' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1230' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1137' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1149' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1743' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1745' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1746' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1747' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1748' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1749' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1750' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1751' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1753' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2196' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1754' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1755' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1826' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1828' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1831' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1832' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1833' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1834' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1835' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1836' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1837' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1838' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1841' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1842' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1848' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1' 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 = '1853' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1862' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1874' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1886' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1888' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1889' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1908' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1909' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1932' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1942' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1946' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1955' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1956' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1957' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1968' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '1969' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2037' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2048' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2061' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2110' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2126' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2127' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2197' AND cd.language_id = '1' AND c2s.store_id = '1' 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 = '2200' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/menu'SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/header'SELECT * FROM oc_setting WHERE store_id = '1' AND `code` = 'advertise_google'SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'octemplates/module/oct_breadcrumbs'SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'product/category'SELECT * FROM oc_setting WHERE store_id = '1' AND `code` = 'advertise_google' Наборы комбинированных ключей купить по доступной цене в АО "ХОРТС Групп Мск"

8 (495) 380-19-73
info@hortz.ru

Ваша корзина пуста!

Прайс-лист на наборы комбинированных ключей

Фильтр товаров

Цена

Бренд

Hortz

Sitomo

Без ТМ

КВТ

КЗСМИ

Материал

Сталь хром-ванадиевая

Покрытие

никелирование

оксидированное

омедненное

оскидированное

оцинкованное

сатин финиш

хромированное

Тип ключа

Комбинированные

Размер

5-32

6-22

6-24

6-27

6-30

6-32

6х6

6х6.

7-22

7-32

7х7

8-14

8-17

8-19

8-22

8-24

8-27

8-32

8-36

8-55

8х10

8х8

8х9

9х11

9х9

10-19

10-24

10-30

10-32

10-36

10х10

10х12

11х11

12х12

12х13

13х13

13х14

14х14

14х17

15х15

16х16

17х17

17х19

18х18

19х19

19х19.21х21

19х22

20х20

21х21

22-36

22х22

22х24

23х23

24-46

24х24

24х27

25х25

26х26

27х27

28х28

29х29

30х30

32-55

32х32

34х34

36х36

38х38

41х41

46х46

50х50

55х55

Применение

Для автомобиля

Для грузового автомобиля

Для кабинета технологии

Универсальные

Размер min, мм

Размер max, мм

Форма

Большие

Двухсторонние

Маленькие

Длина, мм

140

200

225

240

250

290

300

310

315

330

340

350

355

365

370

390

395

425

430

440

445

500

550

610

650

700

Трещотка

Да

Нет

1Показать

Сортировать по Название Цена Популярные

Артикул: 164590

Набор ключей гаечных комбинированных 11 шт. (8-24) брезентовая сумка КЗСМИ

164590

2 045 руб. б/НДС

2 495 руб.с НДС

Показано с 1 по 1 из 1 (всего 1 страниц)

Часто ищут

8-32 мм

8-22 мм

8-24 мм

6-32 мм

6-22 мм

6-24 мм

8-17 мм

8-19 мм

REPLACE INTO `oc_session` SET session_id = '56bba3c3fa56e3c49f66472af7', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\"}', expire = '2026-02-18 10:58:06'

Наборы комбинированных ключей: Бренд КЗСМИ Размер 17х19, Форма Двухсторонние

Часто ищут