Chiba Allround

SELECT * FROM op_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://atlet40.ru/'

SELECT * FROM op_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC

SELECT * FROM op_language WHERE STATUS = '1'

SELECT * FROM op_currency

SELECT * FROM op_weight_class wc LEFT JOIN op_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'

SELECT * FROM op_length_class mc LEFT JOIN op_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'

SELECT f1.postalcode f1_postalcode, CONCAT(f1.shortname, ' ', f1.offname) f1_name,
                                            f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname,
                                          CONCAT(f2.offname, ' ', f2.shortname) f2_name,
                                            f2.level f2_level, f2.fias_id f2_fias_id,
                                          CONCAT(f3.offname, ' ', f3.shortname) f3_name,
                                            f3.level f3_level, f3.fias_id f3_fias_id,
                                          CONCAT(f4.offname, ' ', f4.shortname) f4_name,
                                            f4.level f4_level, f4.fias_id f4_fias_id
                                      FROM fias f1
                                        LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id
                                        LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id
                                        LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id
                                      WHERE f1.offname = 'Уилмингтон'
                                        AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США')
                                        AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))

SELECT *
                                        FROM op_country c
                                        WHERE c.iso_code_2 = "US"

SELECT code FROM geoip_currency WHERE country_id = 0

SELECT * FROM geoip_rule

SELECT * FROM geoip_redirect

SELECT `value` FROM `op_setting` WHERE `key` = 'config_language'

SELECT * FROM op_language WHERE STATUS = '1'

SELECT * FROM op_url_alias WHERE keyword IN ('aksessuary', 'perchatki', 'chiba-allround')

SELECT category_id FROM op_product_to_category WHERE product_id = '1631' ORDER BY main_category DESC LIMIT 1

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1631','product_id=1633') ORDER BY `keyword` ASC

SELECT * FROM op_category c LEFT JOIN op_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN op_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.STATUS = '1' ORDER BY c.parent_id, c.sort_order, cd.name

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_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 op_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 op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_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 op_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 op_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 op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '1631' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1631','product_id=1633') ORDER BY `keyword` ASC

SELECT cd.name FROM op_category_description cd LEFT JOIN op_product_to_category pc ON(pc.category_id=cd.category_id) WHERE pc.product_id='1631'

SELECT m.name FROM op_manufacturer m LEFT JOIN op_product p ON(p.manufacturer_id=m.manufacturer_id) WHERE p.product_id='1631'

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1631','product_id=1633') ORDER BY `keyword` ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1631','product_id=1633') ORDER BY `keyword` ASC

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 1631
 

SELECT RO.relatedoptions_id, PO.product_option_id, POV.product_option_value_id
                                FROM op_relatedoptions RO
                                    ,op_relatedoptions_option ROO
                                    ,op_product_option PO
                                    ,op_product_option_value POV
                                WHERE RO.product_id = 1631
																	AND RO.quantity > 0
                                  AND PO.product_id = 1631
                                  AND POV.product_id = 1631
                                  AND RO.relatedoptions_id = ROO.relatedoptions_id
                                  AND ROO.option_id = PO.option_id
                                  AND ROO.option_value_id = POV.option_value_id
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 1631
 

SELECT RO.relatedoptions_id, PO.product_option_id, POV.product_option_value_id
                                FROM op_relatedoptions RO
                                    ,op_relatedoptions_option ROO
                                    ,op_product_option PO
                                    ,op_product_option_value POV
                                WHERE RO.product_id = 1631
																	AND RO.quantity = 0
                                  AND PO.product_id = 1631
                                  AND POV.product_id = 1631
                                  AND RO.relatedoptions_id = ROO.relatedoptions_id
                                  AND ROO.option_id = PO.option_id
                                  AND ROO.option_value_id = POV.option_value_id
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 1631
 

	SELECT VP.relatedoptions_variant_id
																FROM 	op_relatedoptions_variant_product VP
																WHERE VP.product_id = 1631
 

	SELECT VO.option_id
																	FROM `op_relatedoptions_variant_option` VO
																	WHERE relatedoptions_variant_id = 8
 

SELECT PO.product_option_id
                                    FROM  op_product_option PO
                                    WHERE PO.option_id IN (9)
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 1631
 

SELECT RO.relatedoptions_id, RO.price ro_price, ROD.price, ROD.quantity, RO.model, RO.description, RO.quantity
															FROM op_relatedoptions RO
															LEFT JOIN op_relatedoptions_discount ROD ON (RO.relatedoptions_id = ROD.relatedoptions_id && ROD.customer_group_id = 1 )
															WHERE RO.product_id = 1631
 

SELECT ROD.*
															FROM op_relatedoptions_special ROD, op_relatedoptions RO
															WHERE RO.product_id = 1631
																AND RO.relatedoptions_id = ROD.relatedoptions_id
																AND ROD.customer_group_id = 1
															ORDER BY ROD.priority ASC, ROD.price ASC	
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 1631
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 1631
 

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT COUNT(*) AS total FROM op_review r LEFT JOIN op_product p ON (r.product_id = p.product_id) LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id IN (1631,1633) AND p.date_available <= NOW() AND p.STATUS = '1' AND r.STATUS = '1' AND pd.language_id = '1'

SELECT op_category_description.name
			FROM
			op_product_to_category
			INNER JOIN op_category_description
			ON op_product_to_category.category_id = op_category_description.category_id
			WHERE
			op_product_to_category.product_id = 1631
			AND op_category_description.language_id = 1
			AND op_product_to_category.main_category = 1

SELECT * FROM op_product_image WHERE product_id = '1631' ORDER BY sort_order ASC

SELECT * FROM op_product_discount WHERE product_id = '1631' 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 op_product_option po LEFT JOIN `op_option` o ON (po.option_id = o.option_id) LEFT JOIN op_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '1631' AND od.language_id = '1' ORDER BY o.sort_order

SELECT * FROM op_product_option_value pov LEFT JOIN op_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN op_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '1631' AND pov.product_option_id = '113795' AND ovd.language_id = '1' ORDER BY pov.quantity DESC, ov.sort_order

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT COUNT(*) AS total FROM op_review r LEFT JOIN op_product p ON (r.product_id = p.product_id) LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id IN (1631,1633) AND p.date_available <= NOW() AND p.STATUS = '1' AND r.STATUS = '1' AND pd.language_id = '1'

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT DISTINCT ag.attribute_group_id, agd.name FROM op_product_attribute pa LEFT JOIN op_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN op_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN op_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id IN (1631,1633) AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name

SELECT DISTINCT a.attribute_id, ad.name, pa.text, pa.rdn FROM op_product_attribute pa LEFT JOIN op_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN op_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id IN (1631,1633) AND a.attribute_group_id = '2' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name

SELECT DISTINCT a.attribute_id, ad.name, pa.text, pa.rdn FROM op_product_attribute pa LEFT JOIN op_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN op_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id IN (1631,1633) AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name

SELECT * FROM op_product_related pr LEFT JOIN op_product p ON (pr.related_id = p.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '1631' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_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 op_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 op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_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 op_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 op_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 op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '184' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_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 op_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 op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_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 op_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 op_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 op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '208' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_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 op_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 op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_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 op_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 op_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 op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '835' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_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 op_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 op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_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 op_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 op_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 op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '1619' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT category_id FROM op_product_to_category WHERE product_id = '184' ORDER BY main_category DESC LIMIT 1

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '184'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=184','product_id=1176') ORDER BY `keyword` ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '208'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=208','product_id=209','product_id=210','product_id=719') ORDER BY `keyword` ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '835'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=835','product_id=985') ORDER BY `keyword` ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM op_tax_rule tr1 LEFT JOIN op_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN op_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN op_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN op_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2744') ORDER BY tr1.priority ASC

SELECT category_id FROM op_product_to_category WHERE product_id = '1619' ORDER BY main_category DESC LIMIT 1

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1619'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1619') ORDER BY `keyword` ASC

UPDATE op_product SET viewed = (viewed + 1) WHERE product_id = '1631'

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT DISTINCT p.product_id,
		                                           p.price,
												   p.purchase_price,
												   p.image,
		                                           pd.tag,
		                                           p.quantity,
		                                           (SELECT price FROM op_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 op_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
                                 FROM op_product p
                                 LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id)
                                 LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id)
                                 LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
                               WHERE p.product_id IN (1631,1633)
                                 AND pd.language_id = '1'
                                 AND p.STATUS = '1'
                                 AND p.date_available <= NOW()
                                 AND p2s.store_id = '0'

SELECT * FROM op_product_option po LEFT JOIN `op_option` o ON (po.option_id = o.option_id) LEFT JOIN op_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '1631' AND od.language_id = '1' ORDER BY o.sort_order

SELECT * FROM op_product_option_value pov LEFT JOIN op_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN op_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '1631' AND pov.product_option_id = '113795' AND ovd.language_id = '1' ORDER BY pov.quantity DESC, ov.sort_order

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT * FROM op_product_option po LEFT JOIN `op_option` o ON (po.option_id = o.option_id) LEFT JOIN op_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '1633' AND od.language_id = '1' ORDER BY o.sort_order

SELECT * FROM op_product_option_value pov LEFT JOIN op_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN op_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '1633' AND pov.product_option_id = '113813' AND ovd.language_id = '1' ORDER BY pov.quantity DESC, ov.sort_order

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

 
			SELECT rating,`type` FROM op_review
			WHERE
				`type` != '' AND product_id IN (1631,1633)

SELECT op_news_description.*, op_news.*
 
									FROM op_news
									INNER JOIN op_news_description
									ON op_news.news_id = op_news_description.news_id
									WHERE op_news.STATUS = 1
									  AND op_news_description.language_id = 1
									ORDER BY   op_news_description.news_id DESC
									LIMIT 3
 

SELECT op_review.*, op_product_description.name AS pname
									FROM op_review
									INNER JOIN op_product_description
									ON op_product_description.product_id = op_review.product_id
									WHERE op_review.STATUS = 1
									 AND op_product_description.language_id = 1
									ORDER BY `review_id` DESC LIMIT 3
 

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1323'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1323') ORDER BY `keyword` ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '210'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=208','product_id=209','product_id=210','product_id=719') ORDER BY `keyword` ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1273'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1273') ORDER BY `keyword` ASC

SELECT COUNT(DISTINCT p.product_id) AS total FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (64)

SELECT COUNT(DISTINCT p.product_id) AS total FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (43)

SELECT op_category_description.name, op_category_description.category_id	FROM op_category_description WHERE language_id = 1

SELECT op_category_description.name, op_category_description.category_id	FROM op_category_description WHERE language_id = 1

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 5
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 1
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 6
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 4
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 40
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 7
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 11
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 49
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 21
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 59
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 12
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 13
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 41
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 16
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 18
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 8
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 62
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 46
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 17
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 42
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 9
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 43
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 34
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 48
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 10
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 19
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 20
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 52
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 58
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 36
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 14
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 60
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 29
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 30
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 57
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 53
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 31
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 24
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 25
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 28
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 55
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 56
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 54
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 15
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 61
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 35
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 26
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 32
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 50
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 22
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 51
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 44
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 33
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 38
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 63
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 64
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 39
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 2
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 37
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 23
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 27
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 47
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 3
			AND op_product_description.language_id = 2

SELECT op_product_description.name, op_product_description.product_id
			FROM
			op_product_to_category
			INNER JOIN op_product_description
			ON op_product_to_category.product_id = op_product_description.product_id
			WHERE
			op_product_to_category.category_id = 45
			AND op_product_description.language_id = 2

SELECT DISTINCT(om.manufacturer_id), om.name FROM op_product op
			INNER JOIN op_product_to_category ptc ON ptc.product_id=op.product_id
			INNER JOIN op_manufacturer om ON om.manufacturer_id = op.manufacturer_id
			WHERE ptc.category_id>0 ORDER BY om.name ASC

SELECT * FROM op_product_to_layout WHERE product_id = '1631' AND store_id = '0'

SELECT * FROM op_layout_route WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM op_layout_route WHERE layout_id='2' AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM op_extension WHERE `type` = 'module'

SELECT * FROM op_product_to_layout WHERE product_id = '1631' AND store_id = '0'

SELECT * FROM op_layout_route WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM op_layout_route WHERE layout_id='2' AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM op_layout ORDER BY name ASC

SELECT * FROM op_url_alias_blog WHERE keyword = 'aksessuary'

SELECT * FROM op_url_alias_blog WHERE keyword = 'perchatki'

SELECT * FROM op_url_alias_blog WHERE keyword = 'chiba-allround'

SELECT * FROM op_setting WHERE store_id = '0' AND `group` = 'blogadmin'

SELECT * FROM op_product_to_layout WHERE product_id = '1631' AND store_id = '0'

SELECT * FROM op_layout_route WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM op_extension WHERE `type` = 'module'

SELECT * FROM op_product_to_layout WHERE product_id = '1631' AND store_id = '0'

SELECT * FROM op_layout_route WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM op_layout_route WHERE layout_id='2' AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1631','product_id=1633') ORDER BY `keyword` ASC

SELECT o.customer_id
				FROM `op_order` o
				LEFT JOIN op_order_product op ON (o.order_id = op.order_id)
				WHERE
				o.customer_id = '-1'
				AND o.order_status_id = '5'

SELECT o.customer_id
				FROM `op_order` o
				LEFT JOIN op_order_product op ON (o.order_id = op.order_id)
				WHERE
				o.customer_id = '-1'
				AND o.order_status_id = '5'  AND op.product_id = '1631'

SELECT * FROM op_customer WHERE customer_id = '-1'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_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 op_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 op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_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 op_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 op_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 op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '1631' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1631','product_id=1633') ORDER BY `keyword` ASC

SELECT * FROM op_url_alias_blog WHERE `query` = 'route=account/login'

SELECT * FROM op_url_alias_blog WHERE `query` = 'route=account/simpleregister'

SELECT * FROM op_url_alias_blog WHERE `query` = 'route=account/forgotten'

SELECT * FROM op_url_alias_blog WHERE `query` = 'route=account/simpleregister'

SELECT * FROM op_layout ORDER BY name ASC

SELECT * FROM op_url_alias_blog WHERE keyword = 'aksessuary'

SELECT * FROM op_url_alias_blog WHERE keyword = 'perchatki'

SELECT * FROM op_url_alias_blog WHERE keyword = 'chiba-allround'

SELECT * FROM op_setting WHERE store_id = '0' AND `group` = 'blogadmin'

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1631'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1631','product_id=1633') ORDER BY `keyword` ASC

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_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 op_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 op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_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 op_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 op_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 op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '1631' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT DISTINCT * FROM op_category c
			LEFT JOIN op_category_description cd ON (c.category_id = cd.category_id)
			LEFT JOIN op_category_to_store c2s ON (c.category_id = c2s.category_id)
			WHERE c.category_id = '50' AND cd.language_id = '1' AND c2s.store_id = '0'
			AND c.STATUS = '1'
 

SELECT COUNT(*) AS total FROM op_review r
		LEFT JOIN op_product p ON (r.product_id = p.product_id)
		LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id)
		WHERE p.product_id = '1631'  AND p.STATUS = '1' AND r.STATUS = '1'
		AND pd.language_id = '1'

 
			  SELECT
				rc.*,
				rc.review_id AS cid,
				rc.review_id AS review_id,
                IF ((SELECT urc.delta  FROM op_rate_review urc WHERE urc.customer_id = '-1' AND urc.review_id = rc.review_id LIMIT 1)  < 0, -1 ,
                IF ((SELECT urc.delta  FROM op_rate_review urc WHERE urc.customer_id = '-1' AND urc.review_id = rc.review_id LIMIT 1)  > 0, 1 ,  0 ) ) AS customer_delta ,
      			COUNT(rc.review_id) AS rate_count,
				SUM(rc.delta) AS rate_delta,
				SUM(rc.delta > 0) AS rate_delta_blog_plus,
				SUM(rc.delta < 0) AS rate_delta_blog_minus
			   FROM
			     op_rate_review rc
			   LEFT JOIN op_review c ON (rc.review_id = c.review_id)
			   LEFT JOIN op_product r ON (r.product_id = c.product_id)
			   LEFT JOIN op_product_description pd ON (r.product_id = pd.product_id)
				   WHERE
			     r.product_id= 1631
 
				AND r.STATUS = '1'
				AND c.STATUS = '1'
 
				AND pd.language_id = '1'
			    GROUP BY rc.review_id