SELECT `data`
FROM `oc_session`
WHERE session_id = '1465dbd2a73116ec049689aad7' AND expire > 1774543064

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

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 = '3480b2fed869dc931a76271846' AND expire > 1774543064

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://eurocosmetics.com.ua/'

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

SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name

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 = '220' 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 = '220' 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 = '3'

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 = '3'

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

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

SELECT language_id, code
FROM oc_language
WHERE status = '1'

SELECT *
FROM oc_language;

SELECT *
FROM oc_seo_url
WHERE keyword = 'roberto-cavalli-uk-ua' AND store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'product/manufacturer' OR route = 'uk-ua')

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

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

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '5' AND (md.language_id = '4' OR md.language_id is null) AND m2s.store_id = '0'

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

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

SELECT p.product_id
FROM oc_product p
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
ORDER BY p.date_added DESC LIMIT 5

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1873' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1872' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1871' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1870' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1869' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '5'

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '5' GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC,p.sort_order ASC, LCASE(pd.name) ASC LIMIT 24,12

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1830' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1703' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1785' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1691' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1847' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1838' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1820' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1812' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1826' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1681' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1821' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1695' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_product_image
WHERE product_id = '1830'
ORDER BY sort_order 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 = '1830' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1830' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1830

SELECT *
FROM oc_product_discount
WHERE product_id = '1830' 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_options_combinations`
WHERE product_id = 1830 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1830' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1703'
ORDER BY sort_order 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 = '1703' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1703' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1703

SELECT *
FROM oc_product_discount
WHERE product_id = '1703' 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_options_combinations`
WHERE product_id = 1703 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1703' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1785'
ORDER BY sort_order 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 = '1785' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1785' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1785

SELECT *
FROM oc_product_discount
WHERE product_id = '1785' 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_options_combinations`
WHERE product_id = 1785 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1785' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1691'
ORDER BY sort_order 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 = '1691' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1691' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1691

SELECT *
FROM oc_product_discount
WHERE product_id = '1691' 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_options_combinations`
WHERE product_id = 1691 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1691' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1847'
ORDER BY sort_order 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 = '1847' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1847' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1847

SELECT *
FROM oc_product_discount
WHERE product_id = '1847' 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_options_combinations`
WHERE product_id = 1847 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1847' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1838'
ORDER BY sort_order 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 = '1838' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1838' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1838

SELECT *
FROM oc_product_discount
WHERE product_id = '1838' 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_options_combinations`
WHERE product_id = 1838 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1838' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1820'
ORDER BY sort_order 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 = '1820' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1820' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1820

SELECT *
FROM oc_product_discount
WHERE product_id = '1820' 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_options_combinations`
WHERE product_id = 1820 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1820' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1812'
ORDER BY sort_order 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 = '1812' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1812' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1812

SELECT *
FROM oc_product_discount
WHERE product_id = '1812' 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_options_combinations`
WHERE product_id = 1812 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1812' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1826'
ORDER BY sort_order 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 = '1826' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1826' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1826

SELECT *
FROM oc_product_discount
WHERE product_id = '1826' 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_options_combinations`
WHERE product_id = 1826 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1826' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1681'
ORDER BY sort_order 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 = '1681' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1681' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1681

SELECT *
FROM oc_product_discount
WHERE product_id = '1681' 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_options_combinations`
WHERE product_id = 1681 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1681' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1821'
ORDER BY sort_order 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 = '1821' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1821' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1821

SELECT *
FROM oc_product_discount
WHERE product_id = '1821' 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_options_combinations`
WHERE product_id = 1821 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1821' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

SELECT *
FROM oc_product_image
WHERE product_id = '1695'
ORDER BY sort_order 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 = '1695' AND od.language_id = '4'
ORDER BY o.sort_order

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special 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 = '4') 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 = '4') 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 = '4') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
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 = '1695' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/notifywhenavailable' OR route = 'uk-ua')

SELECT `stock_status_id`
FROM `oc_product`
WHERE `product_id` = 1695

SELECT *
FROM oc_product_discount
WHERE product_id = '1695' 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_options_combinations`
WHERE product_id = 1695 AND (option_type = '' OR option_type IS NULL) AND (subtract = 0 OR (subtract = 1 AND quantity > 0))
order by id

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '1695' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '51'

SELECT *
FROM `oc_module`
WHERE `code` = 'mega_filter' AND `module_id` = 51

SELECT `a`.`attribute_id`, REPLACE(REPLACE(TRIM(pa.text), ' ', ''), ' ', '') AS `txt`, `ad`.`name`, `ad`.`mf_tooltip` AS `tooltip`, `agd`.`name` AS `gname`, `agd`.`attribute_group_id`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN `oc_product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 4
INNER JOIN `oc_attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN `oc_attribute_description` AS `ad` ON `ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 4
INNER JOIN `oc_attribute_group` AS `ag` ON `ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN `oc_attribute_group_description` AS `agd` ON `agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 4
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p`.`manufacturer_id` = 5 GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != ''
ORDER BY `txt`

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'attribute' AND `value` IN('8449701d46fbc79593133e6513a9cb3e','8449701d46fbc79593133e6513a9cb3e','20f0679c518b9cc35cea4c7fed35d7ec','9cbbc7cfe336ac7d691b7b5f676c55d5','2c6c0cd211d248d2df4032aec293b74a','6e066c094f55b46b6a2a0389cd327597','6e066c094f55b46b6a2a0389cd327597','fd1c66d4e524cea1cd89f0f0fe86a5f9','eab9c17f753487685ab1a6c045cc2301','37a80265d0abd4e0168a1e0644a4cc63','d5dc16bcf4a43a08bc9bea7bd9ba9cc0','e4c6bd7dc9149b90d6f55ff6081667de','27a7ee6c45c5e71c0c31cd94828b8bae','a5c0196f8f3d45099ad77ea4d4690b8a','ab895ac914c886ae4eb5707da97ee11a','ba00aa662a7d565ec280445674be1634','17ebe2dc178113b2c4b7e50a7a7ddd3f','81e1c2626df3ff4f5faefc596e754506','81e1c2626df3ff4f5faefc596e754506','656113effea3e087324f0c280aeceb68','b00ca03265f009de47967747cb491187','13be55d80ee9cd7151a4a6daaeaba801','dd3a19bfed798642cf0742cc845c403b','59faa49a6a8a6721ea03506492aa6954','d646e8faac0211ba516be1b399c4b48f','11b13b1df19db0ac8a68ee371a553069','bc7c9530cec09993e7865fce384e522e','a42bee261a926a5108e331a94a31d402','8e9351d0040a6804784f940f57d5d5e2','c2a0863b59898f8a3a9f3f3ca8429c1f','f2d3ef6dcd84e6c621847a816f461ddf','b5547a2086bda3b2c8628990ff40ce4c','9452988bed5d07288fd2c5054c452678','29a64080b37731abcbd3e1e7a55eabd0','be72cc96a4639122038dd58f5f4a4b0a','d39c375efb3a8205ecc298964bef28bf','3b08a3d52aa704f0614d4789c9c3316d','2d52d111791a765f2e06f1adc05ceac0','e51ba64babe9813e7eae90be59063cf3','2f3da0d02aa6ee7a6e396f0c22f88da7','f9e22308c8ba64482733755f9ced45d9','9a1642d1e7f99b2ecca39f9db2b991c9','67077a2db2f93eec28d08ca51cbd3313','20bd520b29655a9068eec05b6057ee8d','309af512970fd9d1653cc5aefe465814','f9e22308c8ba64482733755f9ced45d9','9e3c39706a934937a8c4e8ed92181686','b2b97038b5bb9452b8c27c4a88086f62','e51ba64babe9813e7eae90be59063cf3','64200dadecd60e194eb980e53f5cac03','fb4a2b2360039f89464284a3baeda35d','b698d129b4c324f1f78129246ad2d691','e6177eaeb31b1e8ba02b74f662e7b575','9e3c39706a934937a8c4e8ed92181686','2f8b71925d379d718f1e193b70921fc1','00f18b56ab81d554a54cc8d58c57b043','b6fef58896b9364907a5c40a04ffd484','c695c5c2887520f21ae5ab46c02b1488','791f777f89ba923c319943e23a3b8437','ad701a16dbc5ded271a55ede5efcb6ad','7fbbef1c673b3168c55d94bbec09b9ad','1d779c5a599a37ca1950875f23cb23f2','abc933ba141f59a94bd4b94482217d33','2d91a7931352659123f4acb9f1f62078','94f39c6b9560e83e8d6b56f1bd02e8bc','1b315df828e840e503c560f7be488685','0c1ba3e314853c4289d25317f3b2c8f4','cfa4e8bc9b30e7821c48ec7b8edb4a0a','4c64f46602ca6889a0af9c1a96fab23b','0f76c1b1089ca04c90409a60b868e5cd','8cbb8624871b64ad761ad70fbfbfe923','8d1a1753166672c13760e6cb1712776d','8cbb8624871b64ad761ad70fbfbfe923','8d1a1753166672c13760e6cb1712776d','9a28b999398e992733087a884e5b001b','8d1a1753166672c13760e6cb1712776d','a419a1759297853dbc042b5d3a92678b','0aefa628333bf676370d0a1578fcdee6','4a4460023225313833ca73ce4ba3b9a2','0aefa628333bf676370d0a1578fcdee6','96dd5599aa43b4540fdb9ba00ce1d0de','92207bee9e143cde63240b362bdf5205','fd5b1b4f61e467a6896c07b8b1b5e19d','4550c7614d4bae594f99df1ff2a5cbc1','a1711be17c714ff5cea23df3d0308640','0de28d7fc89fbd41d5064bba02ccaf36','843691321de17d7abd63c8e2490c7de3','4c418d69db4811de265a756235a7051e','a42bee261a926a5108e331a94a31d402','e87c0d65b3c92bbf6682c801428262d5','c1fd07df66678c7b8eb52663dc1a0666','b5547a2086bda3b2c8628990ff40ce4c','7f5157636c09f3fd8f36205959f16a30','a37bf2f4e97bd23c789ffa83063109b8','7f5157636c09f3fd8f36205959f16a30','d12d5582b26d035e24187ffe42be1c35','b1514737105074779f706d394a84832a','100595698accbdadfae7a95184f710aa','b1514737105074779f706d394a84832a','100595698accbdadfae7a95184f710aa','f1d899b3a3f97d4b8827533aa693db80','8b02b4cd632da2a23cb21c535a6adebd','4c1822afd9b060a111c7980abd20c48b','5f4379066a43378c5e28b8e00c27c6eb','e7af2674e03c3d0840952b87ae80cf48','91f5dd292787d3d5d60aab295453d2ad','5056cbb05c63c63dd097791cb486bb7c','665a24fb88a0044a28f4e08e866624b0','005d043a94ebd93c590ef36153070749','cb20b8e6bf87a1435a16d82d63435c8d','1cde2b6688e439f668de93d29a08a61e','b6bb56df65e84183d5c27f4d18f1dc7b','51941d290393eb8980d2183778c4aae9','2bd8c63b2fe3e8e3b4f933b6130f49e6','e90dfb84e30edf611e326eeb04d680de','e90dfb84e30edf611e326eeb04d680de','ed63fc91500594c3086714f86b3001e4','e90dfb84e30edf611e326eeb04d680de','994ae1d9731cebe455aff211bcb25b93','25a81701fbfa4a1efdf660a950c1d006','00054b8b0ba8c63017611b99e6bf1f3f','685ee6ffb188ef0cb75a4168f08b42e9','9594eec95be70e7b1710f730fdda33d9','78a32818920b094491c8b7ef3965d987','ed63fc91500594c3086714f86b3001e4','ed63fc91500594c3086714f86b3001e4','909cea0c97058cfe2e3ea8d675cb08e1','83217adedb82bd0593742ddc89ad1480','eb5cbe60df6c0a495b4ff3a7b44adbe3','eb5cbe60df6c0a495b4ff3a7b44adbe3','1cde2b6688e439f668de93d29a08a61e','1498eaf4ee578486c249e454fc484c6c','555c55f781866ad4f17f82fd7152ec14','eec06c7a11543ee9803cf280ca775c47','4f90c7cbff2f9d1ace31a1a551c2cd6e','4f90c7cbff2f9d1ace31a1a551c2cd6e','4f90c7cbff2f9d1ace31a1a551c2cd6e','4f90c7cbff2f9d1ace31a1a551c2cd6e','db547a9a5b84991c24ec850ac0749c0b','b3de5045d4f335597ac9a23fd225e3e7','db547a9a5b84991c24ec850ac0749c0b','f6937723663d9c11f1ee4edf9f935fa8','80dcdf1bc72378443fdbda512cb91a13','80dcdf1bc72378443fdbda512cb91a13','1cde2b6688e439f668de93d29a08a61e','aa2396143c08a68c272f01d9756c767c','936bebf04fec94db521203c080dd961c','92a9dad1f9652c5b021098e2274c7368','6084badbe00ac6bdbe621baf284d02d8','6084badbe00ac6bdbe621baf284d02d8','8ad0030a8dcd7c42d1a29f4528b2f407','1cde2b6688e439f668de93d29a08a61e','b3de5045d4f335597ac9a23fd225e3e7','461cccd02e90655892dbf7c86cab5439','38dffaa6a6662a0c685d018052059785','b81c52fc4be71ee1ab08936c79354531','2e39daaf4d20d79edebb7247ce23261a','1cde2b6688e439f668de93d29a08a61e','b083eac18cb23b34fc1bae5e377f13ea','240b33e21c1d0f2b2be8e0ab01f9f20f','e2f9bedacfebdc32f7ba1e80f9b8d69b','994ae1d9731cebe455aff211bcb25b93','d382816a3cbeed082c9e216e7392eed1','57f017497147c828b9b064f6b3ac12d9','770eb18d1c3cc39933081001d0c18637','115760a39a28c071cb1ca3f16ba08d01','115760a39a28c071cb1ca3f16ba08d01','159fd886c1c9c0bbeb5deeb70bf3fabd','30b7d7913825a76c055807079f491a46','1cde2b6688e439f668de93d29a08a61e','f78d9bbef113379488b6ae2b9016d4b8','4e0da454761202071787120430ad6d1f','4e0da454761202071787120430ad6d1f','56b903949445076a918fa89b29b3a255','8a002a0d903a60d9788c1d177cbb893e','9722c34498c147e739d7934010741c81','2f11bced07af78b88fe03a5894e86382','f9606d10d761f00880775f1474adb1e1','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','eec06c7a11543ee9803cf280ca775c47','1cde2b6688e439f668de93d29a08a61e','e2f9bedacfebdc32f7ba1e80f9b8d69b','1cde2b6688e439f668de93d29a08a61e','e2f9bedacfebdc32f7ba1e80f9b8d69b','1cde2b6688e439f668de93d29a08a61e','638a023d48bf728daa9be7fb61e10ee2','1cde2b6688e439f668de93d29a08a61e','9b07c1269fe3afd3f2bbae338f93ce07','1cde2b6688e439f668de93d29a08a61e','c5c1160aeb264daeb63ae5d048194827','8c2857a9ad1d8f31659e35e904e20fa6','42efe43ac3bb235a3a819062de72c562','fb711bc3b7e163f2cf08900694b4730c','3ce68cf813bc34243279fd7fe3cecbbe','b2a3b84300906eed0caa479be9c509cd','b2a3b84300906eed0caa479be9c509cd','62eb9ae8c3a4899a473a35ee5a493647','acb0594e33ec59d944003e021f649a9b','1cde2b6688e439f668de93d29a08a61e','19ede5a51f2f3d148d5904ae5adfde67','916cf7c80dad54a2eb7a1863267dd977','916cf7c80dad54a2eb7a1863267dd977','c59d6df802c32f037c2a15ff75faec17','1ab67d54125e7b2bd931c766113c49df','b3de5045d4f335597ac9a23fd225e3e7','285b1e555be11cbab91d80ef479970dd','b1e2171bb6be58c408f58debe611ee0f','53b0da5ebdaf5e8dd7e3a236074bea8a','513d3ff14320ba7691f67bae46066e25','8dc5344bc0746e1cc5abf896ca03bbdf','7280a4d623cd6bec7ccc98d3a70210c9','b3de5045d4f335597ac9a23fd225e3e7','f6937723663d9c11f1ee4edf9f935fa8','f6937723663d9c11f1ee4edf9f935fa8','b3de5045d4f335597ac9a23fd225e3e7','b9ba865fec061c9706d2fd7ce49c0cc7','ee38e4d5dd68c4e440825018d549cb47','c2cea8a95cf684677acb5822c9f64c64','1cde2b6688e439f668de93d29a08a61e','e2f9bedacfebdc32f7ba1e80f9b8d69b','b9cbb458ed8067427c618e702c748f3d','e2f9bedacfebdc32f7ba1e80f9b8d69b','dda8bb78b527999a738f859d108c5928','05057bd393c2ff7213601abfe8ddc741','05057bd393c2ff7213601abfe8ddc741','d88e071f4bb52106d08b7e7a395a0e96','fd1b97db4966cc165e7101c8fc3114c4','5673948b4ab29ec547634c92bb7ccb02','dc07af4471578d5288210631a211e197','131c98c8ab1fec16b2018aebaeb44f8b','fde133e940f7aba05ebd53430831152f','431af4ad56a5031fb552d40c32fd8251','513d3ff14320ba7691f67bae46066e25','53b0da5ebdaf5e8dd7e3a236074bea8a','bef0cabdb79ea575fb8b4f6100f4786f','bef0cabdb79ea575fb8b4f6100f4786f','0e5d7cb11d2bed170b55eb223a45881a','6932d754f10030754ef79cbb8d1ff47d','1380eb8c2ee48815a55ef2f9d51e0c74','1cde2b6688e439f668de93d29a08a61e','a4ffdcf0dc1f31b9acaf295d75b51d00','9a2e5ea3ec12231a2fbe6f8c75139e01','50f22187e71a5b4de3189149d98a1518','805e03ee7db28893bb412679ee49a6b9','805e03ee7db28893bb412679ee49a6b9','6b06e632160dd5621ab0a127f19e1734','1ab67d54125e7b2bd931c766113c49df','b3de5045d4f335597ac9a23fd225e3e7','5344e5ae58a454f75268240cff5ae1be','9b9a6a80bb230782c712bccfcbdb5c02','1cde2b6688e439f668de93d29a08a61e','6257a1fb99a5fdb041076b1c46cb3ce3','0131a2dcf1052a0d9d928e02056bc582','8c10c8909d0ef500b08ed0001b3cab21','ca247e19286092d0b408dbc064a97fcb','5355dbc5d740bdbf21da8ca446f485bb','74826fb51a5f3f1b6fce4a9f49229984','52f1d775f972583b80de82d7a0c2611a','368347fb14f096dbd8122b9073bbd50c','4ea1583a74998c524aae6d05406146c6','afbfc0995a8bdfc77b23b66464325e25','0b113cbdbd6aaf449b53bb7d9f0b118e','38c7e1a98047b1db920483ba17cffc8c','7d461dfb8fc83a55d2e5c6e4704c287f','8163cb6edd4551902a5a1b40c631db0b','ffca9ff4b790805e38e41773c9850c55','d51979e2d6e3548846f5ceceb3ff71ca','11c6c8616b362ac0155fea3983ac4c23','883d9efdb975b04427e81df1acb92f36','bdb4871140b90049e5acb10851e25670','3edcaf57e2d5ed3283cfe0894f3570ad','c884f1a329c6a121fd31191f41f88f29','afbfc0995a8bdfc77b23b66464325e25','650eb131025ef2e4795fc67e71378e34','be1692f98cd337f3796f01eebc305852','7e7d32339ca4f304d505e8f1bca6dc41','7e7d32339ca4f304d505e8f1bca6dc41','81b91a2ce20f8daf49c0ddfb05a6e7b3','d711a390f9dd2597b938a8e760318214','7ef0bf02f477f060b09f9d27a4355e26','2dcbdaa0a6557ff7606fa595f16538aa','625a6c2cf8852430cb6140146702bd75','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','2dcbdaa0a6557ff7606fa595f16538aa','afbfc0995a8bdfc77b23b66464325e25','0f4564a41e56498d0151c71368efe3df','afbfc0995a8bdfc77b23b66464325e25','b79e6193147ef7854632afd720d36dbd','afbfc0995a8bdfc77b23b66464325e25','35b39f7bb6b29e2c382c6cdb72ad799f','afbfc0995a8bdfc77b23b66464325e25','2527f25884273fb2f53c29442c65bad6','afbfc0995a8bdfc77b23b66464325e25','46523d58fc9f87d58d206a02dbdade55','afbfc0995a8bdfc77b23b66464325e25','c2a6a5e39c5b59c4f47f8ee8b2138fe5','b77f1cf5c9fbf40c57444b3258c290bf','c62b398ef5e5a59200553e5c75af9c13','fedb05def86758de5d4b1cc5e13335e3','e87bce1773a53866e480d39672946c79','17e16502895687d084e986598f0c142b','39f6e758feae4691851274ec6f303d64','11036f23dd4a0e1bee230d3aa4bef44a','afbfc0995a8bdfc77b23b66464325e25','83a1bb1ac1b81119fd561bd32e4b07f6','83a1bb1ac1b81119fd561bd32e4b07f6','3b9dd23860773d29244fdcecf8d93091','f7e0b7118dbe431da3cae95262d1c94e','d2be962c4a93e895db63b2450b44b43f','afbfc0995a8bdfc77b23b66464325e25','205a525e0bfb7a349df6f3d1b5b5002b','ee6e98c09b286f204a891878e0f7b3c4','1df65fd74f35f632e667687e312a6c21','1df65fd74f35f632e667687e312a6c21','afbfc0995a8bdfc77b23b66464325e25','df077592ca482b300a8469c074fb6076','e7be71e3ac6717dd6f13d1475b4b8f15','8fd97d99b10a4177a727671834467e2c','374f0b65d6e140e53c856da575af0d83','1e2fd3ae69f3ae2037afe4e51dcc3387','6e305f55a76cc85c9b378208a5bbd127','2a58f99bded717f3225d19266993c1fb','2a58f99bded717f3225d19266993c1fb','ec485895b881b2dc9472bcc78940d27c','185823939d1bebc3946ef363dcff3f75','6adc374b80ec8ec20cfba940f7a0c34e','4dfe3d178220571f543f93917b9b4e32','6ac88e7bbb1c7c6a265f45403098adfa','715dcc85398edea2cf9a0910c4a343dd','715dcc85398edea2cf9a0910c4a343dd','afbfc0995a8bdfc77b23b66464325e25','eaf9092f074d22d870cb4a52ef6b3df5','7be2872a7d49c42b2e089a83b1c53d7b','50f22187e71a5b4de3189149d98a1518','70e3be6ae863d8dc8996463ef746b247','70e3be6ae863d8dc8996463ef746b247','158176991f43d5bdf6c52b258bf05cf4','d5e179e49d237df65c7423130723eb24','5eb7106e47d880bea6dea5bd5b090494','778f5a2c3e53a27bd7a1e7fd815929bb','cdd5994f1b66c8091af258515e76fc71','9fd45506caff7af65f821e5a7a4ea9ca','db97b11af68e66a72b705ed8230a8544','2810af93a5b217bb2b65d54de3f0e5cf','aa7bc4f86f0b9b8c623a9fec9e628331','6f9c7b21fa6b221f953c7292a8d62f0e','447d9c5b76695e10757d17af8444f5fc','3baef1f9742a0a74b9fc4009cbaae6b3','2810af93a5b217bb2b65d54de3f0e5cf','0738b2cc4152674e12553500f5953857','0738b2cc4152674e12553500f5953857','2810af93a5b217bb2b65d54de3f0e5cf','c683da6afedf3c9c8725947419e8ca1c','cfb78a347b4d8ab71eb556fd484970b5','f91bc368a4e7282cd9fd480482ef5484','afbfc0995a8bdfc77b23b66464325e25','58d7199cecfaa48d55e9908323757cde','def5d95cbb45a508cc1ac627ab882944','4774d2fa5a595e3069d5bb782d1049cd','afbfc0995a8bdfc77b23b66464325e25','66f93d54c89dc1859b3053c543cd75d7','c2893f196b52f07b62a7233b74823e15','1d611719cfb51e68bf0535b1dc8eee5d','a4b82222f3960f06a57fe3aabae1b85c','cb384cae3cbc255f803e14dc387b713e','7feb6c6a07ab32579f359e2197006920','46523d58fc9f87d58d206a02dbdade55','9328ada3e77c565a5b1eee305b067072','15929fbe16b6d73b715b9604dda9ba2c','f4ba120e7f03fe1738fccb6c4783cd07','4f213f7d5ebdefb9fc1cfb57afeac9f1','becc1d541fccb90e615d997ab3ac02dc','5447b1862f47425e7226ecb0c4be702b','c6119d008ba60d8119e777256ee516af','2d1734af204de8a6cef3b3863ff066da','65123bde2864cc5b9152c5cd6f1ab7fd','201e1a8de412c9cae926ecc640d7ed6d','9b95ee7354bb0cc1bbde39e0f3fad9f0','0cb399fa7d707fb28695fb8eb985b2a8','0cb399fa7d707fb28695fb8eb985b2a8','04a710bd422a00c022c8a3e372046896','8f3399d47fd6bab6cf2ef278ee0a65af','88454279e41e7886aa42421b71a124e7','0738b2cc4152674e12553500f5953857','88454279e41e7886aa42421b71a124e7','2810af93a5b217bb2b65d54de3f0e5cf','8d59adcf4867aaa9e1921c66e04f74d8','afbfc0995a8bdfc77b23b66464325e25','18e5c85b4c3cf2a25629bfb040e8382c','18e5c85b4c3cf2a25629bfb040e8382c','2a58f99bded717f3225d19266993c1fb','18e5c85b4c3cf2a25629bfb040e8382c','becc1d541fccb90e615d997ab3ac02dc','fdc13855f830f2f03d36fe3f645e7a3e','ef1d8502709bfb2c2e08aa584ec42807','0e42e10aaa9249960d153b9bc25976f6','723883c6a052343fcac8473afe148879','4d9e7cecdc2a013130cefd57eab45441','433d06ef8bee1cc16fac1ebb4b8f8036','db97b11af68e66a72b705ed8230a8544','2810af93a5b217bb2b65d54de3f0e5cf','218c7a734abdd77eccc499f5bffa4f63','2810af93a5b217bb2b65d54de3f0e5cf','495a51c984340669664cdb5213024587','c2893f196b52f07b62a7233b74823e15','66f93d54c89dc1859b3053c543cd75d7') AND ( `language_id` IS NULL OR `language_id` = 4 )

SELECT `ov`.`option_value_id`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN `oc_product_option_value` AS `pov` ON `p`.`product_id` = `pov`.`product_id`
INNER JOIN `oc_option_value` AS `ov` ON `ov`.`option_value_id` = `pov`.`option_value_id`
INNER JOIN `oc_option` AS `o` ON `o`.`option_id` = `pov`.`option_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p`.`manufacturer_id` = 5 AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `ov`.`option_value_id`

SELECT `f`.`filter_id`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN `oc_product_filter` AS `pf` ON `p`.`product_id` = `pf`.`product_id`
INNER JOIN `oc_filter` AS `f` ON `pf`.`filter_id` = `f`.`filter_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p`.`manufacturer_id` = 5 GROUP BY `f`.`filter_group_id`, `f`.`filter_id`

SELECT `m`.*
FROM `oc_manufacturer` AS `m`
INNER JOIN `oc_manufacturer_to_store` AS `m2s` ON `m`.`manufacturer_id` = `m2s`.`manufacturer_id`
INNER JOIN `oc_product` AS `p` ON `p`.`manufacturer_id` = `m`.`manufacturer_id`
INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p`.`manufacturer_id` = 5 AND `m2s`.`store_id` = '0' AND `p2s`.`store_id` = '0' GROUP BY `m`.`manufacturer_id`
ORDER BY `m`.`sort_order` ASC, `m`.`name` ASC

SELECT *
FROM `oc_seo_url`
WHERE `query` IN('manufacturer_id=5') AND `store_id` = 0 AND `language_id` = '4'

SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max`
FROM( SELECT `price_tmp` AS `price`
FROM( SELECT IFNULL( ( SELECT `price`
FROM `oc_product_special` AS `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 ), IFNULL( ( SELECT `price`
FROM `oc_product_discount` AS `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 ), `p`.`price` ) ) AS `price_tmp`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 4
INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p`.`manufacturer_id` = 5 ) AS `tmp` ) AS `tmp`

SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max`
FROM( SELECT `price_tmp` AS `price`
FROM( SELECT IFNULL( ( SELECT `price`
FROM `oc_product_special` AS `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 ), IFNULL( ( SELECT `price`
FROM `oc_product_discount` AS `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 ), `p`.`price` ) ) AS `price_tmp`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 4
INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p`.`manufacturer_id` = 5 ) AS `tmp` ) AS `tmp`

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/footer' OR route = 'uk-ua')

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

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

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

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

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

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

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

SELECT *
FROM oc_seo_url
WHERE query = 'information/tracking' AND language_id = '4' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '4'

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

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

SELECT *
FROM oc_seo_url
WHERE query = 'affiliate/login' AND language_id = '4' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '4'

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

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

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

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

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

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

DELETE
FROM `oc_customer_online`
WHERE date_added < '2026-03-26 15:37:44'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.51', `customer_id` = '0', `url` = 'https://eurocosmetics.com.ua/uk-ua/roberto-cavalli-uk-ua/page-3', `referer` = '', `date_added` = '2026-03-26 16:37:44'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'footer_1'
ORDER BY sort_order

SELECT *
FROM oc_module
WHERE module_id = '49'

SELECT *
FROM oc_module
WHERE module_id = '48'

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'extension/module/html'

SELECT *
FROM oc_module
WHERE module_id = '45'

CREATE TABLE IF NOT EXISTS `oc_jetimpex_newsletter` ( `jetimpex_newsletter_id` int(11) NOT NULL AUTO_INCREMENT, `jetimpex_newsletter_email` varchar(255) NOT NULL, PRIMARY KEY (`jetimpex_newsletter_id`) )

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/jetimpex_newsletter' OR route = 'uk-ua')

SELECT *
FROM oc_seo_url
WHERE query = 'extension/module/jetimpex_newsletter' AND language_id = '4' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE `query` = 'extension/module/jetimpex_newsletter' AND store_id = '0' AND language_id = '4'

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'extension/module/jetimpex_newsletter'

SELECT *
FROM oc_module
WHERE module_id = '40'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'uk-ua')

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/footer' OR route = 'uk-ua')

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

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

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

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

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

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

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'extension/module/jetimpex_footer_links_information'

SELECT *
FROM oc_module
WHERE module_id = '42'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'uk-ua')

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/footer' OR route = 'uk-ua')

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

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

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

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

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'extension/module/jetimpex_footer_links_service'

SELECT *
FROM oc_module
WHERE module_id = '43'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'uk-ua')

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/footer' OR route = 'uk-ua')

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

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

SELECT *
FROM oc_seo_url
WHERE query = 'affiliate/login' AND language_id = '4' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '4'

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

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

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

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

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'extension/module/jetimpex_footer_links_extra'

SELECT *
FROM oc_module
WHERE module_id = '44'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'uk-ua')

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/footer' OR route = 'uk-ua')

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

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

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

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

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

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

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

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

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'extension/module/jetimpex_footer_links_account'

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'extension/module/jetimpex_layout_builder'

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'common/position'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'footer_2'
ORDER BY sort_order

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'common/position'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'footer_3'
ORDER BY sort_order

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'common/position'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'footer_4'
ORDER BY sort_order

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'common/position'