SELECT `data`
FROM `oc_session`
WHERE session_id = '457537423b1e663863972b898a' AND expire > 1774527030

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 = '6a5172c28d2dd249a3f65ba295' AND expire > 1774527030

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

SELECT *
FROM oc_seo_url
WHERE keyword = 'jumpers-sweaters-and-cardigans' AND store_id = '0'

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

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

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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '649' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '698' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '698' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '698'

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 = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '698' GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC,p.sort_order ASC, LCASE(pd.name) ASC LIMIT 48,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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1823' AND pd.language_id = '3' 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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1802' AND pd.language_id = '3' 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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1833' AND pd.language_id = '3' 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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1795' AND pd.language_id = '3' 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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1819' AND pd.language_id = '3' 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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1824' AND pd.language_id = '3' 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 = '1823'
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 = '1823' AND od.language_id = '3'
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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1823' AND pd.language_id = '3' 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 = '3' AND (route = 'extension/module/notifywhenavailable' OR route = 'ru-ru')

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

SELECT *
FROM oc_product_discount
WHERE product_id = '1823' 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 = 1823 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 = '1823' AND ovd.language_id='3' AND od.language_id='3' 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 = '1802'
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 = '1802' AND od.language_id = '3'
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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1802' AND pd.language_id = '3' 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 = '3' AND (route = 'extension/module/notifywhenavailable' OR route = 'ru-ru')

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

SELECT *
FROM oc_product_discount
WHERE product_id = '1802' 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 = 1802 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 = '1802' AND ovd.language_id='3' AND od.language_id='3' 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 = '1833'
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 = '1833' AND od.language_id = '3'
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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1833' AND pd.language_id = '3' 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 = '3' AND (route = 'extension/module/notifywhenavailable' OR route = 'ru-ru')

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

SELECT *
FROM oc_product_discount
WHERE product_id = '1833' 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 = 1833 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 = '1833' AND ovd.language_id='3' AND od.language_id='3' 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 = '1795'
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 = '1795' AND od.language_id = '3'
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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1795' AND pd.language_id = '3' 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 = '3' AND (route = 'extension/module/notifywhenavailable' OR route = 'ru-ru')

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

SELECT *
FROM oc_product_discount
WHERE product_id = '1795' 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 = 1795 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 = '1795' AND ovd.language_id='3' AND od.language_id='3' 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 = '1819'
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 = '1819' AND od.language_id = '3'
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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1819' AND pd.language_id = '3' 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 = '3' AND (route = 'extension/module/notifywhenavailable' OR route = 'ru-ru')

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

SELECT *
FROM oc_product_discount
WHERE product_id = '1819' 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 = 1819 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 = '1819' AND ovd.language_id='3' AND od.language_id='3' 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 = '1824'
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 = '1824' AND od.language_id = '3'
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 = '3') 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 = '3') 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 = '3') 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 = '3')
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 = '1824' AND pd.language_id = '3' 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 = '3' AND (route = 'extension/module/notifywhenavailable' OR route = 'ru-ru')

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

SELECT *
FROM oc_product_discount
WHERE product_id = '1824' 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 = 1824 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 = '1824' AND ovd.language_id='3' AND od.language_id='3' 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 = '698' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '698' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'

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

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

SELECT filter_id
FROM oc_category_filter
WHERE category_id = '698'

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` = 3
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` = 3
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` = 3
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(698) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != ''
ORDER BY `txt`

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'attribute' AND `value` IN('8449701d46fbc79593133e6513a9cb3e','20f0679c518b9cc35cea4c7fed35d7ec','9cbbc7cfe336ac7d691b7b5f676c55d5','6e066c094f55b46b6a2a0389cd327597','6e066c094f55b46b6a2a0389cd327597','fd1c66d4e524cea1cd89f0f0fe86a5f9','37a80265d0abd4e0168a1e0644a4cc63','47eaefc596e4a3ef2f0d76c31aeb36bd','a5c0196f8f3d45099ad77ea4d4690b8a','ab895ac914c886ae4eb5707da97ee11a','17ebe2dc178113b2c4b7e50a7a7ddd3f','81e1c2626df3ff4f5faefc596e754506','81e1c2626df3ff4f5faefc596e754506','656113effea3e087324f0c280aeceb68','b00ca03265f009de47967747cb491187','13be55d80ee9cd7151a4a6daaeaba801','dd3a19bfed798642cf0742cc845c403b','1f5f930bb0c5364b2a9aa2ed2b810cce','630232bdbe853795db0c6f886bfc1717','6df476202071833608a04644df0b5caa','336447b32eea2babc787e1f1da5e2829','9b0cab2e388a2d73011b9f06ca158ada','8b183abde6a9265d07b285a6f98f1dd2','d646e8faac0211ba516be1b399c4b48f','11b13b1df19db0ac8a68ee371a553069','bc7c9530cec09993e7865fce384e522e','a42bee261a926a5108e331a94a31d402','8e9351d0040a6804784f940f57d5d5e2','c2a0863b59898f8a3a9f3f3ca8429c1f','f2d3ef6dcd84e6c621847a816f461ddf','b5547a2086bda3b2c8628990ff40ce4c','9308d10dfbb4e7e40dbff5a4894d77a8','630232bdbe853795db0c6f886bfc1717','6514f194be55a6933456c47d6b81e86b','64200dadecd60e194eb980e53f5cac03','d613bdeb5bb8af382cbfc7e8def1ef34','a3ca7ed5733f0ac482ebaf084ff45b99','2f8b71925d379d718f1e193b70921fc1','5ca66ab86faced4e802b8c0dc0ebd961','29b41753427ee09c86a680b749bac66d','b4eaaa206b25b69fe89456d4112181ca','9b0cab2e388a2d73011b9f06ca158ada','6514f194be55a6933456c47d6b81e86b','6e87b92c9dec1d7a52db06245863958d','970602104b07d59f1b83d7c5af0e1987','06891d725b9ac1e36f9a42681335be2a','3e71f1631e3f08722106bea5ebcf6100','a410a7dc1155a279c4368156c42254c1','1241af847cca4bd3d334029e799069c7','8c8fda1d462fa9691765a8d83512eb00','6749a27bd002b8875fd8f002f8566ba1','278470221d488af98bcb2a4eb321cf92','4fa50811b86fd3ae1f01811b00e2264f','18319bc20780b916f2c817a554fe12f0','3b08a3d52aa704f0614d4789c9c3316d','98f1824968a9b36c957546d6833da864','2d52d111791a765f2e06f1adc05ceac0','e51ba64babe9813e7eae90be59063cf3','2f3da0d02aa6ee7a6e396f0c22f88da7','f21e97546628b046ab57304a7a91fed8','b7717063c72851311e718a26660920a0','82b9a869d261b267148d825fb95b6227','309af512970fd9d1653cc5aefe465814','b9a71369546ec22a39c0cb09aa0da5b6','f9e22308c8ba64482733755f9ced45d9','9e3c39706a934937a8c4e8ed92181686','b2b97038b5bb9452b8c27c4a88086f62','e6177eaeb31b1e8ba02b74f662e7b575','d9b223588dae41fbed8ff3f37196a9ac','06ebb0f948d7a83d2a425d4bef9a743b','2d3846d79f6237e5218f3c652f6fab78','e6177eaeb31b1e8ba02b74f662e7b575','11a4ae5b9de8d25d36a75623619a322f','bb9be3f5596a835919cfb4e4a7230914','2d3846d79f6237e5218f3c652f6fab78','e6177eaeb31b1e8ba02b74f662e7b575','11a4ae5b9de8d25d36a75623619a322f','06ebb0f948d7a83d2a425d4bef9a743b','2d3846d79f6237e5218f3c652f6fab78','e6177eaeb31b1e8ba02b74f662e7b575','06ebb0f948d7a83d2a425d4bef9a743b','11a4ae5b9de8d25d36a75623619a322f','2d3846d79f6237e5218f3c652f6fab78','e6177eaeb31b1e8ba02b74f662e7b575','b698d129b4c324f1f78129246ad2d691','e6177eaeb31b1e8ba02b74f662e7b575','b698d129b4c324f1f78129246ad2d691','e51ba64babe9813e7eae90be59063cf3','64200dadecd60e194eb980e53f5cac03','fb4a2b2360039f89464284a3baeda35d','b698d129b4c324f1f78129246ad2d691','e6177eaeb31b1e8ba02b74f662e7b575','b698d129b4c324f1f78129246ad2d691','e6177eaeb31b1e8ba02b74f662e7b575','c695c5c2887520f21ae5ab46c02b1488','0b2238c99fd6f3ce6054775644d18af6','566eab59430f773784a6b9d4f514eaf0','21e8000132b098c297fc8c86ead49b6b','c695c5c2887520f21ae5ab46c02b1488','0b2238c99fd6f3ce6054775644d18af6','1316655a61e5a2530848a27924869561','21e8000132b098c297fc8c86ead49b6b','aebd6463de5614806f08677a10254a52','5d578e399dea60871805d86ff3a7fe89','c68c3b629ce7785b9882022cc7103a42','6749a27bd002b8875fd8f002f8566ba1','c695c5c2887520f21ae5ab46c02b1488','ef2352ea977f910a46d8968322445e13','976a0f628553d6ae5e72d52c56033c42','21e8000132b098c297fc8c86ead49b6b','c695c5c2887520f21ae5ab46c02b1488','976a0f628553d6ae5e72d52c56033c42','0b2238c99fd6f3ce6054775644d18af6','21e8000132b098c297fc8c86ead49b6b','c695c5c2887520f21ae5ab46c02b1488','b6fef58896b9364907a5c40a04ffd484','c695c5c2887520f21ae5ab46c02b1488','b6fef58896b9364907a5c40a04ffd484','9e3c39706a934937a8c4e8ed92181686','2f8b71925d379d718f1e193b70921fc1','00f18b56ab81d554a54cc8d58c57b043','b6fef58896b9364907a5c40a04ffd484','c695c5c2887520f21ae5ab46c02b1488','b6fef58896b9364907a5c40a04ffd484','c695c5c2887520f21ae5ab46c02b1488','791f777f89ba923c319943e23a3b8437','ad701a16dbc5ded271a55ede5efcb6ad','7fbbef1c673b3168c55d94bbec09b9ad','1d779c5a599a37ca1950875f23cb23f2','abc933ba141f59a94bd4b94482217d33','2d91a7931352659123f4acb9f1f62078','a0620f1095629bc14fee88d8a55e3497','f156942f8ff865842c18dec2a8978608','e3a217642b29acd534e55ddde3549b09','630232bdbe853795db0c6f886bfc1717','cd3bc6b0ab5ab23d8341045193865f2f','ff8af85a1fda3fcc8818c06589a59952','ee378d2b7d163908ebc89da58f01c940','9b0cab2e388a2d73011b9f06ca158ada','923771be2d512bcc1005b03e3c404984','5cd2bb0a8ec36eabc505d379d85aa820','267d6f32158ecd7eaa84c0cc1d9921fa','2b6adc8de4f92bb665fd77ce103b4555','8cbb8624871b64ad761ad70fbfbfe923','8d1a1753166672c13760e6cb1712776d','8cbb8624871b64ad761ad70fbfbfe923','8d1a1753166672c13760e6cb1712776d','2dc055538202dfadadc41a64ef0867e8','ad701a16dbc5ded271a55ede5efcb6ad','4a4460023225313833ca73ce4ba3b9a2','0aefa628333bf676370d0a1578fcdee6','96dd5599aa43b4540fdb9ba00ce1d0de','92207bee9e143cde63240b362bdf5205','158bea98c399163f114a346795a20c12','abc933ba141f59a94bd4b94482217d33','6664dd6b76c3bdd9de16ffc63d0426d6','5c3e71dd67cb16207dc1851b6d9a2d2a','4c4feade280612d8b4d8fcd3c900c217','4c1822afd9b060a111c7980abd20c48b','efe98f6f3e0534ad7c7fc60249b007dc','13e7839bb1d1c980c43ad352ee986395','13c278e7c65fad1ce558d03f81d3ef07','c3428d8d440576d39f16cdd0600ed465','cdd0c770324a07c4e541c9adaa90d72c','4333cbcb1efd658a4dade142472fd552','920809ad6f3521061418a1ee2f8837b8','6b06e632160dd5621ab0a127f19e1734','920809ad6f3521061418a1ee2f8837b8','11c69b2a8ff1502a44e350ace6f172e4','920809ad6f3521061418a1ee2f8837b8','11c69b2a8ff1502a44e350ace6f172e4','cd5597c2fd8eecced26e89d98488988b','fc96f369596c1210dde2d5679255024d','f6937723663d9c11f1ee4edf9f935fa8','f939386dc28ffba38c1cbeea6160e20c','1cde2b6688e439f668de93d29a08a61e','5265d2cad59a266e5eebf7091e15f0af','2bd8c63b2fe3e8e3b4f933b6130f49e6','e5599a753af06fad0655047399e038c2','1cde2b6688e439f668de93d29a08a61e','e90dfb84e30edf611e326eeb04d680de','53da039b3c3767b994b976be1fee7724','e90dfb84e30edf611e326eeb04d680de','9594eec95be70e7b1710f730fdda33d9','9594eec95be70e7b1710f730fdda33d9','f73d1a2b14a28743a70bb496d866a116','a6f0077b898dc8d408c08168a2c44259','ed63fc91500594c3086714f86b3001e4','216d652dce0b1fbf6ea441422de84373','83217adedb82bd0593742ddc89ad1480','eb5cbe60df6c0a495b4ff3a7b44adbe3','eb5cbe60df6c0a495b4ff3a7b44adbe3','1cde2b6688e439f668de93d29a08a61e','555c55f781866ad4f17f82fd7152ec14','e808734e75e15ca813fa9684cbfa935b','e808734e75e15ca813fa9684cbfa935b','b31c0a656da7451e246d2d220f50a986','db547a9a5b84991c24ec850ac0749c0b','f6937723663d9c11f1ee4edf9f935fa8','80dcdf1bc72378443fdbda512cb91a13','80dcdf1bc72378443fdbda512cb91a13','1cde2b6688e439f668de93d29a08a61e','aa2396143c08a68c272f01d9756c767c','5e20451f7be4e72bd222cf67ec7e9ba1','431af4ad56a5031fb552d40c32fd8251','431af4ad56a5031fb552d40c32fd8251','7c1a41653ed6da23d8ee5539ced34096','431af4ad56a5031fb552d40c32fd8251','55b5907ceaf5266247df8d047835ac89','1cde2b6688e439f668de93d29a08a61e','e62775cd7cf3a785ae9af641cb3c6252','6084badbe00ac6bdbe621baf284d02d8','6084badbe00ac6bdbe621baf284d02d8','6c26a60562ea280b323bccb9587e7bef','aac36bad397a7a9bead6f04c09599e1e','c022eda4db844b0170b1cc475a425aca','2addeaa19ff75ba19cc05b95f820c84b','5285e5552018232c4cb3f3da343b41ce','bacb99956178a0b2e07a170c09d4d54c','13a950712141c5d265ba1409ebe1615d','b31ac3ed8720aa10bf281a32134664af','994ae1d9731cebe455aff211bcb25b93','994ae1d9731cebe455aff211bcb25b93','2bd8c63b2fe3e8e3b4f933b6130f49e6','994ae1d9731cebe455aff211bcb25b93','909cea0c97058cfe2e3ea8d675cb08e1','d382816a3cbeed082c9e216e7392eed1','b851f799b66921c0548e1350e9562df7','0b782c1529f2f13db27c842d5c6651b2','52d937387439f07a16845abab545b150','1007e1b7f894dfbf72a0eaa80f3bc57e','1007e1b7f894dfbf72a0eaa80f3bc57e','115760a39a28c071cb1ca3f16ba08d01','115760a39a28c071cb1ca3f16ba08d01','159fd886c1c9c0bbeb5deeb70bf3fabd','30b7d7913825a76c055807079f491a46','1cde2b6688e439f668de93d29a08a61e','4e0da454761202071787120430ad6d1f','4e0da454761202071787120430ad6d1f','56b903949445076a918fa89b29b3a255','2f11bced07af78b88fe03a5894e86382','dc1d6dcc73da126e5d1eeba31e60c5e7','dc1d6dcc73da126e5d1eeba31e60c5e7','bc3ac883eb839e0ff01123fabe744d35','2f11bced07af78b88fe03a5894e86382','1cde2b6688e439f668de93d29a08a61e','2f11bced07af78b88fe03a5894e86382','1cde2b6688e439f668de93d29a08a61e','2f11bced07af78b88fe03a5894e86382','f9606d10d761f00880775f1474adb1e1','8c2857a9ad1d8f31659e35e904e20fa6','925f91d22174b775747bd49ab565dfa8','925f91d22174b775747bd49ab565dfa8','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','1cde2b6688e439f668de93d29a08a61e','5a0c134223045ecdd483e574103c34d5','1cde2b6688e439f668de93d29a08a61e','948b17188fd5ec53cc1e3314f92cbe52','1cde2b6688e439f668de93d29a08a61e','e2f9bedacfebdc32f7ba1e80f9b8d69b','1cde2b6688e439f668de93d29a08a61e','e2f9bedacfebdc32f7ba1e80f9b8d69b','1cde2b6688e439f668de93d29a08a61e','638a023d48bf728daa9be7fb61e10ee2','1cde2b6688e439f668de93d29a08a61e','9a6aed68b81ed7a094cbab795fd0ce7f','1cde2b6688e439f668de93d29a08a61e','9a6aed68b81ed7a094cbab795fd0ce7f','1cde2b6688e439f668de93d29a08a61e','c5c1160aeb264daeb63ae5d048194827','1cde2b6688e439f668de93d29a08a61e','884fb78f16d50ae7c860237be9b54276','8c2857a9ad1d8f31659e35e904e20fa6','42efe43ac3bb235a3a819062de72c562','19ede5a51f2f3d148d5904ae5adfde67','916cf7c80dad54a2eb7a1863267dd977','916cf7c80dad54a2eb7a1863267dd977','8dc5344bc0746e1cc5abf896ca03bbdf','b9ba865fec061c9706d2fd7ce49c0cc7','ee38e4d5dd68c4e440825018d549cb47','1352e623626102cf79e335639eed7cf7','d2203cb1237cb6460cbad94564e39345','c2cea8a95cf684677acb5822c9f64c64','1cde2b6688e439f668de93d29a08a61e','e2f9bedacfebdc32f7ba1e80f9b8d69b','b9cbb458ed8067427c618e702c748f3d','e2f9bedacfebdc32f7ba1e80f9b8d69b','33894a4dc73e8e1836cc4da8d6757449','c2130e8678ac75efb71931aa4a29385f','33894a4dc73e8e1836cc4da8d6757449','c2130e8678ac75efb71931aa4a29385f','efdedaf75a1b1a408673f5d029462b19','d33157c2d628a84edea15a223d6a5c46','05057bd393c2ff7213601abfe8ddc741','05057bd393c2ff7213601abfe8ddc741','06a96feabf0cfa31a05b6f1fbae28a41','a2a3a0347f0f001a4473dd54dca2462e','377147323b0c0a87d83fbe83d8138205','f17a7181ef587f0dc7625594ccf0e370','b599c29e5195888a86aa4cb932ee0d0a','dc07af4471578d5288210631a211e197','dc07af4471578d5288210631a211e197','dc07af4471578d5288210631a211e197','a95ed8ccc437ffbd9cdea31f85bb9846','eed7ab157c9bd8209678889bbd1432ab','1380eb8c2ee48815a55ef2f9d51e0c74','1cde2b6688e439f668de93d29a08a61e','73325952ef5af7cb99a92334d7b0e54b','810eb69ef10d7fb69fca47463477addf','6e25cbca4a5cc0319e7d2fcdd960746d','6e25cbca4a5cc0319e7d2fcdd960746d','9a2e5ea3ec12231a2fbe6f8c75139e01','279d70a8ca94a69951b9951eaeacc4d9','ac30d403e3e330f3551b3214c1e8105b','ed45849fcf7f3bbdc626496b0f930367','9a2e5ea3ec12231a2fbe6f8c75139e01','1cde2b6688e439f668de93d29a08a61e','50f22187e71a5b4de3189149d98a1518','50f22187e71a5b4de3189149d98a1518','50f22187e71a5b4de3189149d98a1518','50f22187e71a5b4de3189149d98a1518','afbfc0995a8bdfc77b23b66464325e25','805e03ee7db28893bb412679ee49a6b9','805e03ee7db28893bb412679ee49a6b9','6b06e632160dd5621ab0a127f19e1734','1ab67d54125e7b2bd931c766113c49df','b3de5045d4f335597ac9a23fd225e3e7','8c10c8909d0ef500b08ed0001b3cab21','ca247e19286092d0b408dbc064a97fcb','5355dbc5d740bdbf21da8ca446f485bb','31bbad10486feb6a0873a66c738d1064','27a457bbd50ecc15b7ee570e58034034','433d06ef8bee1cc16fac1ebb4b8f8036','27a457bbd50ecc15b7ee570e58034034','66569dc44af3bbf6ef864f96566b9bda','27a457bbd50ecc15b7ee570e58034034','66569dc44af3bbf6ef864f96566b9bda','676df0085ef56e036b9d774eac0300a0','254c3bc5ca4b412a40692b0b348a9114','0738b2cc4152674e12553500f5953857','ffca9ff4b790805e38e41773c9850c55','883d9efdb975b04427e81df1acb92f36','883d9efdb975b04427e81df1acb92f36','883d9efdb975b04427e81df1acb92f36','01ea2c674f86d42a6e685c5985b0b896','0046f5c91b3b559d1a51565d12729621','86f1d73dda28ae3227ab5e2d11b43187','0c9f914a070dae678c221deafdc3e5bd','c884f1a329c6a121fd31191f41f88f29','afbfc0995a8bdfc77b23b66464325e25','7e7d32339ca4f304d505e8f1bca6dc41','7e7d32339ca4f304d505e8f1bca6dc41','1fcf2dea370d3ed3465f89e00161d984','334679dabe8c2f37d761e46998bd7c61','a24c83845d127591bc8a4bd86d0adccb','853e9924ecfbbf0980dc28482945db05','d711a390f9dd2597b938a8e760318214','7ef0bf02f477f060b09f9d27a4355e26','2dcbdaa0a6557ff7606fa595f16538aa','7ef0bf02f477f060b09f9d27a4355e26','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','afbfc0995a8bdfc77b23b66464325e25','1838dbbed856e6f85ccc2de6e7f77189','afbfc0995a8bdfc77b23b66464325e25','2dcbdaa0a6557ff7606fa595f16538aa','afbfc0995a8bdfc77b23b66464325e25','6f6caa623318aaa49b754b39b082f1b9','afbfc0995a8bdfc77b23b66464325e25','0f4564a41e56498d0151c71368efe3df','afbfc0995a8bdfc77b23b66464325e25','cf73329ce825079c354c7a08f395ef53','afbfc0995a8bdfc77b23b66464325e25','9a25d80bd7b7152c0d97097f640e0ab4','afbfc0995a8bdfc77b23b66464325e25','2527f25884273fb2f53c29442c65bad6','afbfc0995a8bdfc77b23b66464325e25','b6280807d926500afa35b98f2bd9c959','afbfc0995a8bdfc77b23b66464325e25','c2a6a5e39c5b59c4f47f8ee8b2138fe5','b77f1cf5c9fbf40c57444b3258c290bf','c62b398ef5e5a59200553e5c75af9c13','fedb05def86758de5d4b1cc5e13335e3','d2be962c4a93e895db63b2450b44b43f','afbfc0995a8bdfc77b23b66464325e25','ee6e98c09b286f204a891878e0f7b3c4','1df65fd74f35f632e667687e312a6c21','1df65fd74f35f632e667687e312a6c21','afbfc0995a8bdfc77b23b66464325e25','df077592ca482b300a8469c074fb6076','e7be71e3ac6717dd6f13d1475b4b8f15','65769bfb9cb2d08a2418eaff10e201f4','65769bfb9cb2d08a2418eaff10e201f4','cfbec3b7f6f840bdb388d277a5727772','f0d4646b49c0ab7a241f7d67d8995e83','6e305f55a76cc85c9b378208a5bbd127','74b1955df98e6c6bb013657612cd4ce8','2a58f99bded717f3225d19266993c1fb','cf6f150bf26e613601e247dd462dfb4c','185823939d1bebc3946ef363dcff3f75','6adc374b80ec8ec20cfba940f7a0c34e','f5a1965e525978021034798f6c0e81c1','4dfe3d178220571f543f93917b9b4e32','35b13f96d7b539166eed404ea11ce103','6ac88e7bbb1c7c6a265f45403098adfa','715dcc85398edea2cf9a0910c4a343dd','715dcc85398edea2cf9a0910c4a343dd','afbfc0995a8bdfc77b23b66464325e25','6ac88e7bbb1c7c6a265f45403098adfa','05422e3618b3c26feb0d2d183e8ad205','afbfc0995a8bdfc77b23b66464325e25','35823278e330d652c298380464260b30','7be2872a7d49c42b2e089a83b1c53d7b','6ce51b8353fbae6119ef48ef3331a3c0','3dd04b1f13ce4bf8399178eacceda6a1','3dd04b1f13ce4bf8399178eacceda6a1','7be2872a7d49c42b2e089a83b1c53d7b','50f22187e71a5b4de3189149d98a1518','7be2872a7d49c42b2e089a83b1c53d7b','afbfc0995a8bdfc77b23b66464325e25','7be2872a7d49c42b2e089a83b1c53d7b','afbfc0995a8bdfc77b23b66464325e25','70e3be6ae863d8dc8996463ef746b247','8c9f8fe617c7b8d1c8931d29650953b6','158176991f43d5bdf6c52b258bf05cf4','158176991f43d5bdf6c52b258bf05cf4','d5e179e49d237df65c7423130723eb24','1c2c7866a44a4b001cb4fd498e868f70','778f5a2c3e53a27bd7a1e7fd815929bb','cdd5994f1b66c8091af258515e76fc71','fb08dedf82d9299b54cda20230a7aeb3','1a7dd5bb0f92af567874e488be9973f3','0760493c7cfd1804c41ac1d16fb8b6c4','107f1b9fa2f6460beea66b53d0194fa2','f91bc368a4e7282cd9fd480482ef5484','357822b4573a65558c0f8804ab156568','f91bc368a4e7282cd9fd480482ef5484','afbfc0995a8bdfc77b23b66464325e25','59ac33d5045693366d719c9be4e00723','8ee227a26c428a0587ab6c03b9c9d419','8ee227a26c428a0587ab6c03b9c9d419','52aa5fb86dca459cad4910bf613188dc','1d611719cfb51e68bf0535b1dc8eee5d','8d5d0e8d633fd44fa9011101ca5fbb31','afbfc0995a8bdfc77b23b66464325e25','a4b82222f3960f06a57fe3aabae1b85c','4bd61396ea76714547ea690144746112','6b6e4e0f083867b0728fd1308f03a7ac','329795ed7541062e33be2c936aff337a','12affe75a3dd4dbabd7e40ac4f02529e','4e85d5fc05103d2d089909dc05c9c615','5305eab3703707699d72732f48fbe459','9328ada3e77c565a5b1eee305b067072','15929fbe16b6d73b715b9604dda9ba2c','becc1d541fccb90e615d997ab3ac02dc','becc1d541fccb90e615d997ab3ac02dc','ffca9ff4b790805e38e41773c9850c55','becc1d541fccb90e615d997ab3ac02dc','ec485895b881b2dc9472bcc78940d27c','9da60c180c26d8369fa331f5f9cd7ec6','5447b1862f47425e7226ecb0c4be702b','5b44ff45f2634fa7867f4b3af4a0caa7','f10f87655a712eec7c3f9bd12a0ae26c','eaef4cff5d7e438bc324e9e489a95c5a','464643a1ebb209a2aeda3741262ffff6','c6119d008ba60d8119e777256ee516af','2d1734af204de8a6cef3b3863ff066da','2c2132ab70c6b4fb5419890a12b9c0a2','0cb399fa7d707fb28695fb8eb985b2a8','0cb399fa7d707fb28695fb8eb985b2a8','0cb399fa7d707fb28695fb8eb985b2a8','04a710bd422a00c022c8a3e372046896','e11055cf2ac02dd496bcc6bf0e9fe2f9','88454279e41e7886aa42421b71a124e7','0738b2cc4152674e12553500f5953857','18e5c85b4c3cf2a25629bfb040e8382c','674c0ca118ad49cdfaeaa712bebc318f','18e5c85b4c3cf2a25629bfb040e8382c','5447b1862f47425e7226ecb0c4be702b','58a9689188964296eaaddf03bcb28dfd','49f73e26dad5c9df03218146e4c0540b','723883c6a052343fcac8473afe148879','4d9e7cecdc2a013130cefd57eab45441','433d06ef8bee1cc16fac1ebb4b8f8036','db97b11af68e66a72b705ed8230a8544','2810af93a5b217bb2b65d54de3f0e5cf') AND ( `language_id` IS NULL OR `language_id` = 3 )

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(698) 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` = 698

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(698) 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(698) 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` = '3'

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` = 3
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(698) ) 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` = 3
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(698) ) AS `tmp` ) AS `tmp`

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `query` = 'category_id=698' AND `language_id` = 3

SELECT *
FROM `oc_mfilter_url_alias`
WHERE `language_id` = 3 AND `store_id` = 0 AND ( `path` = '' OR `path` = 'cloth/jumpers-sweaters-and-cardigans' )

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

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

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 = '698' 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 = '698' 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 = '698' 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 = '3' AND (route = 'common/footer' OR route = 'ru-ru')

SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_description_seo ids ON (i.information_id = ids.information_id AND ids.language_id = '3')
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '3' 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 = '3' AND store_id = '0'

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

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 = '3' AND store_id = '0'

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

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 11:10:31'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.51', `customer_id` = '0', `url` = 'https://eurocosmetics.com.ua/cloth/jumpers-sweaters-and-cardigans/page-5', `referer` = '', `date_added` = '2026-03-26 12:10:31'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '698' 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 = '3' AND (route = 'extension/module/jetimpex_newsletter' OR route = 'ru-ru')

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

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

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 = '3' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'ru-ru')

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

SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_description_seo ids ON (i.information_id = ids.information_id AND ids.language_id = '3')
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '3' 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 = '3' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'ru-ru')

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

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 = '3' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'ru-ru')

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

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 = '3' AND store_id = '0'

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

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 = '3' AND (route = 'extension/module/jetimpex_footer_links' OR route = 'ru-ru')

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

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 = '698' 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 = '698' 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 = '698' 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(698 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(698 as CHAR)) = query and language_id = 4

insert into oc_bots_report (link, bot, ip, `date`) values ('https://eurocosmetics.com.ua/cloth/jumpers-sweaters-and-cardigans','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 = '698' 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 = '698' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '649' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '751' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '698' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '649' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '649' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '787' AND cd.language_id = '3' 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 = '3' AND (route = 'common/header' OR route = 'ru-ru')

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 = '3' AND (route = 'common/language' OR route = 'ru-ru')

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

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

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 = '3' AND (route = 'common/currency' OR route = 'ru-ru')

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

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

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 = '3' AND (route = 'common/search' OR route = 'ru-ru')

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 = '3' AND (route = 'common/cart' OR route = 'ru-ru')

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6a5172c28d2dd249a3f65ba295'

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

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

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6a5172c28d2dd249a3f65ba295'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6a5172c28d2dd249a3f65ba295'

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

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

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

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6a5172c28d2dd249a3f65ba295'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6a5172c28d2dd249a3f65ba295'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6a5172c28d2dd249a3f65ba295'

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 = '3' AND (route = 'common/menu' OR route = 'ru-ru')

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '3' 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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '649' AND cd.language_id = '3' 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'

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 = '3')
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '787' AND cd.language_id = '3' 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_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'common/menu'

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

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

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'jetimpex' AND route = 'product/category'

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