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 = 'b68aec6ad44a3317d3d24b9572' AND expire > 1750861250

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` = 'dlina--mm_80' LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'shag-rezbi--mm_0-5' LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'dlina-rabochey-chasti--mm_19' LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'vid-metchika_mashinno-ruchnoy' LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'diametr-rezbi--mm_18' 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 'metchiki/dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz'

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 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 = '417' 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 = '422' 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 = '417' 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` = 422) && `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 = '422' 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` = 422 && `store_id` = 4

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

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

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

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

SELECT `articles` FROM `oc_product_sort_kluchi2` WHERE `catalog_id` = 422

SELECT `layout_id` FROM `oc_category_to_layout` WHERE `category_id` = 422 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` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv4 ON (afv.`product_id` = tafv4.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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` = 422 AND p.`manufacturer_id` IN (573) AND p.`status` = 1 AND p2s.`store_id` = 4 AND cc.`category_id` = 422

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` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv4 ON (afv.`product_id` = tafv4.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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` = 422 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, FIELD(p.`article`,837305,837306,837307,837304,837302,837299,837296,203849,203850,203847,203838,203845,203841,203840,203835,203837,203836,203834,203828,203832,203830,203829,203809,203811,203813,203815,203814,203817,203855,203852,203853,203854,203851,203669,203667,203665,203666,203664) DESC, IF(p.`image` != 'NULL', 0, 1) ASC, (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 = '32550' 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 = 422

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

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'napravlenie-podachi') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'napravlenie-podachi')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diametr-rezbi--dyuym')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-otverstiya') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-otverstiya')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-otverstiya') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-otverstiya')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'vid-metchika') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'vid-metchika')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'vid-metchika') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'vid-metchika')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'vid-metchika') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'vid-metchika')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-rezbi')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'napravlenie-podachi') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'napravlenie-podachi')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'vid-metchika') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'vid-metchika')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'vid-metchika') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'vid-metchika')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'material') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'material')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'material') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'material')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'material') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'material')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'material') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'material')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tehnicheskiy-standart') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tehnicheskiy-standart')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tehnicheskiy-standart') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tehnicheskiy-standart')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'tip-metchika') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip-metchika')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'material') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'material')

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

select name,(select main_id from oc_url_filter_vier where seo_url = 'material') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'material')

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

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (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 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 = '1102' 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,35

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 = '177853' 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 = '110766' 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 = '110765' 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 = '110764' 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 = '110763' 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 = '110762' 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 = '110761' 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 = '110760' 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 = '110759' 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 = '110758' 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 = '110757' 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 = '110756' 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 = '110755' 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 = '110754' 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 = '110753' 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 = '110752' 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 = '110751' 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 = '110750' 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 = '110749' 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 = '110748' 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 = '110747' 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 = '110746' 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 = '110745' 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 = '110744' 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 = '110743' 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 = '110742' 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 = '110741' 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 = '110740' 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 = '184566' 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 = '110739' 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 = '110738' 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 = '110737' 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 = '184581' 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 = '184580' 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 = '184565' 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 = '422' 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 = '166624' 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 = '167922' 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 = '167600' 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 = '180537' 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 = '168551' 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` = 32550

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT * FROM oc_category_to_layout WHERE category_id = '422' 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` = 422

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` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv4 ON (afv.`product_id` = tafv4.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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` = 422 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` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv4 ON (afv.`product_id` = tafv4.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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 (422)) 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` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz~cnic' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz~tlx' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz~tiz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'dlina--mm_80/shag-rezbi--mm_0-5/dlina-rabochey-chasti--mm_19/vid-metchika_mashinno-ruchnoy/diametr-rezbi--mm_18/proizvoditeli_hortz~tm' AND `route` = 'category_id' AND `route_id` = 422 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` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv4 ON (afv.`product_id` = tafv4.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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 (422)) AND afv.`attribute_id` IN (140,163,218,273,307,308,342,343,346) 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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) WHERE afv.`attribute_id` = 229 AND afv.`attr_text` IN ('229_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 (422)) AND p.`manufacturer_id` IN (573) AND afv.`attribute_id` IN (197) 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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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 (422)) AND p.`manufacturer_id` IN (573) AND afv.`attribute_id` IN (229) 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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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 (422)) AND p.`manufacturer_id` IN (573) AND afv.`attribute_id` IN (255) 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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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 (422)) AND p.`manufacturer_id` IN (573) AND afv.`attribute_id` IN (282) 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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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 (422)) AND p.`manufacturer_id` IN (573) AND afv.`attribute_id` IN (341) 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-metchika_s-shahmatnim-shagom/diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip-rezbi_metricheskaya-m/diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip-rezbi_trubnaya-dyuymovaya-g/diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip-rezbi_trubnaya-dyuymovaya-k/diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip-rezbi_trubnaya-dyuymovaya-r/diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~1/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~1-1/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~1-2/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~1-4/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~1-6/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~1-8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~2/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~2-2/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~2-5/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~2-6/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~3/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~3-5/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~4/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~4-5/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~5/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~6/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~7/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~9/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~10/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~11/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_12~18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_14~18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~15/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_16~18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~20/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~22/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~24/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~27/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~30/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~32/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~33/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~36/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~39/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~40/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~42/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~45/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~48/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~50/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~52/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~56/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~60/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~64/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~76/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18~95/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-1-2/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-1-4/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-1-8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-3-4/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-3-8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-16/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-2/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-4/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_1-8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_2/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_3-4/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_3-8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_5-8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/diametr-rezbi--dyuym_7-8/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-25/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-3/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-35/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-45/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-6/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-7/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-75/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-8~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-9/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~0-4/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_1~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_1-75~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_1-25~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_1-5~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_2~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_2-5~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_3~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_3-5~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_4~0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~4-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~5-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5~6/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/shag-rezbi--nitok-na-dyuym_11/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/shag-rezbi--nitok-na-dyuym_14/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/shag-rezbi--nitok-na-dyuym_18/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/shag-rezbi--nitok-na-dyuym_19/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/shag-rezbi--nitok-na-dyuym_27/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/shag-rezbi--nitok-na-dyuym_28/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy~gaechniy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy~mashinniy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy~ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy~chernovoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/napravlenie-podachi_leviy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/napravlenie-podachi_praviy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/tip-otverstiya_gluhie/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/tip-otverstiya_skvoznoe/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~38/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~41/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~44-5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~48/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_50~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~52/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~53/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~55/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~58/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~59/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~65/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~66/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~67/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~69/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_70~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~72/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_75~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~84/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~85/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~87/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~89/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~90/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~95/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~96/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_100~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~102/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~109/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~110/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~112/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~113/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~118/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~119/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_120~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_125~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~127/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_130~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_135~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~137/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_138~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_140~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~144/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~149/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~151/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_160~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~162/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_165~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_170~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_175~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_180~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~187/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_195~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_200~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~220/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80~223/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_225~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_250~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_280~80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_2-24/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_2-5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_2-8/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_2-80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_3-15/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_3-55/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_4/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_4-5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_4-50/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_5-6/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_6-30/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_6-3/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_7-1/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_7-9/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_8/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_8-00/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_8-3/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_9/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_9-00/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_10-00/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_10-7/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_11-2/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_12-50/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_12-5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_13-4/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_14/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_14-00/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_14-1/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_16/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_16-00/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_17/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_17-7/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_18/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_18-00/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_20/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_20-00/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_21-3/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_21-8/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_22-4/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_22-40/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_25/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_26-8/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_27-3/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_28/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_31-5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_33-7/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_34-1/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_35-5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_40/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_42-4/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_42-9/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_48-3/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_49/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_60-1/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/diametr-hvostovika--mm_61-2/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_bistrorejuschaya-kobaltovaya-stal-hsse/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_bistrorejuschaya-poroshkovaya-kobaltovaya-stal-hsse-pm/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_bistrorejuschaya-poroshkovaya-stal-pmx/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_bistrorejuschaya-stal-hss/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_vk8/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r12/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r12f2k8m3/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r18/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r18f2k8m/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r6am5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r6m5/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r9/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r9m3/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_r9m4k8/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/material_9hs/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~5-5/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~8/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~9-5/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~10/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_11~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_13~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~14/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~15/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~16/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_18~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_20~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~21/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_22~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_24~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_25~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~26/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_28~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_29~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~30/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_32~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_33~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~36/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_37~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~38/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_39~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_40~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~41/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~42/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_45~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~48/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~50/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~51/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_57~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_60~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_67~19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~70/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~76/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19~82/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_din-357/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_din352/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_din371/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_din374/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_din376/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_gost-1604-71/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_gost-3266/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/tehnicheskiy-standart_gost-3266-81/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 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` = 229 AND afv.`attr_text` IN ('229_11') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 255 AND afv.`attr_text` IN ('255_19') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 282 AND afv.`attr_text` IN ('282_1') ) tafv3 ON (afv.`product_id` = tafv3.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 341 AND afv.`attr_text` IN ('341_43') ) tafv4 ON (afv.`product_id` = tafv4.`product_id`) WHERE afv.`attribute_id` = 197 AND afv.`attr_text` IN ('197_104') ) 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 (422)) 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` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz/cena_slider_prs' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 LIMIT 1

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'diametr-rezbi--mm_18/shag-rezbi--mm_0-5/vid-metchika_mashinno-ruchnoy/dlina--mm_80/dlina-rabochey-chasti--mm_19/proizvoditeli_hortz' AND `route` = 'category_id' AND `route_id` = 422 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 = '422' 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 = '422' 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 = '422' 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 = '422' 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 = '422' ORDER BY date_added DESC LIMIT 0, 4)) a LIMIT 4

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 = 'b68aec6ad44a3317d3d24b9572'

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 = 'b68aec6ad44a3317d3d24b9572'

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 = 'b68aec6ad44a3317d3d24b9572'

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

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

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` = '422'

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

Метчики

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

Самовывоз, сегодня
Рекомендуем
Артикул 915789
0
в наличии 79 шт.
1 362 руб.
Артикул 915788
0
в наличии 80 шт.
1 362 руб.
Артикул 915787
0
в наличии 80 шт.
1 213 руб.
Артикул 915786
0
в наличии 80 шт.
1 213 руб.
Артикул 915785
0
в наличии 80 шт.
1 063 руб.
Артикул 915784
0
в наличии 80 шт.
1 063 руб.
Артикул 915783
0
в наличии 100 шт.
932 руб.
Артикул 915782
0
в наличии 100 шт.
932 руб.
Артикул 915781
Артикул 915780
Артикул 915779
0
в наличии 100 шт.
716 руб.
Артикул 915778
0
в наличии 100 шт.
716 руб.
Артикул 915777
Артикул 915776
0
в наличии 200 шт.
618 руб.
Артикул 915775
0
в наличии 194 шт.
547 руб.
Артикул 915774
0
в наличии 198 шт.
509 руб.
Артикул 915773
0
в наличии 284 шт.
460 руб.
Артикул 915772
0
в наличии 300 шт.
403 руб.
Артикул 915771
0
в наличии 500 шт.
370 руб.
Артикул 915770
0
в наличии 460 шт.
312 руб.
Артикул 915769
0
в наличии 441 шт.
288 руб.
Артикул 915768
0
в наличии 490 шт.
246 руб.
Артикул 915767
0
в наличии 435 шт.
228 руб.
Артикул 915766
0
в наличии 486 шт.
191 руб.
Артикул 915765
0
в наличии 415 шт.
171 руб.
Артикул 915764
0
в наличии 500 шт.
145 руб.
Артикул 915763
0
в наличии 327 шт.
132 руб.
Артикул 1148688
0
в наличии 490 шт.
132 руб.
Артикул 915762
0
в наличии 435 шт.
109 руб.
Артикул 915761
0
в наличии 480 шт.
89 руб.
Артикул 915760
0
в наличии 500 шт.
77 руб.
Артикул 1148703
0
в наличии 500 шт.
77 руб.
Артикул 1148702
0
в наличии 410 шт.
77 руб.
Артикул 1148687
0
в наличии 494 шт.
67 руб.
Показать ещё
Популярные товары

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

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

REPLACE INTO `oc_session` SET session_id = 'b68aec6ad44a3317d3d24b9572', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\",\"formcreator_email\":\"sitomo@sitomo.ru\"}', expire = '2025-06-25 17:44:52'