SELECT `data`
FROM `oc_session`
WHERE session_id = 'af6ece136bc9f33adeca2d0dbc' AND expire > 1774539508

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 = '1731fc55a8a20309c26505265d' AND expire > 1774539508

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 = 'cloth-uk-ua' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE keyword = 'dresses-and-sundresses-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/category' OR route = 'uk-ua')

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

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '4')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '649' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'

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

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '4')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '751' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'

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_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '4')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '751' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_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 p2c.category_id = '751'

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_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_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 p2c.category_id = '751' 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 = '1774' 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 = '1845' 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 = '1688' 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 = '1693' 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 = '1807' 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 = '1699' 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 = '1836' 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 = '1772' 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 = '1766' 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 = '1689' 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 = '1774'
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 = '1774' 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 = '1774' 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` = 1774

SELECT *
FROM oc_product_discount
WHERE product_id = '1774' 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 = 1774 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 = '1774' 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 = '1845'
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 = '1845' 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 = '1845' 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` = 1845

SELECT *
FROM oc_product_discount
WHERE product_id = '1845' 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 = 1845 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 = '1845' 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 = '1688'
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 = '1688' 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 = '1688' 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` = 1688

SELECT *
FROM oc_product_discount
WHERE product_id = '1688' 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 = 1688 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 = '1688' 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 = '1693'
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 = '1693' 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 = '1693' 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` = 1693

SELECT *
FROM oc_product_discount
WHERE product_id = '1693' 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 = 1693 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 = '1693' 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 = '1807'
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 = '1807' 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 = '1807' 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` = 1807

SELECT *
FROM oc_product_discount
WHERE product_id = '1807' 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 = 1807 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 = '1807' 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 = '1699'
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 = '1699' 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 = '1699' 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` = 1699

SELECT *
FROM oc_product_discount
WHERE product_id = '1699' 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 = 1699 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 = '1699' 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 = '1836'
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 = '1836' 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 = '1836' 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` = 1836

SELECT *
FROM oc_product_discount
WHERE product_id = '1836' 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 = 1836 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 = '1836' 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 = '1772'
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 = '1772' 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 = '1772' 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` = 1772

SELECT *
FROM oc_product_discount
WHERE product_id = '1772' 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 = 1772 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 = '1772' 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 = '1766'
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 = '1766' 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 = '1766' 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` = 1766

SELECT *
FROM oc_product_discount
WHERE product_id = '1766' 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 = 1766 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 = '1766' 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 = '1689'
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 = '1689' 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 = '1689' 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` = 1689

SELECT *
FROM oc_product_discount
WHERE product_id = '1689' 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 = 1689 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 = '1689' 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 *
FROM oc_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

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

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '4')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '751' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'

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

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

SELECT filter_id
FROM oc_category_filter
WHERE category_id = '751'

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
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(751) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != ''
ORDER BY `txt`

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'attribute' AND `value` IN('9cbbc7cfe336ac7d691b7b5f676c55d5','42bbb3c6959951ecb34193ea6f763673','540804ba605fe6cf2cf53a0e2a2d23fb','7688c7b7cd391e1291cbcbebdd6ea6a3','2c6c0cd211d248d2df4032aec293b74a','6e066c094f55b46b6a2a0389cd327597','6e066c094f55b46b6a2a0389cd327597','eab9c17f753487685ab1a6c045cc2301','d5dc16bcf4a43a08bc9bea7bd9ba9cc0','5d8edf1c3a632254ba485ff225281156','e217437154133562a183fc4de5da9ba0','0a73d1745726dc2840faf3ea072cef0d','ba00aa662a7d565ec280445674be1634','17ebe2dc178113b2c4b7e50a7a7ddd3f','81e1c2626df3ff4f5faefc596e754506','81e1c2626df3ff4f5faefc596e754506','3987edb0349638a2b956e4ca8844ae11','3987edb0349638a2b956e4ca8844ae11','59faa49a6a8a6721ea03506492aa6954','1b315df828e840e503c560f7be488685','ca642234b52c3ce506891dc52802fde2','895be339425503f6357f5c43c23c4d42','c3c0977d6f63ad45d041d1f6c67b74fd','08c183893966fac6b06edca3615791ef','62a2f715da44e201104bb137000ac051','cfa4e8bc9b30e7821c48ec7b8edb4a0a','07f570de8134994bff0274c074e7f01e','62ad22e97acc179f9717f059ae68f1c1','fabff85f135dadaef95f3f98fcf916a6','26f0c5cd01699f9de8bd1691341ef5fb','2b3ce24f2893b56ba371ca583bb8853f','9d9c970e58e318820a28dd25e64999b7','1badb47680ed9c700391806ccd879293','c3c0977d6f63ad45d041d1f6c67b74fd','08c183893966fac6b06edca3615791ef','62a2f715da44e201104bb137000ac051','5a6b66f2bca052bef168c1363e2c089d','bc84f0918f2e1bc2071f24922d2b8dd0','fabff85f135dadaef95f3f98fcf916a6','26f0c5cd01699f9de8bd1691341ef5fb','2b3ce24f2893b56ba371ca583bb8853f','09bbeac58f2e7196a4181e6d07b88fb1','6f85d8fcb09a59d8a7ba7f40cd26b6fb','50de03da7c610a8e019647de9602d359','a2c4888e20c14f60784580ee0ae475b7','9357da9d9419f831b988f6acde3153dd','43bba092316884ebb70180a3ce2292fc','235434d661f26b58c766b01b05d016be','c0254767622878edae9341036b99282c','96b8aab594307f1e865c8f408acd7aac','3d070367824ba91276052c86974ee9ba','9452988bed5d07288fd2c5054c452678','29a64080b37731abcbd3e1e7a55eabd0','be72cc96a4639122038dd58f5f4a4b0a','d39c375efb3a8205ecc298964bef28bf','3b08a3d52aa704f0614d4789c9c3316d','67b58d1080a9f125cd7699f02c184017','80c0bb9dd990c69dca48a8fff34c150f','1fcd42c54a118d2bf159f148d5d742e0','cb09b5996c211cf75b2273b5ed7f1b49','2106ecef913489aa7d1fa3d0aa179d53','0bf20552358297ba84acafc08c14021b','f9e22308c8ba64482733755f9ced45d9','9a1642d1e7f99b2ecca39f9db2b991c9','67077a2db2f93eec28d08ca51cbd3313','20bd520b29655a9068eec05b6057ee8d','309af512970fd9d1653cc5aefe465814','af708b0ecaee1ed39ff81cd72a9be4ae','f3648f25412588289a9b5a4d5e0b608f','bed9e5399b49c59cecf8d7148fa71a71','af3a533ebcf93e2dc12b6b402c94c4af','ed7591d1930a14ffd58e252def471a7f','cc9536a1499b2c9e0ce5e611ff9b2a8c','eb2158c5ce2ed32732c6653ce8d7d0b4','7d120eb09f8054368fb2c3522fa8231d','e1278ca6c81972ddd5f4cb618b120aee','14a2c48189de87e6c199f5c68ab39e52','cc5062f7d50afe8c5ab1b7bcfe3e8e86','9f336853d451c88280bf24e11703d441','52db4e33d8fa36cdd65310ab937d35eb','b709194238c1dbcd12b0072689dfc73a','01921bbebdfd806f69a728685fc836b6','ad701a16dbc5ded271a55ede5efcb6ad','72890a575fd66eeccd512497a199eeeb','a42bee261a926a5108e331a94a31d402','01921bbebdfd806f69a728685fc836b6','ad701a16dbc5ded271a55ede5efcb6ad','72890a575fd66eeccd512497a199eeeb','a42bee261a926a5108e331a94a31d402','08db92a84cc5e8fc6e9e0d2a3fd4d28f','abc933ba141f59a94bd4b94482217d33','32c392cec0c6727ebfad4d1894e28d18','b5547a2086bda3b2c8628990ff40ce4c','08db92a84cc5e8fc6e9e0d2a3fd4d28f','abc933ba141f59a94bd4b94482217d33','32c392cec0c6727ebfad4d1894e28d18','b5547a2086bda3b2c8628990ff40ce4c','808b93b242fe351d03e80abbf604b317','c65cefadef93795fe8657209bbe7a05e','a9dc38f56fbfd70756148ad2b9526228','77d94c730a2208c33b93201d6f844338','5fcaae8903fa4552ab05370207a0f092','cdd7406234f317e758def14ce413999e','4cc64fe0f67cd9bfc33f2b8a7cf7c45f','8a762997d6d4536b1c245c722a9c93b0','0f6857c4a3fd2680166b19d343563523','927deae51e9d98158c2668a49d7e188d','4ac612c397b9f298da4189ff2b9d07a6','19c2f091f44ca3e158836e893c98ea9d','29db6714d81c49cda9def0b227f96205','f560ce9be94545c1dc83dabc396f2b34','97c4f28ddb29ccfd9b752853289bab95','80a8e6b850db57256274e5ddc9927633','e04db10fea3763438b232afee329091f','55ee1b6a043d3bf24960bbb785847cae','695c164d86e153fc728bea8f41544f6e','4591b77d4a26be55f17c230bf1b81aba','31351f6436b9fdb31806db6465c6cfbc','8ee8795463fb1f3e508b7a5f9b968d33','0908efe71dde699afc3efcbb99f0bd98','9c3de626a4f139b6b4aedf8e8fa1979a','4dc18c30d2a60a06122e6e3e1797ba32','c3c25ec8dc7df23c92470620637f7046','f1d899b3a3f97d4b8827533aa693db80','8b02b4cd632da2a23cb21c535a6adebd','4c1822afd9b060a111c7980abd20c48b','5f4379066a43378c5e28b8e00c27c6eb','eb5654c98ed652aa4f570bd3f348ba8c','a921fe7016083d73793600b47ffcda09','eb5654c98ed652aa4f570bd3f348ba8c','a921fe7016083d73793600b47ffcda09','eb5654c98ed652aa4f570bd3f348ba8c','b2bae310d13b5fe9b056cf03b66e98dd','980dc654c9e7b6626c2de59c9e808172','da945215f374ca3f6ebee8daa3933f03','980dc654c9e7b6626c2de59c9e808172','da945215f374ca3f6ebee8daa3933f03','980dc654c9e7b6626c2de59c9e808172','87f4ef05df819af73afe1f0dcc737f90','b47091460b5ddcf3e44ee6d21e2ff318','91f5dd292787d3d5d60aab295453d2ad','2ea13a11607ea72718c2bfd8c70f8457','665a24fb88a0044a28f4e08e866624b0','005d043a94ebd93c590ef36153070749','4f6f5b197865242200ce74fb70f46ff0','b065d666ce59074d278610a12b56c6b0','36a1c3d8b460c69fc7ea00c722f09149','44c6c370fd1859325f7119e96a81584e','b065d666ce59074d278610a12b56c6b0','44c6c370fd1859325f7119e96a81584e','775a0921430e96c0575ab1d8b319aabf','90a73870634c599dda9e5b5742e37623','cb53534f42f1a2e7f1b7f5674041d0ab','c2994b894bd20b37ff3c436a286513e3','c2994b894bd20b37ff3c436a286513e3','c2994b894bd20b37ff3c436a286513e3','ac57463a8e5db99f4eaeec8a21aa7793','f428bff374e83c9e6d9579f9b0f5e540','0af955ed2c8c83f9464203d5b648b2d0','0af955ed2c8c83f9464203d5b648b2d0','e654324144e7cccad50341623df3246f','e654324144e7cccad50341623df3246f','7b3f0e8d38622c22060c2bcdf2182e5a','7b3f0e8d38622c22060c2bcdf2182e5a','e90dfb84e30edf611e326eeb04d680de','9860a819d06618eb4432cba78c624084','3ef96dec05f1dedc48738613ecf0a39c','fcdcc206a21b4e234f419cf3ef074264','5681793d994d195dce297a8a090ce0d4','b97c6e8e56a538a7b00e31e5f6c21c75','e90dfb84e30edf611e326eeb04d680de','994ae1d9731cebe455aff211bcb25b93','25a81701fbfa4a1efdf660a950c1d006','e90dfb84e30edf611e326eeb04d680de','ee38e4d5dd68c4e440825018d549cb47','685ee6ffb188ef0cb75a4168f08b42e9','9594eec95be70e7b1710f730fdda33d9','57def18d4fc45a6b3f50a17b9f5236ae','e7faf2da0920a943fcaa396e78f5a62c','4f90c7cbff2f9d1ace31a1a551c2cd6e','4f90c7cbff2f9d1ace31a1a551c2cd6e','4f90c7cbff2f9d1ace31a1a551c2cd6e','4f90c7cbff2f9d1ace31a1a551c2cd6e','aa2396143c08a68c272f01d9756c767c','4e322d264f6851e2b82d7eaf1182485d','8e5be2e5cc32cb4eaeda83c5f5c96a36','89ffbe6bd5662323e30539392537fe21','62eb9ae8c3a4899a473a35ee5a493647','7af9f0f0f5a65740edd3d3abcc15749f','1cde2b6688e439f668de93d29a08a61e','9ba68378cfc67b29078e391a99a8d0f6','9bbed4c1a83ccd325b1143eeae1f4f89','87ce766ce5c0b6317258df8c2eb0908c','93a71c88a154ff33ba818620e8917433','b81c52fc4be71ee1ab08936c79354531','8e5be2e5cc32cb4eaeda83c5f5c96a36','2e39daaf4d20d79edebb7247ce23261a','1cde2b6688e439f668de93d29a08a61e','627fdd0faf48dd78bdf8aa73f4f2496c','c9c3078d4cc587e8d89d3a037268037f','4b8ff0b6d17f158184e562f3d7542cf8','8f9e3b9e2d68557d6bae87d2597de63c','5051d7e087c6f8425b8d3421aa1e0908','b817b2657c6ec0631ec66e1607441538','fcdcc206a21b4e234f419cf3ef074264','e2f9bedacfebdc32f7ba1e80f9b8d69b','994ae1d9731cebe455aff211bcb25b93','c590a00f1f77567d04245b02be2806f2','0b782c1529f2f13db27c842d5c6651b2','1007e1b7f894dfbf72a0eaa80f3bc57e','3cda26e0c8aedbf662adb42f923ef3ec','723bf438a0555fbb28435115c2fe5081','723bf438a0555fbb28435115c2fe5081','7ec23b405c5319f55b7660569c077f41','f78d9bbef113379488b6ae2b9016d4b8','f78d9bbef113379488b6ae2b9016d4b8','f9c2943e0d0c005e947c22766545e518','e696cfb75263788b6e4d057840384ee9','d4702976da671d7e6974bad793f55160','12bd90d4f0f81c72b4176958ffcb6985','579f9586f1d5a9bb22d3a58fc8e9f66a','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','9b07c1269fe3afd3f2bbae338f93ce07','53b29051e23c27c349750575f89e9ca7','fb711bc3b7e163f2cf08900694b4730c','3ce68cf813bc34243279fd7fe3cecbbe','b2a3b84300906eed0caa479be9c509cd','78fd84754c789cb7cc856eb0e409e9c7','19ede5a51f2f3d148d5904ae5adfde67','19ede5a51f2f3d148d5904ae5adfde67','df7de9566cb6188303d3b429b664bb86','df7de9566cb6188303d3b429b664bb86','988f1999650236a417a05fe44fb03c0f','988f1999650236a417a05fe44fb03c0f','d3d5b2e9cc26e07d9bf4ebfbab15fda4','ff5fcfcdc8b4577f419b016c60d914e6','e18f6869fb2cdf1b34a27ed86267c1a6','491514a4cb2212b5b7a5dd121a74b557','e18f6869fb2cdf1b34a27ed86267c1a6','e46a5e9e02069fbc58fbce3ef16e0514','e18f6869fb2cdf1b34a27ed86267c1a6','e46a5e9e02069fbc58fbce3ef16e0514','b30c031b0fa69d7053f02b0c2161bfe8','279ac0d4a97a735287813384ecec078c','f6937723663d9c11f1ee4edf9f935fa8','1a3200625f013506c169c81d2dd757d8','e885942c4c756018e29cccb54954ec27','a48296ad11ed041e4db9991af1057fb6','b9ba865fec061c9706d2fd7ce49c0cc7','5416604d6485106a946d893b712c2b7b','76eeabe64c6315e8fd022cb7eeab21cb','aae44179fda7ddcbf8916aff53846128','f6937723663d9c11f1ee4edf9f935fa8','8c5e0c95c9865414aeac821720a972e5','1ab67d54125e7b2bd931c766113c49df','a2a3a0347f0f001a4473dd54dca2462e','6cfa9cd1b2c1d292bc1bca8c9a78f272','55e9ed64ad1629f6b4b44881be08c75f','8ffc12f3f80fba88b1be0adeb5fbc872','8ffc12f3f80fba88b1be0adeb5fbc872','dda8bb78b527999a738f859d108c5928','dda8bb78b527999a738f859d108c5928','825a3d98017bab11815ad2817201324c','e9210a5da8221d2d2ef641c18d019057','18a357eb68ce7db36684f45100252be3','73f8e0bc6e6980db16a0d878200472c5','827be025cdd009be09444095a9097ada','a2a3a0347f0f001a4473dd54dca2462e','b3de5045d4f335597ac9a23fd225e3e7','a2a3a0347f0f001a4473dd54dca2462e','6419e6342781a7bae27e4fea57721028','fd1b97db4966cc165e7101c8fc3114c4','5673948b4ab29ec547634c92bb7ccb02','dc07af4471578d5288210631a211e197','dc07af4471578d5288210631a211e197','e1c15199bdde79d28407d476048154d4','eb67a6ede64ff09edd164a23f41e814b','c48735fb930a5059dc165aa7c790ee6c','f78d9bbef113379488b6ae2b9016d4b8','dc07af4471578d5288210631a211e197','51c9035c5f093c8065cd2621cde4754d','5df2932d0015553efc12da6cd73bfcd8','b599c29e5195888a86aa4cb932ee0d0a','dc07af4471578d5288210631a211e197','b81e866b75e13242f2efa0607676fdcf','1f7e048d176c86f4db5be64045e8cd50','070decfa0c25d062554ffd8918a16f9d','ad90be97d4e0009586339bef2a8c70a7','ad90be97d4e0009586339bef2a8c70a7','1cde2b6688e439f668de93d29a08a61e','ad90be97d4e0009586339bef2a8c70a7','1cde2b6688e439f668de93d29a08a61e','1ef66c14568253e5c3562976faf4af89','1ef66c14568253e5c3562976faf4af89','bef0cabdb79ea575fb8b4f6100f4786f','bef0cabdb79ea575fb8b4f6100f4786f','0e5d7cb11d2bed170b55eb223a45881a','bef0cabdb79ea575fb8b4f6100f4786f','852a3c2a8a9af6fae96966357db996f4','d53f583c5ce68c413bc4ce3f70bcb366','2bcd8d9065ec9f7b2ea102add852f6cc','731c6705a38935215c99c79170ab9f7b','52c09057df9277489a6938e9a9541651','1380eb8c2ee48815a55ef2f9d51e0c74','6e25cbca4a5cc0319e7d2fcdd960746d','3b324bc4a1beb18fe08f9e0cace48649','50f22187e71a5b4de3189149d98a1518','4b1081bea21585f9a8ed05f7add864da','050fe83ebf4a8707cd34426288e1bbdd','27ccb1ff0b78c5857f9da3fb675ef675','1cde2b6688e439f668de93d29a08a61e','5344e5ae58a454f75268240cff5ae1be','9b9a6a80bb230782c712bccfcbdb5c02','1cde2b6688e439f668de93d29a08a61e','25a81701fbfa4a1efdf660a950c1d006','25a81701fbfa4a1efdf660a950c1d006','ee38e4d5dd68c4e440825018d549cb47','3500ff57c182fb918c6dcea2e3e1f192','74826fb51a5f3f1b6fce4a9f49229984','52f1d775f972583b80de82d7a0c2611a','368347fb14f096dbd8122b9073bbd50c','bb3f2ca1ad95a601edf6bb18de20d781','8163cb6edd4551902a5a1b40c631db0b','d51979e2d6e3548846f5ceceb3ff71ca','ccae4521aa99324cbbab27f0c2286de5','d51979e2d6e3548846f5ceceb3ff71ca','11c6c8616b362ac0155fea3983ac4c23','883d9efdb975b04427e81df1acb92f36','883d9efdb975b04427e81df1acb92f36','883d9efdb975b04427e81df1acb92f36','883d9efdb975b04427e81df1acb92f36','883d9efdb975b04427e81df1acb92f36','86b812102524f2db857afdc7f67e3973','945784797d73f8195b29a7bc154da5fc','883d9efdb975b04427e81df1acb92f36','cd6b1b0b9d5dd4aa60ae81a760d09741','883d9efdb975b04427e81df1acb92f36','ed457c6f2a3437eac4e2506fbe37cac1','8895aa7a09902557b92b859f9b1c889c','aef6f7fc769a87fa4273e2442c64f686','883d9efdb975b04427e81df1acb92f36','5cd34463b170e4e6aac49de8e52a7766','516b4bcd959ad2d38401ebca0d861cb9','e38d2c259ac94d1a2587c66f6bef672f','fdc13855f830f2f03d36fe3f645e7a3e','fdc13855f830f2f03d36fe3f645e7a3e','4dfe3d178220571f543f93917b9b4e32','b79686ee96b281ea6379fa030594c4a1','d2be962c4a93e895db63b2450b44b43f','fa101d4ebd6f329d01912c1c01fb449b','afbfc0995a8bdfc77b23b66464325e25','fa101d4ebd6f329d01912c1c01fb449b','afbfc0995a8bdfc77b23b66464325e25','af3e785f80a5d597717aa32edff943a4','3edcaf57e2d5ed3283cfe0894f3570ad','3edcaf57e2d5ed3283cfe0894f3570ad','018462c84784c63a936043f9dbd546f0','0738b2cc4152674e12553500f5953857','db62f70f2c3fdd5c1d0eaef210555c9b','db97b11af68e66a72b705ed8230a8544','58a9689188964296eaaddf03bcb28dfd','14d5a094cc11ee60dc59daa885644cdb','7c732b8fe1f49badd91d5eaf89f9a877','51fb7806552ab80e287bd3ba1bd7116a','be1692f98cd337f3796f01eebc305852','be1692f98cd337f3796f01eebc305852','be1692f98cd337f3796f01eebc305852','be1692f98cd337f3796f01eebc305852','d6859f675abdf2292428f716a2cbcd36','1c9158873b14d897cd1bc452f42b3ec7','677cbda2ad56069e5ddfb97ef5edaf02','357822b4573a65558c0f8804ab156568','e21e1fafb7c7728c5c6960e0b3bb8974','41092d3699955516ea69496581d44e71','625a6c2cf8852430cb6140146702bd75','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','35b39f7bb6b29e2c382c6cdb72ad799f','59dca952c1aa04c36bda1938ffca1856','9a718807d5f64f2cebbb414b95dab4d6','66c608fc9336ba630b1e003e644cb1ac','e87bce1773a53866e480d39672946c79','e87bce1773a53866e480d39672946c79','e87bce1773a53866e480d39672946c79','45f1c446a70ab52b3309b95e9a170be0','83a1bb1ac1b81119fd561bd32e4b07f6','83a1bb1ac1b81119fd561bd32e4b07f6','3b9dd23860773d29244fdcecf8d93091','f7e0b7118dbe431da3cae95262d1c94e','d2be962c4a93e895db63b2450b44b43f','75f72327fd2f2d879db2beb2c85fa8e4','eb00c135f33c8a80415cb951983d72d5','eb00c135f33c8a80415cb951983d72d5','374f0b65d6e140e53c856da575af0d83','65769bfb9cb2d08a2418eaff10e201f4','185823939d1bebc3946ef363dcff3f75','197f91d8d622feab8ad98448d00e9521','cd6f71444c33505d5aec51694f4dadfd','38808bf35ae99ab65f250442be1d7d9f','6ac88e7bbb1c7c6a265f45403098adfa','715dcc85398edea2cf9a0910c4a343dd','90d8a0ae9ef7c0750c575e58ceed08df','01df212d53cc0393ed8426a1c27b0b8b','158176991f43d5bdf6c52b258bf05cf4','db18cfe2bff91aff53249e390c83f411','e3179d06a976e476e720aa3f15658c9b','e5c2b1c714bad8dba478e88fb7a8d01d','5afa942e70fdfb22ee17212846d0236e','5afa942e70fdfb22ee17212846d0236e','b0bb057060b0436419305a6cd40c64e1','6469892e81cd16e29159ba19607bb18f','b0bb057060b0436419305a6cd40c64e1','6469892e81cd16e29159ba19607bb18f','b0bb057060b0436419305a6cd40c64e1','67ff5469854870f1a9af14cf3eb111fd','95b0f51bcb0a95e321e0631d6230791c','de4cca4e6712f7c07a3f7c64bb13f720','39f6e758feae4691851274ec6f303d64','f803899239b443ca0c4c63124385891b','56a7492f88f815ad798ae956c6bd1c4a','afbfc0995a8bdfc77b23b66464325e25','d2788c4a42e2b8cde54bf52f790d8ed1','2c6f893940cc823155580ba941420015','f6761aa24948cfda5b64e722d06b409d','c5c2dde564a8553d31a17be88acd6ffb','0d6a3d8e0b2982f1b362be8968d02db3','6f9c7b21fa6b221f953c7292a8d62f0e','447d9c5b76695e10757d17af8444f5fc','447d9c5b76695e10757d17af8444f5fc','be4e2862c1b85f4c95656a0391c6e500','806ad3c1465d5112265f13a0f3fa9682','eaf6b0b4b6c8cfcb98df8ff50edad91f','a37f7f69707fb19a2a25816073e4f311','1d766ce6a393ca51c5db9c02a1784107','0738b2cc4152674e12553500f5953857','217fe28187e2dee3b982366c008ceea4','e885942c4c756018e29cccb54954ec27','e3f173bd00a2f58930cda423d3030cf2','65b99abcaff10423b7e8a9474cb0e33b','517e25f8cdc015f1bc10e42269282cd6','f91bc368a4e7282cd9fd480482ef5484','afbfc0995a8bdfc77b23b66464325e25','e406c515309c3cdc0c47943ae202b2ba','314e87e220869e656723792754353b6a','314e87e220869e656723792754353b6a','7feb6c6a07ab32579f359e2197006920','15929fbe16b6d73b715b9604dda9ba2c','15929fbe16b6d73b715b9604dda9ba2c','15929fbe16b6d73b715b9604dda9ba2c','f4ba120e7f03fe1738fccb6c4783cd07','4f213f7d5ebdefb9fc1cfb57afeac9f1','becc1d541fccb90e615d997ab3ac02dc','5447b1862f47425e7226ecb0c4be702b','da9d4cc0e5b7eee15e8040fa20fedf89','be100a1643411526672b17b7008dfeb8','04a710bd422a00c022c8a3e372046896','6e69485d8f63b29c2278d6e860d32dca','ffa213b9c5383d6f2d852bbe61fed5e6','1fe08686c6e151ec75ea94f878f384a6','1fe08686c6e151ec75ea94f878f384a6','d793f6b1bd0123c982a5b59d60b75f47','84fd9847e241dbb94b92b160a2915bec','9fa181f7db8c8cb3ba28d4b34f388c46','fff12e4e031604648d1d112e75d5577b','8d59adcf4867aaa9e1921c66e04f74d8','afbfc0995a8bdfc77b23b66464325e25','719352a79c2e22a487b6ae909b6be608','061127f408982029398a6972477c24e5','061127f408982029398a6972477c24e5','6de6e862f1fb2e1daa1f47cba3c7855c','07fb48accaf695514192345b0b43987d','9532b69000d433de4f40ea26ca764006','fc86f7c79a18652d88383704fd0f4c9f','18e5c85b4c3cf2a25629bfb040e8382c','6904da9b06598459068938ed349f1094','255ee10b6c39098b396cae24a1a46806','18e5c85b4c3cf2a25629bfb040e8382c','4dfe3d178220571f543f93917b9b4e32','18e5c85b4c3cf2a25629bfb040e8382c','becc1d541fccb90e615d997ab3ac02dc','fdc13855f830f2f03d36fe3f645e7a3e','ef1d8502709bfb2c2e08aa584ec42807','0e42e10aaa9249960d153b9bc25976f6','58a9689188964296eaaddf03bcb28dfd','2810af93a5b217bb2b65d54de3f0e5cf','58a9689188964296eaaddf03bcb28dfd','112978522dd0baf4f85b39a76a72ea99','70aebb3b0cc75c05e875502ca4032269','dff3c91eea87898b112d6b6fe931a6aa','827890d70a552fc27fccabe794cb327c','5e552ee91ea7591aaf70dfe66a1907c8') 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`
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(751) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `ov`.`option_value_id`

SELECT `filter_id`
FROM `oc_category_filter`
WHERE `category_id` = 751

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`
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(751) 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`
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(751) 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
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(751) ) 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
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(751) ) AS `tmp` ) AS `tmp`

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `query` = 'category_id=649' AND `language_id` = 4

SELECT *
FROM `oc_seo_url`
WHERE `query` = 'category_id=751' AND `language_id` = 4

SELECT *
FROM `oc_mfilter_url_alias`
WHERE `language_id` = 4 AND `store_id` = 0 AND ( `path` = '' OR `path` = 'cloth-uk-ua/dresses-and-sundresses-uk-ua' )

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

SELECT *
FROM `oc_seo_url` AS `ua`
WHERE `query` IN('category_id=649','category_id=751') AND `ua`.`language_id` = '4'

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

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

SELECT *
FROM oc_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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 14:38:28'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.51', `customer_id` = '0', `url` = 'https://eurocosmetics.com.ua/uk-ua/cloth-uk-ua/dresses-and-sundresses-uk-ua/page-3', `referer` = '', `date_added` = '2026-03-26 15:38:28'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

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

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

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

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

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

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

select *
from oc_seo_url
where store_id = 0 and CONCAT('category_id=', CAST(751 as CHAR)) = query and language_id = 3

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

select *
from oc_seo_url
where store_id = 0 and CONCAT('category_id=', CAST(751 as CHAR)) = query and language_id = 4

insert into oc_bots_report (link, bot, ip, `date`) values ('https://eurocosmetics.com.ua/uk-ua/cloth-uk-ua/dresses-and-sundresses-uk-ua','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)','216.73.216.51',now());

SELECT *
FROM oc_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'header_top'
ORDER BY sort_order

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

SELECT *
FROM oc_category_to_layout
WHERE category_id = '751' AND store_id = '0'

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

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'navigation'
ORDER BY sort_order

SELECT *
FROM oc_module
WHERE module_id = '34'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/header' 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 `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_translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/language' OR route = 'uk-ua')

SELECT *
FROM oc_seo_url
WHERE query = 'common/language/language' AND language_id = '4' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '4'

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

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

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

SELECT *
FROM oc_language;

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

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

SELECT *
FROM oc_seo_url
WHERE query = 'common/currency/currency' AND language_id = '4' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '4'

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

SELECT *
FROM oc_language;

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

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

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

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

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1731fc55a8a20309c26505265d'

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

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

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1731fc55a8a20309c26505265d'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1731fc55a8a20309c26505265d'

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

SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'

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

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1731fc55a8a20309c26505265d'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1731fc55a8a20309c26505265d'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1731fc55a8a20309c26505265d'

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 = 'common/cart'

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

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

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

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'