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 = '5875fefc6ed17642335c498baf' AND expire > 1773406589;

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

SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' 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 = '0') 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 = '0') 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` = 'vnesen-v-gosreestr_da' LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'nomer-grsi_-40149-08' LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

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

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

select * from oc_filter_vier_hl f1 left join oc_filter_vier_hl_lang f2 on(f1.id=f2.id) where f1.short_link='nomer-grsi_-40149-08';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '780' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

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

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '800' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

select * from oc_category where tag_cat_id!=0 and category_id=800;

SELECT min_price, tax_class_id FROM oc_category_count WHERE category_id = 800;

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' 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 = '800' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.tag_cat_id = '0' ORDER BY c.sort_order, LCASE(cd.name) ;

SELECT p.tax_class_id FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '800' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' ORDER BY p.tax_class_id DESC LIMIT 20;

SELECT `layout_id` FROM `oc_category_to_layout` WHERE `category_id` = 800 AND `store_id` = 0 LIMIT 1;

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

SELECT `layout_module_id` FROM `oc_layout_module` WHERE `layout_id` = 27 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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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` = 800 AND p.`status` = 1 AND p2s.`store_id` = 0 ;

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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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_special` AS psp ON psp.`product_id` = p.`product_id` WHERE p2c.`category_id` = 800 AND p.`status` = 1 AND p2s.`store_id` = 0 GROUP BY p.`product_id` ORDER BY CASE WHEN psp.product_id IS NULL THEN 0 ELSE 1 END DESC, IF(p.`quantity` = '0', 1, 0), IF(p.`price` = '0', 1, 0), CASE WHEN p.`manufacturer_id` = 13 THEN 50 WHEN p.`manufacturer_id` = 15 THEN 45 WHEN p.`manufacturer_id` = 14 THEN 40 WHEN p.`manufacturer_id` = 12 THEN 30 WHEN p.`manufacturer_id` = 32 THEN 20 WHEN p.`manufacturer_id` = 29 THEN 10 WHEN p.`manufacturer_id` = 41 THEN 5 WHEN p.`manufacturer_id` IS NOT NULL THEN 3 ELSE 0 END DESC, p.`price` ASC, p.`sort_order` ASC LIMIT 0,36;

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '28882' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '32494' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '63912' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '28884' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '28883' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '33430' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '28842' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '33429' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

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

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

SELECT p.product_id, p.price, (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_product_to_category p2c 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 = '0' AND p2c.category_id = '800' GROUP BY p.product_id ORDER BY (p.product_id IN (SELECT product_id FROM oc_product_special)) DESC, IF(p.`quantity` = '0', 1, 0), IF(p.`price` = '0', 1, 0), CASE WHEN p.`manufacturer_id` = 13 THEN 50 WHEN p.`manufacturer_id` = 15 THEN 45 WHEN p.`manufacturer_id` = 14 THEN 40 WHEN p.`manufacturer_id` = 12 THEN 30 WHEN p.`manufacturer_id` = 32 THEN 20 WHEN p.`manufacturer_id` = 29 THEN 10 WHEN p.`manufacturer_id` = 41 THEN 5 WHEN p.`manufacturer_id` IS NOT NULL THEN 3 ELSE 0 END DESC, p.`price` ASC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,28;

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '8101' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '15446' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '8104' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '16361' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '8108' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '58752' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '8103' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '16358' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '31073' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '44310' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '19201' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '44750' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '44751' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '3670' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '3424' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '3693' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '64763' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '16360' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '19190' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '26231' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '7667' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '3425' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '16357' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '20543' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '28061' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '28062' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '10078' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT DISTINCT *, (SELECT AVG(r.rating) FROM oc_review r WHERE r.product_id = p.product_id AND r.status = '1') 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, 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, 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 = '11146' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT count(*) as c FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='opentdchiz' AND TABLE_NAME='oc_category' AND COLUMN_NAME='noindex';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '8101';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8101' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8101' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8101' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '8101';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '15446';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '15446' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '15446' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '15446' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '15446';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '8104';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8104' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8104' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8104' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '8104';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '16361';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16361' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16361' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16361' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '16361';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '8108';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8108' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8108' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8108' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '8108';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '930' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '58752';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '58752' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '58752' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '58752' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '58752';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '8103';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8103' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8103' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '8103' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '8103';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '16358';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16358' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16358' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16358' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '16358';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '31073';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '31073' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '31073' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '31073' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '31073';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '44310';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44310' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44310' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44310' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '44310';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '19201';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '19201' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '19201' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '19201' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '19201';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '44750';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44750' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44750' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44750' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '44750';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '44751';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44751' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44751' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '44751' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '44751';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '3670';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3670' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3670' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3670' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '3670';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '3424';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3424' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3424' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3424' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '3424';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '3693';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3693' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3693' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3693' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '3693';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '64763';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '64763' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '64763' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '64763';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '933' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '16360';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16360' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16360' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16360' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '16360';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '19190';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '19190' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '19190' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '19190' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '19190';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '26231';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '26231' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '26231' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '26231' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '26231';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '7667';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '7667' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '7667' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '7667' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '7667';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '930' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '3425';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3425' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3425' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '3425' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '3425';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '16357';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16357' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16357' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '16357' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '16357';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '20543';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '20543' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '20543' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '20543' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '20543';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '28061';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28061' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28061' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28061' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '28061';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '28062';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28062' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28062' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28062' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '28062';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '10078';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '10078' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '10078' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '10078' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '10078';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '11146';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '11146' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '11146' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '11146' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '11146';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '931' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '28882';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28882' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28882' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28882' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '28882';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '32494';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '32494' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '32494' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '32494' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '32494';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '63912';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '63912' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '63912' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '63912' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '63912';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '28884';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28884' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28884' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28884' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '28884';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '28883';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28883' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28883' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28883' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '28883';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '33430';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '33430' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '33430' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '33430' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '33430';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '28842';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28842' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28842' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '28842' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '28842';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '33429';

SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '33429' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '33429' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.attribute_id NOT IN (30,31,32,88) AND pa.product_id = '33429' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name;

SELECT * FROM oc_product_to_category WHERE product_id = '33429';

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '932' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

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

SELECT *, IF(td.name_short IS NULL or td.name_short = '', td.name, td.name_short) as name, (select category_id from oc_tag_to_category where tag_id = t.tag_id) as category_id, (select count(*) from oc_product_to_tag where tag_id = t.tag_id) as kol FROM oc_tag t INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id) INNER JOIN oc_tag_to_store ts ON (t.tag_id = ts.tag_id) INNER JOIN oc_tag_to_category ttc ON (ttc.tag_id = t.tag_id) WHERE td.language_id = '1' AND ts.store_id = '0' AND t.status = '1' AND ttc.category_id = '800' group by t.tag_id ORDER BY kol desc;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category_grid';

SELECT * FROM oc_category_links WHERE category_id = '800' ORDER BY sort_order ASC;

select * from oc_filter_vier_hl where route='category_id' and route_id=800 GROUP BY `short_link`;

select * from oc_filter_vier_hl_lang where keywords!=1 and id=44;

select name from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diapazon-izmereniy');

select name from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'tip');

select name,(select main_id from oc_url_filter_vier where seo_url = 'diapazon-izmereniy') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'diapazon-izmereniy');

select * from oc_filter_vier_hl_lang where keywords!=1 and id=176;

select name,(select main_id from oc_url_filter_vier where seo_url = 'cena-deleniya--mm') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'cena-deleniya--mm');

select * from oc_filter_vier_hl_lang where keywords!=1 and id=177;

select name,(select main_id from oc_url_filter_vier where seo_url = 'cena-deleniya--mm') as attr_id from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'cena-deleniya--mm');

select * from oc_filter_vier_hl_lang where keywords!=1 and id=982;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=970;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=983;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=978;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=971;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=979;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=980;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=972;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=981;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=973;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=974;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=975;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=976;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=977;

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

select * from oc_filter_vier_hl_lang where keywords!=1 and id=1254;

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

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

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

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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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` = 800 AND p.`status` = 1 AND p2s.`store_id` = 0 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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY p.`manufacturer_id`;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_cnic' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_garant' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_hoffmann' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_holex' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_insize' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_kinex' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_ks' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_mahr' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_micron' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_mitutoyo' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_norgau' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_shahe' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_shan' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_tesa-technology' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_tlx' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_vogel' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_germaniya' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_gto' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_izmeron' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_kalibron' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_kirovinstrument' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_rossiya' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_tm' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_chiz' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_etalon' AND `route` = 'category_id' AND `route_id` = 800 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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND afv.`attribute_id` IN (23,24,25,26,27,28,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,63,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,83,85,86) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY `attr_text`;

SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_77') ) 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 (800)) AND afv.`attribute_id` IN (87) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY `attr_text`;

SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND afv.`attribute_id` IN (62) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY `attr_text`;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_3-5/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_4/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_5/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_5-5/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_6/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_7/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_40/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_55/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-1' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-3' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-8' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0--2' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-12' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-2' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-5' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-8' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-10' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-100' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-12-5' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-12-7' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-25' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-5' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-50' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'kalibrovka_da/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/klass-tochnosti_0/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/klass-tochnosti_1/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-36014-15' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-57938-14~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-64188-16' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-66574-17' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-66785-17' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-69403-17' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-69468-17~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-71458-18' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-82371-21~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-82404-21~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-89203-23' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-93114-24~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-93411-24~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-93622-24~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-95109-25' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'poverka-_da/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'ushko_est/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'ushko_net/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-001' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-002' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-005' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-01' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-1' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_irb' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_irt' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_it' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_ic' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_icb' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_ich' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_ichc' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_1ichs' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_1icht' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_1mig' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_2ichs' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_2icht' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_2mig' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_3icht' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_20' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_30' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_40' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_50' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_60' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_70' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_80' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_85' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_90' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_95' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_100' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_104' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_105' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_110' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_113' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_115' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_120' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_125' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_130' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_135' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_140' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_145' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_150' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_155' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_160' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_170' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_195' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_200' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_210' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_215' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_230' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_250' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_260' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_270' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_280' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_295' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_300' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_325' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_350' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_385' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_405' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_440' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_460' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_465' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_470' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT MIN( IF(((ps.`customer_group_id` = 1) AND (ps.`date_start` = '0000-00-00' OR ps.`date_start` <= '2026-03-13') AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > '2026-03-13')), ps.`price`, IF(((pd2.`customer_group_id` = 1) AND (pd2.`date_start` = '0000-00-00' OR pd2.`date_start` <= '2026-03-13') AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > '2026-03-13')) AND (pd2.`quantity` = 1), pd2.`price`, p.`price`)) ) AS price_min, MAX( IF(((ps.`customer_group_id` = 1) AND (ps.`date_start` = '0000-00-00' OR ps.`date_start` <= '2026-03-13') AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > '2026-03-13')), ps.`price`, IF(((pd2.`customer_group_id` = 1) AND (pd2.`date_start` = '0000-00-00' OR pd2.`date_start` <= '2026-03-13') AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > '2026-03-13')) AND (pd2.`quantity` = 1), pd2.`price`, p.`price`)) ) AS price_max FROM `oc_product` p LEFT JOIN `oc_product_special` AS ps ON (p.`product_id` = ps.`product_id` AND ps.`customer_group_id` = 1) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) LEFT JOIN `oc_product_discount` AS pd2 ON (p.`product_id` = pd2.`product_id` AND pd2.`customer_group_id` = 1) 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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND p.`status` = 1 AND p2s.`store_id` = 0 ;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena_slider_prs' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '800' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/filter_vier/filter_vier';

SELECT * FROM oc_module WHERE module_id = '71';

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

SELECT * FROM oc_prostore_blog_related_cat pr LEFT JOIN oc_prostore_blog p ON (pr.blog_id = p.blog_id) LEFT JOIN oc_prostore_blog_description pbd ON (p.blog_id = pbd.blog_id) LEFT JOIN oc_prostore_blog_to_store p2s ON (p.blog_id = p2s.blog_id) WHERE pr.related_id = '800' AND p.status = '1' AND p2s.store_id = '0' AND pbd.language_id = '1' ORDER BY p.date_added DESC LIMIT 6;

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '800' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

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

SELECT category_id FROM oc_prostore_blog_to_category WHERE blog_id = '6' ORDER BY category_id DESC LIMIT 1;

SELECT GROUP_CONCAT(c1.category_id ORDER BY level SEPARATOR '_') blog_path FROM oc_prostorecat_blog_path cp LEFT JOIN oc_prostorecat_blog c1 ON (cp.path_id = c1.category_id) WHERE cp.category_id = 1 GROUP BY cp.category_id;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_blog_mod_column';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left';

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right';

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top';

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

SELECT * FROM oc_module WHERE module_id = '75';

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

SELECT `keyword` FROM `oc_seo_url` WHERE `query` = CONCAT('category_id=',800) AND store_id = 0;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_reviews';

SELECT * FROM oc_module WHERE module_id = '69';

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

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom';

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

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

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru');

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' 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 = '6' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '44' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '43' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '45' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '9' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '31' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '32' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '33' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '12' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '11' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoresoclinks';

SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks';

SELECT * FROM oc_country WHERE country_id = '176' AND status = '1';

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 = '5' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback';

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 = '41' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/footer';

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 = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC;

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

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

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_wishlist';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_compare';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru');

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/language';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru');

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency';

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search_mob' OR route = 'ru-ru');

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search_mob';

SELECT * FROM oc_translation WHERE store_id = '0' 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 = '5875fefc6ed17642335c498baf';

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

SELECT * FROM oc_translation WHERE store_id = '0' 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 = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_translation WHERE store_id = '0' 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 = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru');

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/cart';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_7';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header';

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

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

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

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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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` = 800 AND p.`status` = 1 AND p2s.`store_id` = 0 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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY p.`manufacturer_id`;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_cnic' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_garant' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_hoffmann' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_holex' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_insize' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_kinex' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_ks' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_mahr' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_micron' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_mitutoyo' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_norgau' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_shahe' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_shan' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_tesa-technology' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_tlx' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_vogel' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_germaniya' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_gto' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_izmeron' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_kalibron' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_kirovinstrument' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_rossiya' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_tm' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_chiz' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08/vnesen-v-gosreestr_da/proizvoditeli_etalon' AND `route` = 'category_id' AND `route_id` = 800 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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND afv.`attribute_id` IN (23,24,25,26,27,28,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,63,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,83,85,86) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY `attr_text`;

SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_77') ) 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 (800)) AND afv.`attribute_id` IN (87) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY `attr_text`;

SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND afv.`attribute_id` IN (62) AND p2s.`store_id` = 0 AND p.`status` = 1 GROUP BY `attr_text`;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_3-5/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_4/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_5/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_5-5/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_6/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_7/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_40/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/visota--sm_55/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-1' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-3' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-8' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0--2' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-12' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-2' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-5' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-0-8' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-10' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-100' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-12-5' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-12-7' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-25' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-5' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/diapazon-izmereniy_0-50' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'kalibrovka_da/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/klass-tochnosti_0/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/klass-tochnosti_1/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-36014-15' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-57938-14~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-64188-16' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-66574-17' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-66785-17' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-69403-17' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-69468-17~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-71458-18' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-82371-21~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-82404-21~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-89203-23' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-93114-24~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-93411-24~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-93622-24~-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08~-95109-25' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'poverka-_da/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'ushko_est/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'ushko_net/vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-001' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-002' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-005' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-01' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena-deleniya--mm_0-1' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_irb' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_irt' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_it' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_ic' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_icb' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_ich' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_ichc' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_1ichs' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_1icht' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_1mig' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_2ichs' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_2icht' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_2mig' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/tip_3icht' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_20' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_30' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_40' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_50' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_60' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_70' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_80' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_85' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_90' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_95' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_100' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_104' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_105' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_110' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_113' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_115' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_120' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_125' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_130' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_135' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_140' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_145' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_150' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_155' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_160' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_170' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_195' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_200' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_210' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_215' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_230' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_250' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_260' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_270' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_280' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_295' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_300' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_325' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_350' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_385' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_405' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_440' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_460' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_465' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/dlina--mm_470' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT MIN( IF(((ps.`customer_group_id` = 1) AND (ps.`date_start` = '0000-00-00' OR ps.`date_start` <= '2026-03-13') AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > '2026-03-13')), ps.`price`, IF(((pd2.`customer_group_id` = 1) AND (pd2.`date_start` = '0000-00-00' OR pd2.`date_start` <= '2026-03-13') AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > '2026-03-13')) AND (pd2.`quantity` = 1), pd2.`price`, p.`price`)) ) AS price_min, MAX( IF(((ps.`customer_group_id` = 1) AND (ps.`date_start` = '0000-00-00' OR ps.`date_start` <= '2026-03-13') AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > '2026-03-13')), ps.`price`, IF(((pd2.`customer_group_id` = 1) AND (pd2.`date_start` = '0000-00-00' OR pd2.`date_start` <= '2026-03-13') AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > '2026-03-13')) AND (pd2.`quantity` = 1), pd2.`price`, p.`price`)) ) AS price_max FROM `oc_product` p LEFT JOIN `oc_product_special` AS ps ON (p.`product_id` = ps.`product_id` AND ps.`customer_group_id` = 1) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) LEFT JOIN `oc_product_discount` AS pd2 ON (p.`product_id` = pd2.`product_id` AND pd2.`customer_group_id` = 1) 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` = 62 AND afv.`attr_text` IN ('62_77') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) 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 (800)) AND p.`status` = 1 AND p2s.`store_id` = 0 ;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08/cena_slider_prs' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT tr.`rate` FROM `oc_tax_rate_to_customer_group` trtcg LEFT JOIN `oc_tax_rate` tr USING(`tax_rate_id`) LEFT JOIN `oc_tax_rule` tr1 USING(`tax_rate_id`) WHERE trtcg.`customer_group_id` = 1 AND tr.`type` = 'p' ORDER BY tr1.`priority` ASC LIMIT 1 ;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '800' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/filter_vier/filter_vier';

SELECT * FROM oc_module WHERE module_id = '71';

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

SELECT * FROM oc_prostore_blog_related_cat pr LEFT JOIN oc_prostore_blog p ON (pr.blog_id = p.blog_id) LEFT JOIN oc_prostore_blog_description pbd ON (p.blog_id = pbd.blog_id) LEFT JOIN oc_prostore_blog_to_store p2s ON (p.blog_id = p2s.blog_id) WHERE pr.related_id = '800' AND p.status = '1' AND p2s.store_id = '0' AND pbd.language_id = '1' ORDER BY p.date_added DESC LIMIT 6;

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) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '800' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

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

SELECT category_id FROM oc_prostore_blog_to_category WHERE blog_id = '6' ORDER BY category_id DESC LIMIT 1;

SELECT GROUP_CONCAT(c1.category_id ORDER BY level SEPARATOR '_') blog_path FROM oc_prostorecat_blog_path cp LEFT JOIN oc_prostorecat_blog c1 ON (cp.path_id = c1.category_id) WHERE cp.category_id = 1 GROUP BY cp.category_id;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_blog_mod_column';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left';

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right';

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top';

SELECT * FROM oc_category_to_layout WHERE category_id = '800' AND store_id = '0';

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

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

SELECT * FROM oc_module WHERE module_id = '75';

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

SELECT `keyword` FROM `oc_seo_url` WHERE `query` = CONCAT('category_id=',800) AND store_id = 0;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/prostore_reviews';

SELECT * FROM oc_module WHERE module_id = '69';

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

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom';

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

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

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru');

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' 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 = '6' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '44' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '43' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '45' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '9' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '31' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '32' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '33' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '12' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

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 = '11' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoresoclinks';

SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks';

SELECT * FROM oc_country WHERE country_id = '176' AND status = '1';

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 = '5' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback';

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 = '41' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/footer';

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 = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC;

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

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

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_wishlist';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_compare';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru');

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/language';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru');

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'vnesen-v-gosreestr_da/nomer-grsi_-40149-08' AND `route` = 'category_id' AND `route_id` = 800 LIMIT 1;

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency';

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search_mob' OR route = 'ru-ru');

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search_mob';

SELECT * FROM oc_translation WHERE store_id = '0' 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 = '5875fefc6ed17642335c498baf';

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

SELECT * FROM oc_translation WHERE store_id = '0' 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 = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_translation WHERE store_id = '0' 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 = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru');

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru');

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5875fefc6ed17642335c498baf';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/cart';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_7';

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header';

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

SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category12';

Индикаторы купить
Меню
Корзина 00.00 ₽
    Поддержка

    Каталог
      Поиск
      info@tdchiz.ru
      Скопировать почту
      Корзина 00.00 ₽
      Корзина
      Ваша корзина пуста!
      Глубиномеры Измерительные головки, микаторы, микрокаторы Индикаторы Кольца образцовые, установочные Линейки Меры длины Меры твердости Метры складные Микрометры Наборы щупов
      Нутромеры Образцы шероховатости (ОШС) Пластины стеклянные типа ПМ, ПИ Плиты поверочные и разметочные Призмы поверочные Принадлежности к измерительному инструменту Проволочки и ролики Разметочный инструмент Рулетки Секундомеры
      Скобы Стенкомеры Стойки и штативы Толщиномеры Угломеры Угольники Уровни Шаблоны сварщика Штангенинструмент Штангенциркули
      Калибры гладкие для отверстий и валов Калибры для дюймовой резьбы стандарта ACME Калибры для дюймовой унифицир. резьбы UN Калибры для конич. резьбы вентелей и баллонов д/газов W Калибры для конической дюймовой резьбы K Калибры для конусных соединений
      Калибры для конусов инструментов (Морзе) Калибры для метрической резьбы М Калибры для трап-ой n-зах резьбы Tr (P) Калибры для трапецеидальной резьбы Tr Калибры для трубной конической резьбы R Калибры для трубной цилиндрической резьбы G
      Калибры для упорной резьбы S Калибры для шлицевых и шпоночных соединений Калибры прочие Калибры-пробки для конусов Морзе Ручки для калибров
      Калибры для НК труб РНК-В,ГНК-В Калибры для НК труб гладких РНК, ГНК Калибры для бурильных труб высаженные РБН(В), ГБН(В) Калибры для забойных двигателей (МК,РКТ)
      Калибры для замковой резьбы PЗ, ГЗ Калибры для обсадных трапецеидальных труб ОТТМ Калибры для обсадных труб РО,ГО Калибры для резьбы на насосные штанги Ш (ШН)
      Калибры для трапецеидальной резьбы НК труб НКМ Калибры для упорной резьбы BCSG (Батресс) Калибры колонкового геологоразведочного бурения Прочие нефтяные калибры
      Микрометры МКН Штангентрубомер ШТН
      Втулки переходные Защитные экраны для станков Крепежная оснастка (УСП) Оправки Патроны сверлильные, токарные и т.п Резцедержатели, держатели сверл Столы поворотные, неповоротные Тиски станочные
      Шаблоны ЖД Щупы ЖД
      Биениемеры Инструментальные микроскопы Квадранты Лабораторное оборудование Метрологическое оборудование Оптиметры Принадлежности Прочие приборы
      Буры Воротки для метчиков и плашек Метчики для резьбы Плашки Полотна ножовочные по металлу Сверла Токарные резцы Фрезы
      Бородки слесарные Гвоздодеры Головки сменные и принадлежности Зубила Инструментальные наборы Кернеры Клейма Ключи
      Кувалды Кусачки Лопатка монтажная (монтировка) Молотки Надфили Напильники Ножницы Отвертки
      Плоскогубцы Рамки ножовочные Рашпили Тиски слесарные Топоры Щетки металлические Ящики и сумки инструментальные
      Каталог Поиск Корзина Корзина 00.00 ₽ Сравнение Войти

      Индикаторы

      8 товаров
       Фильтр товаров
      Цена
      Внесен в Госреестр
      показать Больше
      Высота, см
      показать Больше
      Диапазон измерений
      показать Больше
      Калибровка
      показать Больше
      Класс точности
      показать Больше
      Номер ГРСИ
      показать Больше
      Поверка
      показать Больше
      Ушко
      показать Больше
      Цена деления, мм
      показать Больше
      Тип
      показать Больше
      Длина, мм
      показать Больше
      Бренд
      показать Больше
      8Показать
      Индикаторы у нас в блоге
      Часто ищут
      Цена деления, мм:
      0,001
      0,01
      Бренд:
      CNIC
      INSIZE
      Kinex
      MAHR
      MITUTOYO
      Micron
      NORGAU
      SHAN
      ГТО
      Измерон
      Калиброн
      КировИнструмент
      ЧИЗ
      Эталон
      Поверка:
      С поверкой
      Диапазон измерений, Тип:
      часовые индикаторы ИЧ 10

      Индикатор – это многофункциональный инструмент, использующийся в промышленности для контроля выпускаемой продукции. Применяется совместно с дополнительным оборудованием, таким как штативы, скобы и разнообразные подставки. Подставки и штативы должны отвечать некоторым требованиям: они должны быть массивными и устойчивыми или прикручиваться к столу или станку. Фиксируется крепежное оборудование болтами, либо, если поставка магнитная, напрямую устанавливается на вертикальную или наклонную поверхность.


      Выпускают несколько типов индикаторов:

       

      • Индикаторы часового типа – самый распространенный на промышленности вид. Его действие основано на работе реечно-зубчатой и шестеренной передачи. Возвратно-поступательное движение измерительного стержня преобразуется во вращательное движение стрелки индикатора. Как правило, индикатор часового типа многооборотный, то есть число оборотов отсчитывает отдельный циферблат.
      • Рычажно-зубчатые индикаторы имеют в основе неравноплечный рычаг.  Малое плечо рычага связано с измерительным стержнем, либо с измеряемой поверхностью, а большое плечо - со вторым неравноплечим рычагом и зубчатой передачей со стрелкой. Этот вид так же имеет индикатор часового типа. Для отсчитывания оборотов может присутствовать отдельный циферблат. Рычажно-зубчатый индикатор обладает большей точностью по сравнению с индикаторным, его цена деления составляет от 0,001 до 0,002 мм. 
      • Многооборотные индикаторы схожи по строению и функционалу с индикаторами часового типа. Их действие также основано на работе реечно-зубчатой и шестеренной передачи. Особенность прибора – в многооборотном циферблате, на котором нанесено 200 делений круговой шкалы и расположен указатель числаоборотов стрелки, полное число оборотов которой 5. Таким образом, по сравнению с остальными, у этого вида диапазон измерений самый большой.
      • Электронные индикаторы позволяют быстро и качественно снять показания, а также обладают расширенным функционалом. Благодаря кнопочному блоку прибор легко выставляется на «нуль», меняется система исчисления с метрической на дюймовую, устанавливаются пределы по допуску и др. Прибор работает на основе рычажно-зубчатой или шестеренной передачи, результаты измерений выводятся на цифровой дисплей.

       

      Индикаторы соответствуют ГОСТ 577-68, ГОСТ 9696-82 и ГОСТ 5584-75, а так же требованиям технической документации фирмы-изготовителя. 

      Отзывы Все отзывы категории
      Индикатор часового типа ИЧ- 5 0,01 без ушка ЧИЗ*
      Индикатор часового типа ИЧ- 5 0,01 без ушка ЧИЗ*

      Специально брал на измерения от 0 до 5, наиболее проблемные для нас, да и детали, что мы производим ..

      26.03.2025 Читать полный отзыв
      А Александр Оценил(а) товар на 5
      Индикатор часового типа ИЧ-100 0,01 без ушка ЧИЗ
      Индикатор часового типа ИЧ-100 0,01 без ушка ЧИЗ

      Стержень прочный и достаточно чувствительный, первое время с опаской применяли, все же дорогой инстр..

      25.03.2025 Читать полный отзыв
      А Арсений Оценил(а) товар на 5
      Индикатор часового типа ИЧ- 25 0,01 без ушка ЧИЗ
      Индикатор часового типа ИЧ- 25 0,01 без ушка ЧИЗ

      Недавно приобрел индикатор часового типа, он стал незаменимым помощником в производственном процессе..

      23.03.2025 Читать полный отзыв
      О Олег Оценил(а) товар на 5
      Индикатор часового типа ИЧ- 2 0,01 с ушком ЧИЗ*
      Индикатор часового типа ИЧ- 2 0,01 с ушком ЧИЗ*

      Мы используем его для контроля точности обработки деталей, и он зарекомендовал себя как надежный и т..

      07.03.2025 Читать полный отзыв
      А Артур Оценил(а) товар на 5
      Индикатор часового типа ИЧ- 10 0,01 с ушком ЧИЗ*
      Индикатор часового типа ИЧ- 10 0,01 с ушком ЧИЗ*

      Индикатор часового типа ИЧ-10 с точностью 0,01 мм — это отличное решение для контроля качества на на..

      07.03.2025 Читать полный отзыв
      К Кирилл Оценил(а) товар на 5
      Индикатор часового типа ИЧ- 5 0,01 с ушком ЧИЗ*
      Индикатор часового типа ИЧ- 5 0,01 с ушком ЧИЗ*

      Прошлый индикатор приказал долго жить, этот подходил по размерам и шкале измерений, в деле показал с..

      23.02.2025 Читать полный отзыв
      Г Геннадий Оценил(а) товар на 5
      Выберите обязательные опции
      Быстрый заказ

      Мы используем файлы cookie и другие средства сохранения предпочтений и анализа действий посетителей сайта. Подробнее в ИСПОЛЬЗОВАНИЕ ФАЙЛОВ COOKIE И ЯНДЕКС.МЕТРИКИ. Нажмите «Принять», если даете согласие на это.

      Принять
      REPLACE INTO `oc_session` SET session_id = '5875fefc6ed17642335c498baf', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\",\"view\":\"grid-4\"}', expire = '2026-03-13 13:20:37';