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 = 'eeed7fa3fe63f39b981a8c6514' AND expire > 1773413545;

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` = 'gubki_125' LIMIT 1;

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_-91149-24' LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 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_-91149-24';

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 = '861' 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 = '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 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 = '914' 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=914;

SELECT min_price, tax_class_id FROM oc_category_count WHERE category_id = 914;

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 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 = '914' 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` = 914 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` = 87 AND afv.`attr_text` IN ('87_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 914 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` = 87 AND afv.`attr_text` IN ('87_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) LEFT JOIN `oc_product_special` AS psp ON psp.`product_id` = p.`product_id` WHERE p2c.`category_id` = 914 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 = '10072' 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 = '57802' 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 = '16405' 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 = '10071' 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 = '10069' 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 = '7324' 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 = '7326' 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 = '57806' 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 = '10070' 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 = '57818' 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 = '57949' 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 = '861' 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 = '914' 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,25;

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 = '67056' 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 = '67057' 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 = '21323' 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 = '44756' 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 = '67289' 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 = '32415' 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 = '7392' 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 = '32413' 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 = '7659' 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 = '32414' 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 = '7390' 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 = '44758' 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 = '57893' 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 = '57880' 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 = '57956' 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 = '58563' 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 = '7323' 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 = '7658' 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 = '10072' 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 = '7322' 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 = '57802' 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 = '27534' 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 = '27535' 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 = '14481' 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 = '14916' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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 = 'eeed7fa3fe63f39b981a8c6514';

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

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 = '67056' 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 = '67056' 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 = '67056' 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 = '67056';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '67057' 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 = '67057' 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 = '67057' 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 = '67057';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '21323' 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 = '21323' 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 = '21323' 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 = '21323';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '44756' 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 = '44756' 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 = '44756' 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 = '44756';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '67289' 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 = '67289' 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 = '67289' 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 = '67289';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '32415' 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 = '32415' 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 = '32415' 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 = '32415';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7392' 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 = '7392' 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 = '7392' 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 = '7392';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '32413' 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 = '32413' 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 = '32413' 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 = '32413';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7659' 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 = '7659' 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 = '7659' 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 = '7659';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '32414' 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 = '32414' 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 = '32414' 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 = '32414';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7390' 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 = '7390' 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 = '7390' 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 = '7390';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '44758' 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 = '44758' 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 = '44758' 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 = '44758';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57893' 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 = '57893' 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 = '57893' 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 = '57893';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57880' 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 = '57880' 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 = '57880' 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 = '57880';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57956' 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 = '57956' 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 = '57956' 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 = '57956';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '58563' 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 = '58563' 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 = '58563' 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 = '58563';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7323' 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 = '7323' 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 = '7323' 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 = '7323';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7658' 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 = '7658' 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 = '7658' 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 = '7658';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '10072' 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 = '10072' 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 = '10072' 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 = '10072';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7322' 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 = '7322' 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 = '7322' 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 = '7322';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57802' 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 = '57802' 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 = '57802' 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 = '57802';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '27534' 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 = '27534' 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 = '27534' 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 = '27534';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '27535' 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 = '27535' 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 = '27535' 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 = '27535';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '14481' 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 = '14481' 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 = '14481' 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 = '14481';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '14916' 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 = '14916' 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 = '14916' 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 = '14916';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '10072' 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 = '10072' 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 = '10072' 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 = '10072';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57802' 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 = '57802' 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 = '57802' 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 = '57802';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '16405' 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 = '16405' 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 = '16405' 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 = '16405';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '10071' 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 = '10071' 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 = '10071' 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 = '10071';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '10069' 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 = '10069' 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 = '10069' 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 = '10069';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7324' 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 = '7324' 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 = '7324' 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 = '7324';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '7326' 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 = '7326' 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 = '7326' 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 = '7326';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57806' 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 = '57806' 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 = '57806' 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 = '57806';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '10070' 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 = '10070' 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 = '10070' 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 = '10070';

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 = '1490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57818' 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 = '57818' 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 = '57818' 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 = '57818';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT * FROM oc_product_special WHERE product_id = '10072' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

SELECT * FROM oc_product_special WHERE product_id = '57802' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY date_end DESC;

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

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

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 = '57949' 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 = '57949' 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 = '57949' 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 = '57949';

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 = '1492' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

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 = '914' 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 = '914' ORDER BY sort_order ASC;

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

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

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=706;

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=98;

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

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

select name from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'verhnyaya-granica--mm');

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

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

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

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

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

select name from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'verhnyaya-granica--mm');

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

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

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

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

select name from oc_attribute_description where attribute_id = (select main_id from oc_url_filter_vier where seo_url = 'verhnyaya-granica--mm');

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=703;

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=704;

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=686;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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=713;

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=714;

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=715;

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=708;

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=716;

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=709;

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=710;

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=711;

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=707;

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_filter_vier_hl_lang where keywords!=1 and id=712;

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=717;

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=718;

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_category_to_layout WHERE category_id = '914' 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 = '914' 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_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 = 'eeed7fa3fe63f39b981a8c6514';

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

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` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 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` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 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 = 'eeed7fa3fe63f39b981a8c6514';

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 = 'eeed7fa3fe63f39b981a8c6514';

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 = 'eeed7fa3fe63f39b981a8c6514';

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

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 = 'eeed7fa3fe63f39b981a8c6514';

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 = 'eeed7fa3fe63f39b981a8c6514';

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

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

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

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 = '914' 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` = 914 ;

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` = 87 AND afv.`attr_text` IN ('87_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p2c.`category_id` = 914 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` = 87 AND afv.`attr_text` IN ('87_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (p.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (914)) 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` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_cnic' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_guanglu' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_holex' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_kinex' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_mahr' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_micron' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_mitutoyo' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_norgau' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_shahe' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_shan' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_tesa-technology' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_tlx' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_gto' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_izmeron' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_kalibron' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_kirovinstrument' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_stiz' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_tm' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_chiz' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24/vnesen-v-gosreestr_da/proizvoditeli_etalon' AND `route` = 'category_id' AND `route_id` = 914 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` = 87 AND afv.`attr_text` IN ('87_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (afv.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (914)) 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,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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) 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 (914)) AND afv.`attribute_id` IN (53) 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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (afv.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (914)) 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 STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 87 AND afv.`attr_text` IN ('87_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (afv.`product_id` = tafv.`product_id`) LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (914)) 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` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_160/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_200/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_300/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_400/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_450/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_500/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_600/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_630/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_700/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_750/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_800/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_1000/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_1250/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_1500/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_1600/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_2000/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/verhnyaya-granica--mm_3000/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/visota--sm_3/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~45/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~80/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~90/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_100~125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~150/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~200/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~250/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~300/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~350/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~500/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125~550/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/kalibrovka_da/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24~-31008-14' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24~-62052-15' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24~-75563-19' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24~-77302-20' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24~-92450-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-93922-24~-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24~-96316-25' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-96750-25~-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/poverka-_da/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/cena-deleniya--mm_0-02' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/cena-deleniya--mm_0-05' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

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

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/tip_shc-3' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/tip_shcc-3' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/tip_shcct-3' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/cena-deleniya--dyuym_0-0005' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/cena-deleniya--dyuym_0-001' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_6' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_8' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_12' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_18' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_20' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_24' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_30' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_40' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_60' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/verhnyaya-granica--dyuym_80' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_125' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_220' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_245' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_420' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_500' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_520' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_575' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_580' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_585' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_615' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_620' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_630' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_680' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_685' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_690' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_700' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_710' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_715' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_720' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_725' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_800' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_810' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_815' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_820' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_830' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_845' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_850' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_880' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_915' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_920' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1000' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1065' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1080' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1100' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1110' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1115' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1150' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1200' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1250' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1275' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1280' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1300' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1305' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1310' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1400' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1470' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1500' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1560' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1700' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1800' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1900' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1910' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_1980' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_2000' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_2100' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_2200' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_2400' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_2470' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_2900' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_3400' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_3445' AND `route` = 'category_id' AND `route_id` = 914 LIMIT 1;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/dlina--mm_4450' AND `route` = 'category_id' AND `route_id` = 914 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` = 87 AND afv.`attr_text` IN ('87_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 62 AND afv.`attr_text` IN ('62_25') ) tafv2 ON (afv.`product_id` = tafv2.`product_id`) WHERE afv.`attribute_id` = 53 AND afv.`attr_text` IN ('53_2') ) tafv ON (p.`product_id` = tafv.`product_id`) WHERE p.`product_id` IN (SELECT p2c.`product_id` FROM `oc_product_to_category` p2c WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` IN (914)) AND p.`status` = 1 AND p2s.`store_id` = 0 ;

SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24/cena_slider_prs' AND `route` = 'category_id' AND `route_id` = 914 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` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 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 = '914' 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 = '914' 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 = '914' 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 = '1' 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 = '914' 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 = '914' 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 = '914' 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=',914) 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 = 'eeed7fa3fe63f39b981a8c6514';

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

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` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 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` = 'gubki_125/vnesen-v-gosreestr_da/nomer-grsi_-91149-24' AND `route` = 'category_id' AND `route_id` = 914 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 = 'eeed7fa3fe63f39b981a8c6514';

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 = 'eeed7fa3fe63f39b981a8c6514';

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 = 'eeed7fa3fe63f39b981a8c6514';

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

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 = 'eeed7fa3fe63f39b981a8c6514';

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 = 'eeed7fa3fe63f39b981a8c6514';

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

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

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

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

Штангенциркули ШЦ-3 купить
Меню
Корзина 00.00 ₽
    Поддержка

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

      Штангенциркули ШЦ-3

      11 товаров
       Фильтр товаров
      Цена
      Верхняя граница, мм
      показать Больше
      Внесен в Госреестр
      показать Больше
      Высота, см
      показать Больше
      Губки
      показать Больше
      Калибровка
      показать Больше
      Номер ГРСИ
      показать Больше
      Поверка
      показать Больше
      Цена деления, мм
      показать Больше
      Тип
      показать Больше
      Цена деления, дюйм
      показать Больше
      Верхняя граница, дюйм
      показать Больше
      Длина, мм
      показать Больше
      Бренд
      показать Больше
      11Показать
      Штангенциркули ШЦ-3 у нас в блоге
      Часто ищут
      Цена деления, мм:
      0.01
      0.02
      0.05
      0.1
      Бренд:
      Kinex
      MITUTOYO
      Micron
      NORGAU
      SHAN
      ГТО
      Измерон
      Калиброн
      КировИнструмент
      Стиз
      ТМ
      ЧИЗ
      Верхняя граница, мм:
      ШЦ-3-160
      ШЦ-3-200
      ШЦ-3-300
      ШЦ-3-400
      ШЦ-3-450
      ШЦ-3-500
      ШЦ-3-600
      ШЦ-3-630
      ШЦ-3-700
      ШЦ-3-750
      ШЦ-3-800
      ШЦ-3-1000
      ШЦ-3-1250
      ШЦ-3-1500
      ШЦ-3-1600
      ШЦ-3-2000
      ШЦ-3-2500
      ШЦ-3-3000
      ШЦ-3-4000
      Верхняя граница, мм, Цена деления, мм:
      ШЦ-3-400 0.05 мм
      ШЦ-3-500 0.01 мм
      Цена деления, мм, Верхняя граница, мм:
      ШЦ-3-500 0.05 мм
      Поверка:
      с поверкой

       

       

      Штангенциркуль типа ШЦ III

      - необходим для измерения линейных внутренних и внешних размеров деталей. Этот инструмент очень востребован в сфере производства и машиностроения. 

       

       


      Прибор имеет штангу, её рабочую поверхность и шкалу, нониус, зажимающий элемент в виде стопорного винта и губки для измерения наружных и внутренних размеров. В отличие от ШЦ-1 губки у этой модели расположены только с одной стороны. Главным плюсом именно этого инструмента является простота и удобство использования. 


      По типу снятия показаний со штангенциркулей их можно разделить на нониусные и цифровые. У нониусных моделей измерения снимаются со шкалы на штанге, которая соответствует целым значениям и со шкалы нониуса, соответствующей долям миллиметра. Далее эти значения складываются.
      С цифрового штангенциркуля показания снимаются проще всего, так как в готовом цифровом виде выводятся на экран дисплея. Так же к преимуществам этого типа можно отнести быструю установку на «нуль», возможность снимать показания как в миллиметрах, так и в дюймах и высокую точность измерений.


      Штангенциркули соответствуют ГОСТ 166-89 и требованиям технической документации фирмы-изготовителя. Приборы внесены в Государственный реестр средств измерений.

      Отзывы Все отзывы категории
      Штангенциркуль ШЦЦ-3-1000 0,01 электронный губки 150мм 040040103 NORGAU
      Штангенциркуль ШЦЦ-3-1000 0,01 электронный губки 150мм 040040103 NORGAU

      Более универсальный вариант штангенциркуля, чем видел и пользовался до этого. Решили взять более выс..

      20.11.2024 Читать полный отзыв
      И Игорь Оценил(а) товар на 5
      Штангенциркуль ШЦ-3-3000 0,1 губки 250мм ЧИЗ
      Штангенциркуль ШЦ-3-3000 0,1 губки 250мм ЧИЗ

      Купил штангенциркуль ШЦ-3-3000 для своего небольшого производства, и не пожалел. Инструмент очень уд..

      05.11.2024 Читать полный отзыв
      А Артур Оценил(а) товар на 5
      Штангенциркуль ШЦЦТ-3- 400 0,01 электронный губки 100мм с твердосплавными губками SHAN
      Штангенциркуль ШЦЦТ-3- 400 0,01 электронный губки 100мм с твердосплавными губками SHAN

      Смотрел только на тип ШЦЦТ-3, подбирал для конкретного цеха, заказали несколько т.к старые уже отжив..

      29.10.2024 Читать полный отзыв
      Д Дмитрий Оценил(а) товар на 5
      Штангенциркуль ШЦ-3- 630 0.1 губки200(250-630) ЧИЗ
      Штангенциркуль ШЦ-3- 630 0.1 губки200(250-630) ЧИЗ

      Диапазон измерений от 250 до 630 мм и точность 0,1 мм позволяют выполнять замеры с высокой надёжност..

      29.10.2024 Читать полный отзыв
      А Артур Оценил(а) товар на 5
      Штангенциркуль ШЦЦ-3- 500 0,01 электронный губки 200мм МИК
      Штангенциркуль ШЦЦ-3- 500 0,01 электронный губки 200мм МИК

      Долго выбирал с мастером, смотрели по производителям и техническим характеристикам, главное надежнос..

      25.10.2024 Читать полный отзыв
      В Валентин Оценил(а) товар на 5
      Штангенциркуль ШЦ-3- 630 0,05 губки 100мм ЧИЗ
      Штангенциркуль ШЦ-3- 630 0,05 губки 100мм ЧИЗ

      Детали и изделия, с которыми работают наши сотрудники, специфические по форме и размерам, так что им..

      16.09.2024 Читать полный отзыв
      Р Роман Оценил(а) товар на 5
      Выберите обязательные опции
      Быстрый заказ

      Мы используем файлы cookie и другие средства сохранения предпочтений и анализа действий посетителей сайта. Подробнее в ИСПОЛЬЗОВАНИЕ ФАЙЛОВ COOKIE И ЯНДЕКС.МЕТРИКИ. Нажмите «Принять», если даете согласие на это.

      Принять
      REPLACE INTO `oc_session` SET session_id = 'eeed7fa3fe63f39b981a8c6514', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\",\"view\":\"grid-4\"}', expire = '2026-03-13 15:16:30';