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 = '7465327bc9d946bd4e2e965bb0' AND expire > 1750937733

SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://gayechnye-klyuchi-ekb.ru/'

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

SELECT * FROM oc_currency

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

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

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

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

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

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

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'treschotka_net' LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'razmer-min--mm_19' LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'proizvoditeli_hortz' LIMIT 1

SELECT `query`, `keyword` FROM `oc_seo_url_redirect` WHERE `query` LIKE 'klyuchi-nakidnye-izognutye/treschotka_net/razmer-min--mm_19/proizvoditeli_hortz'

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 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_hortz'

SELECT * FROM oc_translation WHERE store_id = '4' 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 = '4' 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 = '4' 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '4' 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 = '1044' AND cd.language_id = '1' AND c2s.store_id = '4' AND c.status = '1'

SELECT * FROM oc_translation WHERE store_id = '4' 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 = '4' 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 = '4' 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '4' AND c.status = '1'

SELECT `name` FROM `oc_manufacturer` WHERE `manufacturer_id` IN (SELECT DISTINCT `manufacturer_id` FROM `oc_product` WHERE `product_id` IN (SELECT `product_id` FROM `oc_product_to_category` WHERE `category_id` = 1044) && `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 = '1044' AND cd.language_id = '1' AND c2s.store_id = '4' AND c.status = '1'

select * from oc_filter_vier_hl f1 left join oc_filter_vier_hl_lang f2 on(f1.id=f2.id) where f1.short_link='proizvoditeli_hortz'

SELECT `meta_title`, `meta_description`, `description` FROM `oc_category_description_title` WHERE `category_id` = 1044 && `store_id` = 4

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

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

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

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

SELECT `layout_id` FROM `oc_category_to_layout` WHERE `category_id` = 1044 AND `store_id` = 4 LIMIT 1

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

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

SELECT COUNT(DISTINCT p.`product_id`) AS `total` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) 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` = 290 AND afv.`attr_text` IN ('290_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 189 AND afv.`attr_text` IN ('189_2') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) LEFT JOIN `oc_category_count` AS cc ON (cc.`category_id` = p2c.`category_id`) WHERE p2c.`category_id` = 1044 AND p.`manufacturer_id` IN (573) AND p.`status` = 1 AND p2s.`store_id` = 4 AND cc.`category_id` = 1044

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` = 290 AND afv.`attr_text` IN ('290_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 189 AND afv.`attr_text` IN ('189_2') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) LEFT JOIN `oc_product_description` pd ON (p.`product_id` = pd.`product_id`) WHERE p2c.`category_id` = 1044 AND p.`manufacturer_id` IN (573) AND p.`status` = 1 AND p2s.`store_id` = 4 AND pd.`language_id` = 1 GROUP BY p.`product_id` ORDER BY CASE WHEN EXISTS (SELECT 1 FROM oc_product_special sp WHERE sp.product_id = p.product_id) THEN 0 ELSE 1 END,IF(p.`price` = '0', 1, 0) ASC, IF(p.`image` != 'NULL', 0, 1) ASC,FIELD(p.manufacturer_id,573,570,563) DESC, (p.`quantity` > 0) DESC, LCASE(pd.name) DESC LIMIT 0,36

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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_hortz'

SELECT noindex FROM oc_category WHERE category_id = 1044

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=232

select 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=233

select 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=234

select 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=235

select 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=236

select 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=237

select 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=238

select 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 `category_id`=1044

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '4' 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 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 = '4' AND cp.path_id = '26' GROUP BY p.product_id ORDER BY p.price = 0 ASC, p.quantity > 0 DESC, LCASE(pd.name) DESC, LCASE(pd.name) DESC LIMIT 0,33

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

SELECT `price_add` FROM oc_store_add WHERE store_id = 4

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

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

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

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

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

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

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT * FROM oc_category_to_layout WHERE category_id = '1044' AND store_id = '4'

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

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

SELECT * FROM oc_module WHERE module_id = '30'

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

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` = 290 AND afv.`attr_text` IN ('290_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 189 AND afv.`attr_text` IN ('189_2') ) 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` = 1044 AND p.`manufacturer_id` IN (573) AND p.`status` = 1 AND p2s.`store_id` = 4 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` = 290 AND afv.`attr_text` IN ('290_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 189 AND afv.`attr_text` IN ('189_2') ) 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 (1044)) AND p2s.`store_id` = 4 AND p.`status` = 1 GROUP BY p.`manufacturer_id`

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_sitomo~hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/razmer-min--mm_19/proizvoditeli_hortz~kzsmi' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) 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` = 290 AND afv.`attr_text` IN ('290_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 189 AND afv.`attr_text` IN ('189_2') ) 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 (1044)) AND afv.`attribute_id` IN (147,155,163,190,192,197,207,289,291,322,326) AND p.`manufacturer_id` IN (573) AND p2s.`store_id` = 4 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` = 290 AND afv.`attr_text` IN ('290_11') ) 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 (1044)) AND p.`manufacturer_id` IN (573) AND afv.`attribute_id` IN (189) AND p2s.`store_id` = 4 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` = 189 AND afv.`attr_text` IN ('189_2') ) 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 (1044)) AND p.`manufacturer_id` IN (573) AND afv.`attribute_id` IN (290) AND p2s.`store_id` = 4 AND p.`status` = 1 GROUP BY `attr_text`

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip-klyucha_nakidnie-dvustoronnie/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip-klyucha_nakidnie-odnostoronnie/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip-klyucha_nakidnie-serpovidnie/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6h7/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6h8/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_7h8/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8h10/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8h9/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_9/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_9h11/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10h11/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10h12/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10h13/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_11/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_11h13/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_12/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_12h13/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_12h14/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_13/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_13h14/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_13h15/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_13h17/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_14/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_14h15/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_14h17/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_15/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_16/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_16h18/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h19/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17h22/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_18/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_18h19/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_19/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_19h22/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_20h22/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_21h23/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_22/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_22h24/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24h26/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24h27/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24h30/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24h32/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_25h28/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_27/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_27h30/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_27h32/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_30/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_30h32/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_32/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_32h36/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_36/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_36h38/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_36h41/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_41/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_41h46/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_46/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_46h50/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_50/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_50h55/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_55/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_55h60/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_60/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_60h65/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_65/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_65h70/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_70/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_70h75/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_75/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_75h80/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_80/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_85/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_90/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_95/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_100/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_105/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_110/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_115/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_120/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'primenenie_dlya-avtomobilya/razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~6/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~7/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~8/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~9/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~10/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~11/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~12/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_13~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~14/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~15/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_16~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_17~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~18/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~20/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~21/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_22~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_24~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~25/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_27~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_30~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_32~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_36~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~41/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_46~19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~50/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~55/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~60/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~65/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~70/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~75/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~80/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~85/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~90/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~95/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~100/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~105/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~110/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~115/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19~120/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_7/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_8/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_9/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_10/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_11/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_12/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_13/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_14/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_15/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_16/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_17/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_18/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_22/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_23/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_24/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_26/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_27/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_28/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_30/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_32/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_36/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_38/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_41/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_46/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_50/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_55/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_60/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_65/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_70/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_75/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_80/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_85/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_90/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_95/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_100/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_105/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_110/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_115/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/razmer-max--mm_120/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/pokritie_oksidirovannoe/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/pokritie_omednennoe/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/pokritie_ocinkovannoe/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/pokritie_poroshkovoe/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/pokritie_satin-finish/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/pokritie_hromirovannoe/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_34/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_100/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_102/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_103/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_110/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_116/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_120/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_121/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_123-5/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_125/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_127/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_130/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_131/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_140/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_144/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_145/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_148/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_155/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_160/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_165/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_168/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_170/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_174/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_175/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_176/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_185/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_190/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_195/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_199/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_200/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_205/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_210/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_215/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_220/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_230/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_233/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_235/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_240/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_245/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_255/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_260/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_262/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_265/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_270/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_280/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_285/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_290/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_295/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_305/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_308/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_310/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_312/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_320/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_330/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_333/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_338/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_340/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_350/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_355/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_360/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_362/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_365/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_375/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_380/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_385/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_390/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_393/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_400/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_410/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_415/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_420/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_425/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_450/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_453/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_470/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_475/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_476/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_480/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_505/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_515/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_520/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_530/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_535/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_550/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_555/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_560/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_565/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_575/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_579/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_595/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_596/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_609/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_625/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_650/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_655/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_660/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_680/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_685/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_725/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_735/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_740/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_755/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_920/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_925/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_930/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_1050/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_1065/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_1070/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/dlina--mm_1075/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/treschotka_net/material_stal-40h/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/treschotka_net/material_stal-45/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/treschotka_net/material_stal-hrom-vanadievaya/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/treschotka_net/sharnirniy-mehanizm_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT MIN( p.`price`) AS price_min, MAX( p.`price`) AS price_max FROM `oc_product` p LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) 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` = 290 AND afv.`attr_text` IN ('290_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 189 AND afv.`attr_text` IN ('189_2') ) 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 (1044)) AND p.`manufacturer_id` IN (573) AND p.`status` = 1 AND p2s.`store_id` = 4

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/treschotka_net/proizvoditeli_hortz/cena_slider_prs' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer-min--mm_19/treschotka_net/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 1044 LIMIT 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 = '1044' AND cd.language_id = '1' AND c2s.store_id = '4' AND c.status = '1'

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

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

SELECT * FROM oc_category_to_layout WHERE category_id = '1044' AND store_id = '4'

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

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

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

SELECT * FROM oc_category_to_layout WHERE category_id = '1044' AND store_id = '4'

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

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

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

SELECT * FROM oc_category_to_layout WHERE category_id = '1044' AND store_id = '4'

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

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

SELECT * FROM oc_module WHERE module_id = '39'

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

SELECT * FROM oc_module WHERE module_id = '55'

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

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

SELECT * FROM oc_review_image WHERE review_id = '530' and review_type = '0'

SELECT * FROM oc_review_image WHERE review_id = '529' and review_type = '0'

SELECT * FROM oc_review_image WHERE review_id = '172' and review_type = '0'

SELECT * FROM oc_review_image WHERE review_id = '154' and review_type = '0'

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

SELECT * FROM oc_module WHERE module_id = '34'

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

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

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

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

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

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

SELECT * FROM oc_city ORDER BY name ASC

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

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

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

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

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

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

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

SELECT * FROM oc_translation WHERE store_id = '4' 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 = '7465327bc9d946bd4e2e965bb0'

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

SELECT * FROM oc_translation WHERE store_id = '4' 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 = '7465327bc9d946bd4e2e965bb0'

SELECT * FROM oc_translation WHERE store_id = '4' 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 = '4' 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 = '7465327bc9d946bd4e2e965bb0'

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '7465327bc9d946bd4e2e965bb0'

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '7465327bc9d946bd4e2e965bb0'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM oc_module WHERE module_id = '54'

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

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

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

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

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

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

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

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

Ключи накидные изогнутые купить
Меню
8 (343) 300-86-11 info@gayechnye-klyuchi-ekb.ru
Скопировать почту
Список сравнения 0

Ключи накидные изогнутые

Артикул
Наименование
Количество
Цена (без НДС)
Артикул 450285
0
в наличии 41 шт.
702 руб. без НДС

Самовывоз, сегодня
Артикул 102195
1
По запросу

Самовывоз, сегодня
Рекомендуем
Артикул 430936
0
в наличии 10 шт.
244 руб.
Артикул 430916
0
в наличии 10 шт.
250 руб.
Артикул 355442
0
в наличии 10 шт.
118 руб.
Артикул 354627
0
в наличии 10 шт.
568 руб.
Артикул 357943
0
в наличии 10 шт.
401 руб.
Артикул 358205
0
в наличии 10 шт.
327 руб.
Артикул 355299
0
в наличии 10 шт.
273 руб.
Артикул 359595
0
в наличии 10 шт.
221 руб.
Артикул 355420
0
в наличии 10 шт.
183 руб.
Артикул 357242
0
в наличии 10 шт.
167 руб.
Артикул 360096
0
в наличии 10 шт.
133 руб.
Артикул 356313
0
в наличии 10 шт.
132 руб.
Артикул 356304
0
в наличии 10 шт.
108 руб.
Артикул 359826
Артикул 360445
Артикул 353590
Артикул 1133439
Артикул 103525
0
в наличии 1522 шт.
110 руб.
Артикул 291894
0
в наличии 7 шт.
197 руб.
Артикул 28932
Артикул 103523
0
в наличии 889 шт.
99 руб.
Артикул 102167
0
в наличии 20 шт.
99 руб.
Артикул 290407
0
в наличии 10 шт.
149 руб.
Артикул 60641
0
в наличии 53 шт.
191 руб.
Артикул 28930
Артикул 129858
0
в наличии 195 шт.
135 руб.
Артикул 102168
0
в наличии 5525 шт.
102 руб.
Артикул 290408
0
в наличии 20 шт.
161 руб.
Артикул 22628
0
в наличии 14 шт.
191 руб.
Артикул 28931
0
в наличии 663 шт.
116 руб.
Артикул 129859
0
в наличии 229 шт.
135 руб.
Артикул 103011
0
в наличии 9 шт.
171 руб.
Артикул 28929

Часто ищут

Показать ещё
Популярные товары

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

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

REPLACE INTO `oc_session` SET session_id = '7465327bc9d946bd4e2e965bb0', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\",\"formcreator_email\":\"sitomo@sitomo.ru\"}', expire = '2025-06-26 14:59:35'