SELECT `data`
FROM `oc_session`
WHERE session_id = 'e8a2c602c6546214ecc8712126' AND expire > 1660051417

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 = 'b492ccdc6be2bbdb5a8c5a5a52' AND expire > 1660051417

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://naturecare.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 = 'dohlyad-za-tilom' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE keyword = 'zasoby-dlya-vanny-i-dushu' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE keyword = 'geli-dlya-dushu' 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 = '20' 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 = '65' 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 = '123' 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 = '123' 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 = '123'

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 = '123' GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC,p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,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 = '5862' 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 = '619' 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 = '5569' 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 = '5568' 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 = '787' 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 = '786' 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 = '769' 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 = '767' 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 = '615' 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 = '4756' 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 = '4805' 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 = '4789' 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 = '5862'
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 = '5862' 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 = '5862' 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` = 5862

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

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

SELECT ov.*, ovd.*
FROM `oc_product_options_combinations_option_values` pocov
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=575 AND ovd.language_id='4'
ORDER BY pocov.id ASC

SELECT pocov.option_id, pocov.option_value_id, pocov.value
FROM `oc_product_options_combinations_option_values` pocov
LEFT JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=575 AND (ovd.language_id IS NULL OR ovd.language_id='4')
ORDER BY pocov.id ASC

SELECT *
FROM `oc_option` o
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE o.option_id = '15' AND od.language_id = '4'

SELECT ov.*, ovd.*
FROM `oc_product_options_combinations_option_values` pocov
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=576 AND ovd.language_id='4'
ORDER BY pocov.id ASC

SELECT pocov.option_id, pocov.option_value_id, pocov.value
FROM `oc_product_options_combinations_option_values` pocov
LEFT JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=576 AND (ovd.language_id IS NULL OR ovd.language_id='4')
ORDER BY pocov.id ASC

SELECT *
FROM `oc_option` o
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE o.option_id = '15' AND od.language_id = '4'

SELECT ov.*, ovd.*
FROM `oc_product_options_combinations_option_values` pocov
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=577 AND ovd.language_id='4'
ORDER BY pocov.id ASC

SELECT pocov.option_id, pocov.option_value_id, pocov.value
FROM `oc_product_options_combinations_option_values` pocov
LEFT JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=577 AND (ovd.language_id IS NULL OR ovd.language_id='4')
ORDER BY pocov.id ASC

SELECT *
FROM `oc_option` o
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE o.option_id = '15' AND od.language_id = '4'

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 = '619' 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 = '5569'
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 = '5569' 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 = '5569' 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` = 5569

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

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

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

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

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

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

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

SELECT ov.*, ovd.*
FROM `oc_product_options_combinations_option_values` pocov
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=573 AND ovd.language_id='4'
ORDER BY pocov.id ASC

SELECT pocov.option_id, pocov.option_value_id, pocov.value
FROM `oc_product_options_combinations_option_values` pocov
LEFT JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
WHERE pocov.combination_id=573 AND (ovd.language_id IS NULL OR ovd.language_id='4')
ORDER BY pocov.id ASC

SELECT *
FROM `oc_option` o
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE o.option_id = '15' AND od.language_id = '4'

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 = '615' 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 = '4756'
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 = '4756' 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 = '4756' 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` = 4756

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4789' 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 = 4789 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 = '4789' 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 = '123' 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 = '123' 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 = '123'

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

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'attribute' AND `value` IN('5f2e71cf6159a21603b05acc75e876fa','c746996cfd604b42e7de019c01b2994e','09e617e6c2933e99c43791e0616016b6','09e617e6c2933e99c43791e0616016b6','9d48d39dd8a627061257aeff267633b4','aa54c91886ce80efb12f61e6ae12230b','aa54c91886ce80efb12f61e6ae12230b','9d48d39dd8a627061257aeff267633b4','aa54c91886ce80efb12f61e6ae12230b','f654b87d2d277ecc2416637dfd6c95e8','aa54c91886ce80efb12f61e6ae12230b','f654b87d2d277ecc2416637dfd6c95e8','cf945f058cf8836080d6c0eec498da41','d095261d7f5e7ef88917b676c5420345','dcfe2369455ffa35ae245b7258f50883','9d48d39dd8a627061257aeff267633b4','99e80ef5b4f6b21df61934c588e2837c','753b1faebc274b03d93ba0d6dc1962ad','6cf55418780cc954e263a5437084cfc3','18e9ee11e9231c956d0ef5804c22972a','43b74c1e1b66797b34cc1249492cb9b8','75fe17d0a80153d4e57862538f2e6fe2','2804bafea68f88c2bdecde544085d248','050b6b89f4f4e1f6965c49acaf9ce1d7','050b6b89f4f4e1f6965c49acaf9ce1d7','f654b87d2d277ecc2416637dfd6c95e8','050b6b89f4f4e1f6965c49acaf9ce1d7','d37e32de3c36aae47eaa7c9dba85d080','6438eb5dead63f4792944c429ffb99e8','d6f428d93e0155f21c673f18c97b0f77','4e60e49034ce8d46b834c98ddddfb436','a09100444761460e40b5b07d686aba37','a09100444761460e40b5b07d686aba37','18e9ee11e9231c956d0ef5804c22972a','a09100444761460e40b5b07d686aba37','d6f428d93e0155f21c673f18c97b0f77','f654b87d2d277ecc2416637dfd6c95e8','89eabd8e0a80a70b328648b12cb472cf','d37e32de3c36aae47eaa7c9dba85d080','5862152fbf131634e245f6e263a2b1b3','9d48d39dd8a627061257aeff267633b4','ab39265484eac64a0c451c4e340a613f','1d5254e1f5e84ff219701eceaf4cec4e','f5cd262901883dff68d06b215fb0f28e','ad64dd101919ff6018d94ec0fe313a26','77321d01136bffeac7c6c33bfac81730','6f8d88cad13c759ac5dd15ab42a6a57c','6c28c9d54347f399f996d7b094cd2ce0','e78120322e420e7f1cb2d50f0d99daa7','3f2248134ed910bcf17e8b91f7269bed','3f2248134ed910bcf17e8b91f7269bed','890083810e17d190c5fcbcc507aff5ec','717a3a498d5b15c3c76c5ed4841ef048','71a731effc43ac8bab7455c5e4ce9cc5','3f2248134ed910bcf17e8b91f7269bed','387fa7f2a8f22814a0e32b6a00540cbe','71a731effc43ac8bab7455c5e4ce9cc5','8ada2aaf87666bee33ee7e48f4111ad3','5f9474690c45c0d0aee6378608e7c805','e95bbaed1e07ecc83ee2b08121d27072','f8c891f66383c733ef89a7f2a3328a3a','8c9e51d43151d6722f5a8f716468cb4d','dabfc079d906013bd0f0cbaa46f4f4f1','90e6527f1c806820945540a168495f3d','540e009b42d0fe414b8036d3891fb510','2ddc460b9e21014c4326f4743df69154','fc8995951d884ae51abf67731355b78a','2da3c827ccabc4855cb9921b4f1addfa','ccbe9a185f7c5e937b01cbdd9e755729','81aa05d271c10b3a3646957e4d3219df','0195bf3b36f14cafe6a3f9ca3252e42a','90fdc93c8a6d98e8306b4027b124a6dc','34f3e3b72f2d22a8990e80605e123882','91efa9e46e4c6cbb78d9fd0a773cc6d5','6739210fc8d4ed300aa3eaa897e0b569','6739210fc8d4ed300aa3eaa897e0b569','725fccb5239074c3d722c5fae5188856','cefc4f7cbc8c34762e0f76703e7e174e','76b88e7899abb3bfdd4b55b8c52726b0','bffd6a869281928a1e1e0c8c79fa306a','b662b5725296bca0a5b8bc5480a08590','e177d102817f74297b6b5b53bac81caa','5b8611653f8d6902853b98cc8f0eb03e','8583cd257d19ef79828fe8f11dacc587','7850f57bca04fee8c72bb923837b5c1e','a6b73d7072bc04d5736831dd278748e4','b9aec1199207e8f99ee1e8cdf348e0aa','0c6b7c9cf8c07c2a29c15cc4f44fffd4','50e362c3198de02293be78472d013af4','7c1e9a80f50c2d3f419dd087e4d19d73','8fa726af3ba7a903391de9411d56277f','d49843b2e1fca82dcfef9fa70c2d86bd','76e1ca97cb509cb8d69de150e96458a6','f28d42b6e3c5b336b5113e833ed73a55','4c80bfeca3747ff258c7622662827c77','f06b52122cc0cd0bf106f239fc4e581b','4ba284dcacf33403de17628772f5aad8','387fa7f2a8f22814a0e32b6a00540cbe','387fa7f2a8f22814a0e32b6a00540cbe','71a731effc43ac8bab7455c5e4ce9cc5','e95444134783e2d310ad485b9f08cf8f','b53a8fe1c28fff0d4062c5b21795fad3','9efcecbe0fb1598e9368843c6cabcfcc','29a1026c5266c4bbe21a1fcf7fab51b5','b494883b5747f241ac2ed3747f3a31ec','ed6b48dab752e736b0df8b0c89e64f85','e57c3a85aec304f9e5291cd9604a331d','754227d9a15d3e6b02655559325f868a','635c399b4d8c4af7c344385c5ad7635d','ac02868d98b7e3aa80e548df163f40c1','d5ecba92634a8a325f7925d75ad307ca','089602aa18f0f675e87a2d6c3fb46629','b65552b215b32acf5b41dd5f8cc5cfd0','3a0c9846cf173c4443555aa83f1d6289','d30973809f2e4238b7eb2bac9241674c','89d6368756ba755f81d214591f94a2f8','c588cad2d2ea5dfda489c6ff415b6afc','624f8ef92fc27027f110e02b76c30606','3124f571f0802397662b27f83c3b5d02','0c28a309ac2df1ed30baeb1e9e3bb02c','71a731effc43ac8bab7455c5e4ce9cc5','b0458c954f1c3b75e7f0a8ab5e3f9bb6','0c6c93747300b837c6dad72975246f11','ef6572e4cd58bb39a3f4e82fc64fe9f0','4936559013eb7df26a72dd37d1e33fb5','5eb835d2254c0281bca2550cbb10a34c','c4cef4cbb910c02d3838c6374d21e5c2','18cedb337ea347cf3a7e4ee9969312d2','97eeab177c5cccda3d3ca3443ff1a303','2e513e9e17a6bd9748bd1396469323c2','1611e5f3da8f7101c9bfcaf803555b32','9a4d22e24307f7affe323423c3450d0a','71a731effc43ac8bab7455c5e4ce9cc5','24c473b4cc4177eac7723dcea1539033','0a5d466836e2eab8de99c74e17994c8e','70d52a4b4eff30f260db2baa35a66bea','83dafb1abbae96bb1ce859bea4d928d8','8ccfa51fc9b3e4017ecc60c826637c86','abd10d97ece68d1d0717d6818ef7dd2f','7916ac11c7ada5290ae99a499aaf7282','2397d9889dc31c402adb60161274ab1f','0399d38d85db1a002b94f0173c01d1ba','45fd9d5fe3ef2d5c7482a0a2db10f4c1','77697ae621ac10c8d9e9dbd0ca2448a9','4f1aeec160cd547359c1401e5728f47b','4f1aeec160cd547359c1401e5728f47b','4f1aeec160cd547359c1401e5728f47b','634c3d6c60712bf83aa54b11ff6787d1','4f1aeec160cd547359c1401e5728f47b','1b3efdbadd0d5f8854a33e520904e0d7','c43545890646f3c89e4e100a32cc1629','c43545890646f3c89e4e100a32cc1629','70f793e7d829bf3206fa832ec8700a02','661a781a2f737f7e05e687fc33de4306','ad8c9dba384d1f4844c7f6a4c349daab','ad8c9dba384d1f4844c7f6a4c349daab','1b0392e9030b4bf09eaddc2b423c7a93','f71a3899c310db920144abdb6a6e7bf5','da9e6b2d96198a25f805493a43c8e3c4','da9e6b2d96198a25f805493a43c8e3c4','443a8b6fd54825ce1428b5e197675d08','443a8b6fd54825ce1428b5e197675d08','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ee560f8efe90324f20c8dff874ca8218','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','9f27bef0b7ca1b5b422fc851730ebd74','690794ba3b47176ef21bf079ea9d2d62','6191b9545b2c5a29b894f31408e94276','99ff130d5801cfb29612a15fc7af622c','60c45fd404d20cf44ff82c1671f9ff1d','8df93ce358233423edcf0b616d3e64c2','f64bf294636045c134f458dc1bc04d7e','b7482f165e25a5da2555f61d4897655b','dc4a437129afaeeb3226cba2e2cbbf0a','26ae37ad8a7106962aa24e39c241b962','e7133f4f26cb37254d390888ce3289be','a75b8448699db99a8b365d9fad69c801','7f8d2cf65bca8a9550c43d648f859cdc','920ad8ec11e72888eb481df5560860ee','f8db4810a22e853ed148a1dd7b73d94a','b1e432818bfd4257f59303908c2123d4','505bdfa7410ea5aa052ab46cdfdcba7a','b03a1d8cf630858680bf2a13e3053a6b','b03a1d8cf630858680bf2a13e3053a6b','0399d38d85db1a002b94f0173c01d1ba','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','85dfe46abadc6881a8c157459af10e29','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','d5e5b38ec8320d629f67fd689f5d4b36','3498a8565c1f7b91321c9716c48b6918','5b21bf7ad5714cb5bebf0a25d2eddc4a','b03a1d8cf630858680bf2a13e3053a6b','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','0399d38d85db1a002b94f0173c01d1ba','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','505bdfa7410ea5aa052ab46cdfdcba7a','b03a1d8cf630858680bf2a13e3053a6b','30d393a768ca06fdcf229637854d6149','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','2c011d64b1d1836f7dd0b3a6d51f624f','b03a1d8cf630858680bf2a13e3053a6b','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','ee560f8efe90324f20c8dff874ca8218','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','ee560f8efe90324f20c8dff874ca8218','443a8b6fd54825ce1428b5e197675d08','70f793e7d829bf3206fa832ec8700a02','58ca23c40d774ddf79d9e6bb75fd0a95','26293625754338c570e44eebbb466155','26293625754338c570e44eebbb466155','661a781a2f737f7e05e687fc33de4306','392189e53eb7f04ebe1ee95343d9c942','fee736b8a265fbab3c38cb0748bb0d3e','0198f6751d0414f5275f24f83db79834','afb7b5c194eb356855d5251a7b367e45','dff6653adc2c6b48036b471499bc219a','d872df2c5c5baa7eff8c2fca9a0f92ec','7f59bdc0f1ecff56877f26cbc10cb48c','817c03343da60ad6b73db7b7201a81fe','66e5c0235d849bf18632b8bd4e92b0ab','286c411f05593c6cf8bfe7a0a25104bb','c2a9b6b3fe50dac9226d924bb75312fa','6aa2ec6b0c6be46d235e024b1ab36441','634c3d6c60712bf83aa54b11ff6787d1','634c3d6c60712bf83aa54b11ff6787d1','1b3efdbadd0d5f8854a33e520904e0d7','b7e7dfa0bf43a058752addd1eb1e1f47','ee560f8efe90324f20c8dff874ca8218','0807431ee82f8e5df188778507da63e0','04490493392a913695515278d62b0162','2b1ff5a2befc1f1c899d57b158142319','5ccac931fcf0d164ea6ec9a0b112413a','3e1e1bc7793041be9246939cd98f241d','b8824a341a9a18525e6a7e0b0f8789d4','f94993cc5907a508ffc138f3d99f6ef8','1b3efdbadd0d5f8854a33e520904e0d7','3920e60eff6f3475ccec801ca9163328') 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(123) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `ov`.`option_value_id`

SELECT `o`.`option_id`, `ov`.`option_value_id`, `od`.`name` AS `gname`, `od`.`mf_tooltip` AS `tooltip`, `ov`.`image`, `ovd`.`name`
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_value_description` AS `ovd` ON `ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 4
INNER JOIN `oc_option` AS `o` ON `o`.`option_id` = `pov`.`option_id`
INNER JOIN `oc_option_description` AS `od` ON `od`.`option_id` = `o`.`option_id` AND `od`.`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 `ov`.`option_value_id` IN(57,61) AND `p2c`.`category_id` IN(123) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `o`.`option_id`, `ov`.`option_value_id`
ORDER BY `ov`.`sort_order`, `ovd`.`name`

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'option' AND `value_id` IN(61,57) AND ( `language_id` IS NULL OR `language_id` = 4 )

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

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(123) 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(123) 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=75','manufacturer_id=66','manufacturer_id=108','manufacturer_id=89','manufacturer_id=114','manufacturer_id=100','manufacturer_id=118','manufacturer_id=102','manufacturer_id=97','manufacturer_id=77','manufacturer_id=103','manufacturer_id=74','manufacturer_id=84','manufacturer_id=105','manufacturer_id=71','manufacturer_id=113','manufacturer_id=104','manufacturer_id=107','manufacturer_id=90','manufacturer_id=92','manufacturer_id=72','manufacturer_id=35','manufacturer_id=85','manufacturer_id=95','manufacturer_id=70','manufacturer_id=119','manufacturer_id=81','manufacturer_id=37','manufacturer_id=38','manufacturer_id=39','manufacturer_id=40','manufacturer_id=44','manufacturer_id=43','manufacturer_id=47','manufacturer_id=48','manufacturer_id=50','manufacturer_id=51','manufacturer_id=52','manufacturer_id=53','manufacturer_id=54','manufacturer_id=56','manufacturer_id=62') 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(123) ) 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(123) ) 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=20' AND `language_id` = 4

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

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

SELECT *
FROM `oc_mfilter_url_alias`
WHERE `language_id` = 4 AND `store_id` = 0 AND ( `path` = '' OR `path` = 'dohlyad-za-tilom/zasoby-dlya-vanny-i-dushu/geli-dlya-dushu' )

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

SELECT *
FROM `oc_seo_url` AS `ua`
WHERE `query` IN('category_id=20','category_id=65','category_id=123') 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 = '123' 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 = '123' 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 = '123' 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 < '2022-08-09 12:23:37'

REPLACE INTO `oc_customer_online` SET `ip` = '34.236.192.4', `customer_id` = '0', `url` = 'https://naturecare.com.ua/uk-ua/dohlyad-za-tilom/zasoby-dlya-vanny-i-dushu/geli-dlya-dushu', `referer` = '', `date_added` = '2022-08-09 13:23:37'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '123' 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'