SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type';

SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '');

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

SELECT `data` FROM `oc_session` WHERE session_id = '5875fefc6ed17642335c498baf' AND expire > 1773406592;

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

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

SELECT * FROM oc_currency;

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

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

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

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

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

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

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

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

SELECT article FROM oc_product WHERE product_id = 113090 LIMIT 1 ;

SELECT IS_PARTNER FROM FROM_CHEESECAKE_TO_SITE WHERE ID = '1092520' LIMIT 1 ;

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

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

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

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

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '989' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

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

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '998' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

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

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN oc_category_reviews cr ON (c.category_id = cr.category_id) WHERE c.category_id = '1036' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1';

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

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

CREATE TABLE IF NOT EXISTS `oc_advance_extratab` ( `advance_extratab_id` int(11) NOT NULL AUTO_INCREMENT, `sort_order` int(11) NOT NULL, `status` int(11) NOT NULL, `show_guest` int(11) NOT NULL, PRIMARY KEY (`advance_extratab_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;;

CREATE TABLE IF NOT EXISTS `oc_advance_extratab_category` ( `advance_extratab_id` int(11) NOT NULL, `category_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;;

CREATE TABLE IF NOT EXISTS `oc_advance_extratab_customer_group` ( `advance_extratab_id` int(11) NOT NULL, `customer_group_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;;

CREATE TABLE IF NOT EXISTS `oc_advance_extratab_description` ( `advance_extratab_id` int(11) NOT NULL, `language_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;;

CREATE TABLE IF NOT EXISTS `oc_advance_extratab_manufacturer` ( `advance_extratab_id` int(11) NOT NULL, `manufacturer_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;;

CREATE TABLE IF NOT EXISTS `oc_advance_extratab_product` ( `advance_extratab_id` int(11) NOT NULL, `product_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;;

CREATE TABLE IF NOT EXISTS `oc_advance_extratab_store` ( `advance_extratab_id` int(11) NOT NULL, `store_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;;

SELECT * FROM oc_advance_extratab e left join oc_advance_extratab_description ed ON (e.advance_extratab_id = ed.advance_extratab_id) LEFT JOIN oc_advance_extratab_store e2s ON (e.advance_extratab_id = e2s.advance_extratab_id) WHERE ed.language_id = '1' AND e2s.store_id = '0' AND e.status = '1' AND show_guest = '1' ORDER BY e.sort_order ASC;

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '1' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '1' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '2' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '2' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '3' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '3' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '4' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '4' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '5' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '5' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '6' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '6' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '7' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '7' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '8' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '8' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '9' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '9' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '10' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '10' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '11' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '11' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '12' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '12' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '13' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '13' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '14' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '14' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '15' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '15' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '16' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '16' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '17' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '17' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '18' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '18' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '19' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '19' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '20' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '20' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '21' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '21' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '22' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '22' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '23' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '23' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '24' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '24' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '25' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '25' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '26' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '26' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '27' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '27' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '28' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '28' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '29' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '29' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '30' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '30' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '31' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '31' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '32' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '32' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '33' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '33' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '34' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '34' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '35' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '35' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '36' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '36' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '37' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '37' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '38' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '38' AND category_id IN (989,998,1036);

SELECT * FROM oc_advance_extratab_product WHERE advance_extratab_id = '39' AND product_id = '113090';

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_advance_extratab_category WHERE advance_extratab_id = '39' AND category_id IN (989,998,1036);

SELECT * FROM `oc_advance_extratab` e left join oc_advance_extratab_description ed ON (e.advance_extratab_id = ed.advance_extratab_id) LEFT JOIN oc_advance_extratab_store e2s ON (e.advance_extratab_id = e2s.advance_extratab_id) WHERE ed.language_id = '1' AND e2s.store_id = '0' AND e.status = '1' AND e.advance_extratab_id NOT IN( SELECT advance_extratab_id FROM `oc_advance_extratab_category`) AND e.advance_extratab_id NOT IN( SELECT advance_extratab_id FROM `oc_advance_extratab_product`) AND e.advance_extratab_id NOT IN( SELECT advance_extratab_id FROM `oc_advance_extratab_manufacturer`) AND show_guest = '1' ORDER BY e.sort_order ASC;

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

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

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

SELECT * FROM oc_product_links WHERE product_id = '113090' ORDER BY sort_order ASC;

SELECT gi.item_id, p.product_id, IFNULL(pa.text, '') AS value, gn.name, gi0.group_id, gn.sort, u.keyword as url, pd.name as product_name FROM catalog_item_group_items gi0 JOIN catalog_item_groups g ON g.group_id = gi0.group_id LEFT JOIN catalog_item_groups_variants_names gn ON gn.variant_param_id = g.variant_param_id JOIN catalog_item_group_items gi ON gi.group_id = g.group_id JOIN oc_product p ON p.article = gi.item_id JOIN oc_product_description pd ON pd.product_id = p.product_id LEFT JOIN oc_product_attribute pa ON pa.product_id = p.product_id AND pa.attribute_id = g.variant_param_id LEFT JOIN oc_seo_url u ON u.query = CONCAT('product_id=', p.product_id) AND u.store_id = 0 WHERE gi0.item_id = '1092520' ORDER BY gn.sort, value ;

SELECT * FROM oc_product_to_category WHERE product_id = '113090';

SELECT * FROM oc_category WHERE category_id = '989';;

SELECT * FROM oc_oct_blogarticle WHERE product_category_id = '989';;

SELECT * FROM oc_category WHERE category_id = '998';;

SELECT * FROM oc_oct_blogarticle WHERE product_category_id = '998';;

SELECT * FROM oc_category WHERE category_id = '1036';;

SELECT * FROM oc_oct_blogarticle WHERE product_category_id = '1036';;

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

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

SELECT `BARCODE` FROM `BARCODES` WHERE `ID` = 1092520;

SELECT COUNT(*) AS total FROM oc_prostore_faq r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113090' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1';

SELECT * FROM oc_prostore_custom_tabs ct LEFT JOIN oc_prostore_custom_tabs_description ctd ON (ct.cust_tab_id = ctd.cust_tab_id) LEFT JOIN oc_prostore_custom_tabs_to_store ct2s ON (ct.cust_tab_id = ct2s.cust_tab_id) WHERE ctd.language_id = '1' AND ct2s.store_id = '0' AND ct.status = '1' ORDER BY ct.sort_order ASC;

SELECT instanses FROM oc_prostore_custom_tabs_instanses WHERE cust_tab_id='2';

SELECT instanses FROM oc_prostore_custom_tabs_instanses WHERE cust_tab_id='1';

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

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

SELECT * FROM oc_product_image WHERE product_id = '113090' ORDER BY sort_order ASC;

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

SELECT * FROM oc_product_discount WHERE product_id = '113090' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC;

SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '113090' AND od.language_id = '1' ORDER BY o.sort_order;

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

SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113090' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1';

SELECT rating, COUNT(review_id) AS totall FROM oc_review WHERE product_id = '113090' AND status ='1' GROUP By rating ORDER BY rating DESC;

select `name` from `jam_catalog_items_grsi2` where `article`=1092520;

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

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

SELECT DISTINCT * FROM oc_product_to_category ptc LEFT JOIN oc_product p ON (ptc.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.product_id != '113090' AND p.status = '1' AND ptc.category_id = '1036' AND p.image IS NOT NULL AND p.price > 0 AND p.date_available <= NOW() AND p2s.store_id = '0' ORDER BY RAND() LIMIT 5;

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

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

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

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

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

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

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

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

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

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

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

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

SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113090' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1';

SELECT r.review_id, r.author, r.rating, r.text, r.reply, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113090' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5;

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

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

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

SELECT r.faq_id, r.author, r.text_admin_answer, r.answer_date_added, r.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.text_admin_answer,r.answer_date_added FROM oc_prostore_faq r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113090' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,10;

SELECT COUNT(*) AS total FROM oc_prostore_faq r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113090' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1';

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

SELECT COUNT(*) AS total FROM oc_prostore_faq r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113090' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1';

SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 113090 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC;

SELECT noindex FROM oc_product WHERE product_id = 113090;

SELECT * FROM `oc_module` WHERE `code` LIKE 'oct_product_views';

UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '113090';

SELECT * FROM oc_product_to_layout WHERE product_id = '113090' AND store_id = '0';

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

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

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

SELECT * FROM oc_product_to_layout WHERE product_id = '113090' AND store_id = '0';

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

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

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

SELECT * FROM oc_product_to_layout WHERE product_id = '113090' AND store_id = '0';

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

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

SELECT * FROM oc_module WHERE module_id = '68';

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

SELECT tp.set_id FROM oc_prostore_product_to_set tp LEFT JOIN oc_prostore_set_to_store ts2s ON (tp.set_id = ts2s.set_id) WHERE tp.product_id = '113090' AND ts2s.store_id = '0' GROUP by tp.set_id;

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

SELECT * FROM oc_product_to_layout WHERE product_id = '113090' AND store_id = '0';

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

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

SELECT * FROM oc_module WHERE module_id = '69';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT pu1.text1 as `url`, hl.meta_h1 as `name` FROM `oc_product_all_tags_products` pu join `oc_product_all_tags_urls_products` pu1 ON pu.link_id = pu1.id join `oc_filter_vier_hl_lang` hl on hl.id = pu1.id WHERE `product_id` = 113090 ;

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

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

Полотно по металлу 300х13х0,65 мм, 32TPI, HSS-Co купить, узнать цены и характеристики в компании АО ТД ЧИЗ | 1092520 REPLACE INTO `oc_session` SET session_id = '5875fefc6ed17642335c498baf', `data` = '{\"language\":\"ru-ru\",\"currency\":\"RUB\",\"view\":\"grid-4\"}', expire = '2026-03-13 13:20:33';