SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
SELECT * FROM oc_extension WHERE `type` = 'openbay'
SELECT `data` FROM `oc_session` WHERE session_id = '56bba3c3fa56e3c49f66472af7' AND expire > 1771400069
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://hortz.ru/'
SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '1' ORDER BY store_id 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` = 'razmer_39' LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `short_link` = 'kalibrovka_net' LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '853' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '924' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '975' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '980' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT `layout_id` FROM `oc_category_to_layout` WHERE `category_id` = 980 AND `store_id` = 1 LIMIT 1
SELECT `layout_id` FROM `oc_layout_route` WHERE 'product/category' LIKE `route` AND `store_id` = 1 ORDER BY `route` DESC LIMIT 1
SELECT `layout_module_id` FROM `oc_layout_module` WHERE `layout_id` = 21 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` = 240 AND afv.`attr_text` IN ('240_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_716') ) 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` = 980 AND p.`status` = 1 AND p2s.`store_id` = 1
SELECT p.`product_id` FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 240 AND afv.`attr_text` IN ('240_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_716') ) 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` = 980 AND p.`status` = 1 AND p2s.`store_id` = 1 GROUP BY p.`product_id` ORDER BY p.`quantity` DESC, IF(p.`price` = '0', 0, 1) DESC, `sort_order` ASC, (p.`quantity` > 0) DESC, p.viewed DESC LIMIT 0,30
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5827' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '18662' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5828' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '18661' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '6627' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2166' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9487' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '6685' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3291' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '33152' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3828' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '6684' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9492' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10708' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13518' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '170147' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '14898' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '33151' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16709' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '14882' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9488' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '110548' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '14900' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '158791' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '14884' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9489' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13517' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '14881' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2169' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special_hortz ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '11919' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
select * from oc_filter_vier_hl f1
left join oc_filter_vier_hl_lang f2 on(f1.id=f2.id) where f1.short_link='kalibrovka_net'
SELECT noindex FROM oc_category WHERE category_id = 980
select * from oc_filter_vier_hl where route='category_id' and route_id=980
select `faq_id`,`text`, `answer`, `is_category` from `oc_category_faq` where `customer_id` = 1 && `category_id`=980
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT * FROM oc_category_to_layout WHERE category_id = '980' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '21' 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` = 980
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` = 240 AND afv.`attr_text` IN ('240_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_716') ) 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` = 980 AND p.`status` = 1 AND p2s.`store_id` = 1
GROUP BY p.`product_id`
SELECT p.`manufacturer_id`, 1 AS total FROM `oc_product` p JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 240 AND afv.`attr_text` IN ('240_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_716') ) 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 (980)) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY p.`manufacturer_id`
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/proizvoditeli_micron' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/proizvoditeli_bez-tm' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/proizvoditeli_kalibr' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/proizvoditeli_tm' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/proizvoditeli_tulamash' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/proizvoditeli_chiz' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/proizvoditeli_chk' AND `route` = 'category_id' AND `route_id` = 980 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` = 240 AND afv.`attr_text` IN ('240_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_716') ) 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 (980)) AND afv.`attribute_id` IN (138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,156,157,158,159,160,162,163,171,172,173,174,175,177,178,179,181,182,183,184,185,186,187,188,189,190,191,192,193,197,200,206,207,208,209,210,213,214,215,216,217,218,224,225,227,228,229,230,231,232,234,239,241,242,244,246,247,248,249,250,251,252,255,258,259,261,262,263,264,265,266,267,268,269,273,274,275,276,277,278,280,281,282,283,284,285,286,287,288,289,290,291,292,293,295,296,297,298,299,300,301,307,308,309,311,312,314,318,319,320,321,322,326,327,328,329,330,331,332,333,334,335,336,337,338,341,342,343,345,346,347,348,349,350,351,352,353,407) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY `attr_text`
SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 240 AND afv.`attr_text` IN ('240_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 (980)) AND afv.`attribute_id` IN (155) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY `attr_text`
SELECT afv.`attr_text`, 1 AS total FROM `oc_attribute_filter_vier` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_716') ) 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 (980)) AND afv.`attribute_id` IN (240) AND p2s.`store_id` = 1 AND p.`status` = 1 GROUP BY `attr_text`
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/osnovnoe-otklonenie_d' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/osnovnoe-otklonenie_e' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/osnovnoe-otklonenie_f' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/osnovnoe-otklonenie_g' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/osnovnoe-otklonenie_h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/osnovnoe-otklonenie_r' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/tip-rezbi_g' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/tip-rezbi_m' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/diametr-rezbi--dyuym_1' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/diametr-rezbi--dyuym_1-4' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/diametr-rezbi--dyuym_1-8' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/diametr-rezbi--dyuym_3-4' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/diametr-rezbi--dyuym_3-8' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/diametr-rezbi--dyuym_5-8' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-2/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-25/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-3/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-4/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-6/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-7/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-75/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-8/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-35/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_0-45/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_1/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_1-25/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_1-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_1-75/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_2/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_2-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_3/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_3-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_4/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_4-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_5-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/shag-rezbi--mm_6/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/shag-rezbi--nitok-na-dyuym_14' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/shag-rezbi--nitok-na-dyuym_19' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/shag-rezbi--nitok-na-dyuym_28' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_1~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_1-2~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_1-1~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_1-4~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_1-6~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_1-8~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_2~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~2-2/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~2-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~2-6/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_3~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~3-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_4~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_4-5~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_5~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_5-5~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~5-96/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_6-5~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_7~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_8-5~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_9~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_10~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_11~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_12~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_13~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_14~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_15~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_16~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_16-5~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_17-96~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_18~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_19~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_20~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_21~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_22~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_23~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_24~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_25~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_26~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_27~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_28~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~29/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_30~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~31/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_32~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_33~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_34~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~35/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_36~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~37/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~37-5/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_38~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_40~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_41~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_42~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_43~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_44~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_45~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_46~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_47~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_48~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_49~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_50~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_51~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_52~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_54~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_55~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_56~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_58~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_59~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_60~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_62~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_63~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_64~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_65~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_66~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_68~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_69~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_70~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_72~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_73~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_75~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_76~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_78~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_80~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_82~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~83/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_85~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_88~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_89~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_90~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_93~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_94~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_95~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_98~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_100~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_102~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_103~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_104~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_105~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_108~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_110~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_112~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_115~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_120~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_121~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_125~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_130~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_132~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_135~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_140~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_142~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_145~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_150~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_155~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_160~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_165~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_170~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_175~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~180/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~185/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~190/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~195/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_200~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~210/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~220/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~235/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_250~39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39~265/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net~da' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/kvalitet_2' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/kvalitet_4' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/kvalitet_5' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/kvalitet_6' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/kvalitet_7' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/kvalitet_8' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/kvalitet_9' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/klass-tochnosti_b/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/klass-tochnosti_a/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'konusnost_110/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/napravlenie-rezbi_levoe' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/napravlenie-rezbi_pravoe' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'osobennost_po-cherteju/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_2r' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_4g' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_4h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_5h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_5h6h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_6d' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_6e' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_6f' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_6g' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_6h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_6h8h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_7f' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_7g' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_7g6g' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_7h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_7h6h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_8d' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_8e' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_8g' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_8h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_8h6h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/pole-dopuska_9h' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip_kontrolniy/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tip_rabochiy-specialniy/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_50/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_85/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_110/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_130/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_140/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_145/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_150/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_155/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_160/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_170/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_175/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_180/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_185/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_190/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_195/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_200/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_205/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_210/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_215/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_220/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_230/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_235/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/dlina--mm_270/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tehnicheskiy-standart_gost-1623-89/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tehnicheskiy-standart_gost-18465-73/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tehnicheskiy-standart_gost-18466-73/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tehnicheskiy-standart_gost-24705/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'tehnicheskiy-standart_gost-24932-81/razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_ki/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_ki-ne/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_kne-ne/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_kne-pr/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_kpr-ne/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_kpr-pr/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_ne/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_pr/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/vid_pr-ne/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/ves--g_slider_288' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT MIN( p.`price`) AS price_min, MAX( p.`price`) AS price_max FROM `oc_product` p LEFT JOIN `oc_product_to_store` p2s ON (p.`product_id` = p2s.`product_id`) JOIN (SELECT DISTINCT afv.`product_id` FROM `oc_attribute_filter_vier` afv STRAIGHT_JOIN (SELECT afv.`product_id` FROM `oc_attribute_filter_vier` afv WHERE afv.`attribute_id` = 240 AND afv.`attr_text` IN ('240_1') ) tafv1 ON (afv.`product_id` = tafv1.`product_id`) WHERE afv.`attribute_id` = 155 AND afv.`attr_text` IN ('155_716') ) 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 (980)) AND p.`status` = 1 AND p2s.`store_id` = 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net/cena_slider_prs' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '980' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'extension/module/filter_vier/filter_vier'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/column_left'
SELECT * FROM oc_category_to_layout WHERE category_id = '980' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '21' AND position = 'column_right' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/column_right'
SELECT * FROM oc_category_to_layout WHERE category_id = '980' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '21' AND position = 'content_top' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/content_top'
SELECT * FROM oc_category_to_layout WHERE category_id = '980' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '21' AND position = 'content_bottom' ORDER BY sort_order
SELECT * FROM oc_module WHERE module_id = '45'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_viewed' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/content_bottom'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '1' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'extension/module/uni_notification'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/footer'
SELECT * FROM oc_extension WHERE `type` = 'analytics'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/language'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
SELECT `id`, `link`, `short_link` FROM `oc_filter_vier_hl` WHERE `link` = 'razmer_39/kalibrovka_net' AND `route` = 'category_id' AND `route_id` = 980 LIMIT 1
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/currency'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/search'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'
SELECT * FROM oc_extension WHERE `type` = 'total'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '56bba3c3fa56e3c49f66472af7'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/cart'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1038' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '4' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1041' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '9' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1099' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '11' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '16' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '58' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1100' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '69' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1076' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '106' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '107' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '112' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '169' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1118' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1042' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1079' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '168' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '170' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '171' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1022' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '172' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '175' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1715' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1723' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '176' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '195' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1714' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '200' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '201' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '203' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1030' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1718' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1719' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1716' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '209' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1742' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1721' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1722' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1720' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1717' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1724' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '216' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1018' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '218' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '228' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '229' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '221' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1120' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '342' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '236' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '245' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '255' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '268' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '270' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '414' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '291' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '307' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '327' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '331' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '332' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '333' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '343' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '345' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '347' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '358' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '354' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '359' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '360' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '362' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '369' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '376' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '382' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '383' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '395' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '355' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '417' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '418' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '422' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '445' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '471' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '446' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '502' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1102' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1127' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '545' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '579' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '582' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '583' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '584' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '586' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '588' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '589' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '581' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '140' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1040' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '595' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '596' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '602' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '611' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '597' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '639' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '805' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '807' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1122' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1126' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '824' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '825' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '828' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '829' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1117' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '843' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '850' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1133' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '853' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '854' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '924' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1317' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1319' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1443' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1444' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1321' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1442' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1454' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1450' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1452' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1463' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1447' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1448' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1451' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1446' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1455' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1320' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1457' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1441' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1445' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1453' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1458' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1459' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1460' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1756' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1757' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1758' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1759' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1767' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1768' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1769' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1771' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1772' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1773' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1774' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1780' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1783' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1784' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1792' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1795' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1797' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1804' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1809' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1812' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1813' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1814' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1819' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1318' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1327' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1330' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1328' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1325' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1323' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1324' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1322' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1329' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1326' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2207' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2208' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2293' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2294' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2299' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2302' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2306' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2319' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2325' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2326' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2224' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2339' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2344' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2345' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2346' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2347' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2348' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2357' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2358' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2359' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2286' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2360' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2374' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2375' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2376' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2377' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2378' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2379' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2384' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2385' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2261' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1136' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1259' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2386' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1276' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1248' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1286' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1156' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1222' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1195' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1230' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1137' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1149' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1743' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1744' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1745' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1746' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1747' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1748' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1749' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1750' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1751' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1753' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2196' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1754' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1755' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1826' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1827' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1828' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1831' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1832' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1833' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1834' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1835' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1836' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1837' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1838' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1841' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1842' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1848' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1849' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1853' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1862' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1874' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1886' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1888' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1889' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1908' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1909' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1932' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1942' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1946' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1955' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1956' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1957' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1968' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1969' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2037' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2048' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2061' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2110' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2126' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2127' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2197' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '2200' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/menu'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/header'
SELECT * FROM oc_setting WHERE store_id = '1' AND `code` = 'advertise_google'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'octemplates/module/oct_breadcrumbs'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'product/category'
SELECT * FROM oc_setting WHERE store_id = '1' AND `code` = 'advertise_google'