SELECT `data`
FROM `oc_session`
WHERE session_id = 'b5ab29373a66e7bcd258e75f4e' AND expire > 1660053336

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 = '080483c588965a333790287692' AND expire > 1660053336

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

SELECT *
FROM oc_seo_url
WHERE keyword = 'kremy-dlya-oblychchya' 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 = '18' 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 = '40' 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 = '40' 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 = '40'

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 = '40' 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 = '775' 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 = '774' 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 = '1563' 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 = '6132' 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 = '6133' 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 = '6134' 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 = '6135' 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 = '1898' 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 = '246' 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 = '952' 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 = '953' 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 = '955' 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 = '775'
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 = '775' 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 = '775' 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` = 775

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'attribute' AND `value` IN('99255903e9f71877448c14733e0bdd9b','6a438cc8d7adcb7f18e4e8eb55fb8fea','a09100444761460e40b5b07d686aba37','99255903e9f71877448c14733e0bdd9b','6a438cc8d7adcb7f18e4e8eb55fb8fea','a09100444761460e40b5b07d686aba37','99255903e9f71877448c14733e0bdd9b','75fe17d0a80153d4e57862538f2e6fe2','a09100444761460e40b5b07d686aba37','99255903e9f71877448c14733e0bdd9b','fe5b2187cd84211f244dfe5afd52a56d','99255903e9f71877448c14733e0bdd9b','a09100444761460e40b5b07d686aba37','5f2e71cf6159a21603b05acc75e876fa','9bf31c7ff062936a96d3c8bd1f8f2ff3','b1a11e87dd98d4c46751004ec38c49d8','09e617e6c2933e99c43791e0616016b6','55b3c28663fc11e08426a015f8375f0f','98f13708210194c475687be6106a3b84','6a438cc8d7adcb7f18e4e8eb55fb8fea','6a438cc8d7adcb7f18e4e8eb55fb8fea','a09100444761460e40b5b07d686aba37','9d29913ab41a1dd2d6e5bc1e777030bd','aa54c91886ce80efb12f61e6ae12230b','dcfe2369455ffa35ae245b7258f50883','7a0ba6b8f4ac2a82e823d64f16403212','a09100444761460e40b5b07d686aba37','c77ccc21397d66cd4e968049ce830c8c','9d48d39dd8a627061257aeff267633b4','9d50566d65b814b5995606dcbc46bcba','43b74c1e1b66797b34cc1249492cb9b8','75fe17d0a80153d4e57862538f2e6fe2','75fe17d0a80153d4e57862538f2e6fe2','a09100444761460e40b5b07d686aba37','8cc4da701d01ea55a52b51a131e8c2c1','26c915396e38cc7e11b84d3810494c71','6438eb5dead63f4792944c429ffb99e8','fe5b2187cd84211f244dfe5afd52a56d','fe5b2187cd84211f244dfe5afd52a56d','a09100444761460e40b5b07d686aba37','8ba8030185cfc1ad01b3d986d25150c0','a09100444761460e40b5b07d686aba37','94293736257bb16f3310275e70540a52','5b8551de6f055c171438d7cfee62063d','5862152fbf131634e245f6e263a2b1b3','ca9faa5d67e997dc53174e7a109dae02','3824f9b461f9deda63b73073fd49a11c','1877a4b3681f1361ab9b3aa6b9edabed','ad64dd101919ff6018d94ec0fe313a26','0373121d6367957cd317b356d9ff6e85','d9ba89654f786fa825370ec6196b6cd8','d9ba89654f786fa825370ec6196b6cd8','90bbed46f58ce8b5afab112d1483b7fb','165b79274461cdf084dc18c17391f4fb','3d1066b0bd71eb42c99169341c89710f','fccb46ff3a1885b6b7daa3faa05a7770','6f8d88cad13c759ac5dd15ab42a6a57c','07ecf837ece1f7e069b23d5414d72278','6dd89b9b1339817de020271b2c8f2105','3f2248134ed910bcf17e8b91f7269bed','890083810e17d190c5fcbcc507aff5ec','717a3a498d5b15c3c76c5ed4841ef048','71a731effc43ac8bab7455c5e4ce9cc5','3f2248134ed910bcf17e8b91f7269bed','387fa7f2a8f22814a0e32b6a00540cbe','71a731effc43ac8bab7455c5e4ce9cc5','8ada2aaf87666bee33ee7e48f4111ad3','f7c5ce248e5a7b1a6a14165157a41f96','5f9474690c45c0d0aee6378608e7c805','75503ed94172a03c5b3040cf0f9d497b','e95bbaed1e07ecc83ee2b08121d27072','1296a8f9df3d115cbb5ec392fcba8b03','67268c0d3f4acfa8d82a00e0f1d1f497','5d85616beb58a486657e36abf827761d','d05e619f96b22ed416a40b2cfd9527f9','5efb463428af2b0f470cdc3074e7d373','dabfc079d906013bd0f0cbaa46f4f4f1','21994d6177b29e1128b2d7f0f8342057','90e6527f1c806820945540a168495f3d','20b7c1a82d059eab19d6f63ba807103c','2da3c827ccabc4855cb9921b4f1addfa','5e57252979c8c5ceebcd9c2fd914ed2a','a730c1fb08f531f9fdfc9b45d2adaec5','52f8fdbd407c3a2bede31e1e9a8e6f4b','a1d1554c047a709d281d0a663642a947','90fdc93c8a6d98e8306b4027b124a6dc','2eb16c7388f13207fa979bb085a54a2a','6739210fc8d4ed300aa3eaa897e0b569','6739210fc8d4ed300aa3eaa897e0b569','725fccb5239074c3d722c5fae5188856','8adc053702e1db844c7cc50f0a5318fa','24e996719315d6b101ce7b219ebf5c08','cefc4f7cbc8c34762e0f76703e7e174e','b662b5725296bca0a5b8bc5480a08590','7c120866231a3c7cd6d5bc1f688f6d08','8583cd257d19ef79828fe8f11dacc587','04c9c2bbbcadefaa44d452d9fd4ab163','1c9e0af6cc2fc9895e3313750b2a5e85','fc822a67f4d33cba0083021c174cb054','4ee63158fb199792fe8ce7888c84e001','d1042ffc3d6154c44b3eac2240e1a116','7c1e9a80f50c2d3f419dd087e4d19d73','63e1d37f84f34c7a35dcc75723a88d66','bc723fb2c080a160fc97c622efa2ff83','8fa726af3ba7a903391de9411d56277f','9d24b039732a6bac7e5ca3439f8b695b','a1b65a4658985368f83391b9eef7393d','836ffc2501aa7e6d4c976c431bc01d39','4c80bfeca3747ff258c7622662827c77','387fa7f2a8f22814a0e32b6a00540cbe','e95444134783e2d310ad485b9f08cf8f','d9da7c31a6dd0ede928688957b7764ca','cda0e8e257c49dc2f9c427b6bf46ad15','29a1026c5266c4bbe21a1fcf7fab51b5','75a7c8ee9051f1c2a0e161a5a5d77641','754227d9a15d3e6b02655559325f868a','a353c16e3c85f429421a1287c507462c','eb2aad2105e3d99c6ff7f7af0518faf8','9384e06ab4a13e865b32b3ce27bdddce','4b1bee32965feb6bf8bbe39d4c6898d9','7531a41e7ae6f350c51468812f518b5e','cca4103c18c46504269fba6bc6d769d7','d30973809f2e4238b7eb2bac9241674c','1897545dae0a6f37b8483af8e2b92b45','0a94f427af6eadb763985e3b9d9f0d62','0ca14bdb338d530d12df5dc8540f67ec','d76c8faf63439a379177fffa37f97357','1eb9dab77e9b76316d224425b40cbd7f','f4bac1fe9f56b8914108500b9201dd0e','26636c743cfadbf720cfc66222468198','ef6572e4cd58bb39a3f4e82fc64fe9f0','076353708a5a2900c8023314202f6932','18cedb337ea347cf3a7e4ee9969312d2','b32a2353f76ed14647d13f17fda05709','91af4f03380a9b847717e1be86a75eb2','6d0d94c68efd4745e29dc869c3f1fc33','71a731effc43ac8bab7455c5e4ce9cc5','70d52a4b4eff30f260db2baa35a66bea','ae1611cdea906c87a4f4d5bfde32b3ec','3d4cf982bb7ee45513ac44db90d74d5c','71a487a325b53e63906c9e6ee23fce0d','4cb32640f876720e3cc01d690604bdb3','25a81701fbfa4a1efdf660a950c1d006','b2262ae79ece716b6167070311dc1870','1573c185b2e142c58e1b7e0f83b5a4e9','8ccfa51fc9b3e4017ecc60c826637c86','abd10d97ece68d1d0717d6818ef7dd2f','7916ac11c7ada5290ae99a499aaf7282','2397d9889dc31c402adb60161274ab1f','59a42e09b774ac4f6a1ef159541910bd','dca5c4b9c4a687d5ff14df27c18514cb','c7848ff94e4f0fd0f06a479efc9e7d16','a88de814a812a5ea4745fd2574aacffc','85bcc25218fec7d868107f15c88ba23d','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','443a8b6fd54825ce1428b5e197675d08','c49ac14af150881290877fd46e069100','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','ac2211805c704eff095dfb4f4eec8181','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','0545239a5b1faa3a00ce98b2676bc614','ee560f8efe90324f20c8dff874ca8218','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','85bcc25218fec7d868107f15c88ba23d','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','da9e6b2d96198a25f805493a43c8e3c4','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','85bcc25218fec7d868107f15c88ba23d','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','f93846ac7f5308dd28a4d66c8a5021e7','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','96dbe03e823f89f042d31a1a19b575fb','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','a63a83ab3099d08a6c3a6849ea75f354','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','c49ac14af150881290877fd46e069100','ac2211805c704eff095dfb4f4eec8181','85bcc25218fec7d868107f15c88ba23d','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','ac2211805c704eff095dfb4f4eec8181','da9e6b2d96198a25f805493a43c8e3c4','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','c49ac14af150881290877fd46e069100','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','60954a9f31c30ec0a8c3bee6fc5cd882','ac2211805c704eff095dfb4f4eec8181','da9e6b2d96198a25f805493a43c8e3c4','a88de814a812a5ea4745fd2574aacffc','4d5d6512c8ed93705645bf543e1c00ca','85bcc25218fec7d868107f15c88ba23d','a88de814a812a5ea4745fd2574aacffc','4d5d6512c8ed93705645bf543e1c00ca','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','4d5d6512c8ed93705645bf543e1c00ca','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','a88de814a812a5ea4745fd2574aacffc','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','da9e6b2d96198a25f805493a43c8e3c4','a88de814a812a5ea4745fd2574aacffc','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','a88de814a812a5ea4745fd2574aacffc','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','85bcc25218fec7d868107f15c88ba23d','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','f93846ac7f5308dd28a4d66c8a5021e7','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','da9e6b2d96198a25f805493a43c8e3c4','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','85bcc25218fec7d868107f15c88ba23d','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','60954a9f31c30ec0a8c3bee6fc5cd882','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','2c011d64b1d1836f7dd0b3a6d51f624f','a88de814a812a5ea4745fd2574aacffc','443a8b6fd54825ce1428b5e197675d08','a63a83ab3099d08a6c3a6849ea75f354','da9e6b2d96198a25f805493a43c8e3c4','a88de814a812a5ea4745fd2574aacffc','a63a83ab3099d08a6c3a6849ea75f354','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','85bcc25218fec7d868107f15c88ba23d','a63a83ab3099d08a6c3a6849ea75f354','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','a63a83ab3099d08a6c3a6849ea75f354','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','4c2d2aa1eec145ed1c5720aedb439f30','a88de814a812a5ea4745fd2574aacffc','c49ac14af150881290877fd46e069100','ac2211805c704eff095dfb4f4eec8181','a88de814a812a5ea4745fd2574aacffc','507c923e5b81b4c8bdce479bbfe52fe5','a88de814a812a5ea4745fd2574aacffc','ac2211805c704eff095dfb4f4eec8181','85bcc25218fec7d868107f15c88ba23d','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','ac2211805c704eff095dfb4f4eec8181','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','ac2211805c704eff095dfb4f4eec8181','443a8b6fd54825ce1428b5e197675d08','a88de814a812a5ea4745fd2574aacffc','ac2211805c704eff095dfb4f4eec8181','443a8b6fd54825ce1428b5e197675d08','2c011d64b1d1836f7dd0b3a6d51f624f','a88de814a812a5ea4745fd2574aacffc','ac2211805c704eff095dfb4f4eec8181','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a88de814a812a5ea4745fd2574aacffc','ac2211805c704eff095dfb4f4eec8181','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','98ff8205de9378b99543cafb127a61ef','a80f2fe8dab857900282f9fb30913159','2ff7a0802059cb06f4f1c08257b818fa','c76ba3264d12f7161531ac2f4119952d','7154c24afa1055694b52a493b6e45010','77e0ff75ee0155f92180e79ba5c4f86e','2c011d64b1d1836f7dd0b3a6d51f624f','7154c24afa1055694b52a493b6e45010','443a8b6fd54825ce1428b5e197675d08','85bcc25218fec7d868107f15c88ba23d','ac2211805c704eff095dfb4f4eec8181','b7b4ee10ff17df4bf5a4dfc03114e991','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','f93846ac7f5308dd28a4d66c8a5021e7','f93846ac7f5308dd28a4d66c8a5021e7','443a8b6fd54825ce1428b5e197675d08','0545239a5b1faa3a00ce98b2676bc614','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','0545239a5b1faa3a00ce98b2676bc614','c01fdd8a06d16cc9ca0d889f76e89ff4','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ee560f8efe90324f20c8dff874ca8218','0545239a5b1faa3a00ce98b2676bc614','c01fdd8a06d16cc9ca0d889f76e89ff4','ee560f8efe90324f20c8dff874ca8218','0545239a5b1faa3a00ce98b2676bc614','4d5d6512c8ed93705645bf543e1c00ca','0545239a5b1faa3a00ce98b2676bc614','443a8b6fd54825ce1428b5e197675d08','0545239a5b1faa3a00ce98b2676bc614','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','0545239a5b1faa3a00ce98b2676bc614','c49ac14af150881290877fd46e069100','0545239a5b1faa3a00ce98b2676bc614','c49ac14af150881290877fd46e069100','4d5d6512c8ed93705645bf543e1c00ca','0545239a5b1faa3a00ce98b2676bc614','ac2211805c704eff095dfb4f4eec8181','0545239a5b1faa3a00ce98b2676bc614','ac2211805c704eff095dfb4f4eec8181','ee560f8efe90324f20c8dff874ca8218','60954a9f31c30ec0a8c3bee6fc5cd882','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','96dbe03e823f89f042d31a1a19b575fb','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','ad72c0eb44caf17aba3a7e8c59c24842','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','7154c24afa1055694b52a493b6e45010','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','da9e6b2d96198a25f805493a43c8e3c4','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','a63a83ab3099d08a6c3a6849ea75f354','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','96dbe03e823f89f042d31a1a19b575fb','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','ac2211805c704eff095dfb4f4eec8181','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','ac2211805c704eff095dfb4f4eec8181','443a8b6fd54825ce1428b5e197675d08','2c011d64b1d1836f7dd0b3a6d51f624f','60954a9f31c30ec0a8c3bee6fc5cd882','ee560f8efe90324f20c8dff874ca8218','443a8b6fd54825ce1428b5e197675d08','151a50cd0dabcc1dca83c107f4e229fb','77697ae621ac10c8d9e9dbd0ca2448a9','1e48e8dc6dd25f9ec10da2653c96898f','325392f7e060727e98f4ac6a6a31ede1','4f1aeec160cd547359c1401e5728f47b','4f1aeec160cd547359c1401e5728f47b','ad8c9dba384d1f4844c7f6a4c349daab','1b0392e9030b4bf09eaddc2b423c7a93','4f1aeec160cd547359c1401e5728f47b','920ad8ec11e72888eb481df5560860ee','4e52c7efc69eaea1f1431a8a0457ee19','4f1aeec160cd547359c1401e5728f47b','1b0392e9030b4bf09eaddc2b423c7a93','4f1aeec160cd547359c1401e5728f47b','634c3d6c60712bf83aa54b11ff6787d1','4f1aeec160cd547359c1401e5728f47b','1b3efdbadd0d5f8854a33e520904e0d7','749f45dd9f1b6a17b8b201a7d8af4606','cffedf657bcbdb7f21e8daf2674146d9','cb3669604d263fb05e5d7a7e3b665354','d22deff28ef89b7f728c3c1490404f17','7f0c703b4fcfdee8397c52eca60443a8','b4d2b752a959831fa9dd7e47c2bfc8be','c8168bacfcf5cf120e5e89c08b0474e0','e4a1c26afd2bf7c48d3778bbcd314216','661a781a2f737f7e05e687fc33de4306','4d5d6512c8ed93705645bf543e1c00ca','856bb0b0ec63664ce57315d3340ca681','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','6d3ef39cd233a750b3e429b670df8e06','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','4c2d2aa1eec145ed1c5720aedb439f30','4d5d6512c8ed93705645bf543e1c00ca','2c011d64b1d1836f7dd0b3a6d51f624f','4d5d6512c8ed93705645bf543e1c00ca','2c011d64b1d1836f7dd0b3a6d51f624f','ac2211805c704eff095dfb4f4eec8181','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','83562caf59c341be070542af207f4872','ad8c9dba384d1f4844c7f6a4c349daab','ad8c9dba384d1f4844c7f6a4c349daab','4e52c7efc69eaea1f1431a8a0457ee19','ad8c9dba384d1f4844c7f6a4c349daab','4e52c7efc69eaea1f1431a8a0457ee19','1b0392e9030b4bf09eaddc2b423c7a93','ad8c9dba384d1f4844c7f6a4c349daab','1b0392e9030b4bf09eaddc2b423c7a93','ad8c9dba384d1f4844c7f6a4c349daab','1b3efdbadd0d5f8854a33e520904e0d7','77e0ff75ee0155f92180e79ba5c4f86e','77e0ff75ee0155f92180e79ba5c4f86e','7154c24afa1055694b52a493b6e45010','77e0ff75ee0155f92180e79ba5c4f86e','f93846ac7f5308dd28a4d66c8a5021e7','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','6d3ef39cd233a750b3e429b670df8e06','2c011d64b1d1836f7dd0b3a6d51f624f','96dbe03e823f89f042d31a1a19b575fb','96dbe03e823f89f042d31a1a19b575fb','4d5d6512c8ed93705645bf543e1c00ca','96dbe03e823f89f042d31a1a19b575fb','4d5d6512c8ed93705645bf543e1c00ca','02127d29c5f7afd448716b4dc43e4d68','96dbe03e823f89f042d31a1a19b575fb','443a8b6fd54825ce1428b5e197675d08','ac2211805c704eff095dfb4f4eec8181','443a8b6fd54825ce1428b5e197675d08','443a8b6fd54825ce1428b5e197675d08','ad72c0eb44caf17aba3a7e8c59c24842','443a8b6fd54825ce1428b5e197675d08','7154c24afa1055694b52a493b6e45010','443a8b6fd54825ce1428b5e197675d08','f93846ac7f5308dd28a4d66c8a5021e7','443a8b6fd54825ce1428b5e197675d08','02127d29c5f7afd448716b4dc43e4d68','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','83562caf59c341be070542af207f4872','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','85bcc25218fec7d868107f15c88ba23d','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','da9e6b2d96198a25f805493a43c8e3c4','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','77e0ff75ee0155f92180e79ba5c4f86e','96dbe03e823f89f042d31a1a19b575fb','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','da9e6b2d96198a25f805493a43c8e3c4','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','4c2d2aa1eec145ed1c5720aedb439f30','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ee560f8efe90324f20c8dff874ca8218','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','02127d29c5f7afd448716b4dc43e4d68','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','60954a9f31c30ec0a8c3bee6fc5cd882','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','96dbe03e823f89f042d31a1a19b575fb','443a8b6fd54825ce1428b5e197675d08','96dbe03e823f89f042d31a1a19b575fb','443a8b6fd54825ce1428b5e197675d08','da9e6b2d96198a25f805493a43c8e3c4','443a8b6fd54825ce1428b5e197675d08','96dbe03e823f89f042d31a1a19b575fb','ac2211805c704eff095dfb4f4eec8181','443a8b6fd54825ce1428b5e197675d08','a63a83ab3099d08a6c3a6849ea75f354','443a8b6fd54825ce1428b5e197675d08','a63a83ab3099d08a6c3a6849ea75f354','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','4c2d2aa1eec145ed1c5720aedb439f30','443a8b6fd54825ce1428b5e197675d08','4c2d2aa1eec145ed1c5720aedb439f30','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','96dbe03e823f89f042d31a1a19b575fb','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','ad72c0eb44caf17aba3a7e8c59c24842','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','2c011d64b1d1836f7dd0b3a6d51f624f','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','ac2211805c704eff095dfb4f4eec8181','9f27bef0b7ca1b5b422fc851730ebd74','53370e1a64f0793c07d51e24ff1f7d5f','a63a83ab3099d08a6c3a6849ea75f354','bf2eb6e9990fc079112e69ebb2f458e1','da4a2f98c61987281a07bdf049fbb1b2','7c50d2a8741d787bb645fab973458c71','4e52c7efc69eaea1f1431a8a0457ee19','932ed92b8a7f6885675fae2deede1932','60c45fd404d20cf44ff82c1671f9ff1d','6dae911e6f07cbf4d9c7f7a6be519a46','724afc741877e373c149a9b2bbfa5159','f7e7fb7ded59e5d66607617ed1da371f','7702b4986ae798b84a51b94de6a1d60f','e13b329ba4a96af790f0a164e6371320','9fa1d7048ba98eafcf9ec8b1f5539dda','9fa1d7048ba98eafcf9ec8b1f5539dda','b5af1d957f319d15146ad05e3110c182','3a2c2403e3a492a0657598f85ea5c9e0','bf6003e35fff0597eea3bddfb977bda4','505bdfa7410ea5aa052ab46cdfdcba7a','443a8b6fd54825ce1428b5e197675d08','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','c49ac14af150881290877fd46e069100','443a8b6fd54825ce1428b5e197675d08','ac2211805c704eff095dfb4f4eec8181','f64bf294636045c134f458dc1bc04d7e','4a463aa97edb8b0ba0f2f99b180faee0','4c2d2aa1eec145ed1c5720aedb439f30','4c2d2aa1eec145ed1c5720aedb439f30','443a8b6fd54825ce1428b5e197675d08','4c2d2aa1eec145ed1c5720aedb439f30','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','4c2d2aa1eec145ed1c5720aedb439f30','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','4c2d2aa1eec145ed1c5720aedb439f30','3c2a35f4c52e80868c1bc66775cc7f47','a75b8448699db99a8b365d9fad69c801','a23efde51f52e67f5621c2d294fa18c7','bba1060311b4e926296d748cf8c5ef45','1e161d4eef236dfd01599ce6eee1ede1','920ad8ec11e72888eb481df5560860ee','920ad8ec11e72888eb481df5560860ee','ad8c9dba384d1f4844c7f6a4c349daab','920ad8ec11e72888eb481df5560860ee','ad8c9dba384d1f4844c7f6a4c349daab','4e52c7efc69eaea1f1431a8a0457ee19','920ad8ec11e72888eb481df5560860ee','ad8c9dba384d1f4844c7f6a4c349daab','1b0392e9030b4bf09eaddc2b423c7a93','920ad8ec11e72888eb481df5560860ee','4e52c7efc69eaea1f1431a8a0457ee19','920ad8ec11e72888eb481df5560860ee','4e52c7efc69eaea1f1431a8a0457ee19','ad8c9dba384d1f4844c7f6a4c349daab','920ad8ec11e72888eb481df5560860ee','4e52c7efc69eaea1f1431a8a0457ee19','1b3efdbadd0d5f8854a33e520904e0d7','920ad8ec11e72888eb481df5560860ee','634c3d6c60712bf83aa54b11ff6787d1','920ad8ec11e72888eb481df5560860ee','634c3d6c60712bf83aa54b11ff6787d1','1b3efdbadd0d5f8854a33e520904e0d7','920ad8ec11e72888eb481df5560860ee','634c3d6c60712bf83aa54b11ff6787d1','1b3efdbadd0d5f8854a33e520904e0d7','df02d35ca276a9ec55236115ad18c7fd','597658cecd3444210ab7f9b4aecc3c1c','505bdfa7410ea5aa052ab46cdfdcba7a','60954a9f31c30ec0a8c3bee6fc5cd882','505bdfa7410ea5aa052ab46cdfdcba7a','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','505bdfa7410ea5aa052ab46cdfdcba7a','c49ac14af150881290877fd46e069100','505bdfa7410ea5aa052ab46cdfdcba7a','ac2211805c704eff095dfb4f4eec8181','c49ac14af150881290877fd46e069100','507c923e5b81b4c8bdce479bbfe52fe5','f93846ac7f5308dd28a4d66c8a5021e7','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','507c923e5b81b4c8bdce479bbfe52fe5','f93846ac7f5308dd28a4d66c8a5021e7','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','118bfbb35fb89c6684726dde21832643','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','ee560f8efe90324f20c8dff874ca8218','413d17d79c4b3ec280abeb752b5dcc20','6d3ef39cd233a750b3e429b670df8e06','6d3ef39cd233a750b3e429b670df8e06','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','2c011d64b1d1836f7dd0b3a6d51f624f','1b0392e9030b4bf09eaddc2b423c7a93','f27fa78e2aec3d62ab2f4a77981e1d18','44004fc00f2d514c9702885fda3f3b50','2c011d64b1d1836f7dd0b3a6d51f624f','51a61c822d3bb15adeb7076b2dbbdf78','26293625754338c570e44eebbb466155','96aa0337739631d9108e533c0432f264','c2a9b6b3fe50dac9226d924bb75312fa','634c3d6c60712bf83aa54b11ff6787d1','634c3d6c60712bf83aa54b11ff6787d1','bf2eb6e9990fc079112e69ebb2f458e1','634c3d6c60712bf83aa54b11ff6787d1','1b3efdbadd0d5f8854a33e520904e0d7','634c3d6c60712bf83aa54b11ff6787d1','1b3efdbadd0d5f8854a33e520904e0d7','df02d35ca276a9ec55236115ad18c7fd','b7e7dfa0bf43a058752addd1eb1e1f47','4bdf2266d2d934e09e44dc8e213841ce','ee560f8efe90324f20c8dff874ca8218','ee560f8efe90324f20c8dff874ca8218','443a8b6fd54825ce1428b5e197675d08','9232d279bdaa717b77314cc6f857db2a','443a8b6fd54825ce1428b5e197675d08','b9b9a6d24bc2b69bca247fbc32180dd9','04490493392a913695515278d62b0162','2b1ff5a2befc1f1c899d57b158142319','815f0899ae5487a4870bf84184f23723','eb80aa9c5ba7b6422f904d96a13b6323','3e1e1bc7793041be9246939cd98f241d','ed1439d0f08481e902bf87ef6e5300c3','1b3efdbadd0d5f8854a33e520904e0d7','c4e94613694c7dadccf8e8a3df89af34','8fcdc792678d0eefb834d6554e637199') 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(40) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `ov`.`option_value_id`

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

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(40) 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(40) 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=66','manufacturer_id=108','manufacturer_id=100','manufacturer_id=82','manufacturer_id=97','manufacturer_id=77','manufacturer_id=76','manufacturer_id=105','manufacturer_id=71','manufacturer_id=104','manufacturer_id=107','manufacturer_id=90','manufacturer_id=72','manufacturer_id=99','manufacturer_id=35','manufacturer_id=85','manufacturer_id=64','manufacturer_id=95','manufacturer_id=70','manufacturer_id=81','manufacturer_id=37','manufacturer_id=38','manufacturer_id=39','manufacturer_id=40','manufacturer_id=44','manufacturer_id=43','manufacturer_id=46','manufacturer_id=47','manufacturer_id=48','manufacturer_id=50','manufacturer_id=52','manufacturer_id=53','manufacturer_id=54','manufacturer_id=56','manufacturer_id=57','manufacturer_id=58','manufacturer_id=61') 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(40) ) 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(40) ) 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=18' AND `language_id` = 4

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

SELECT *
FROM `oc_mfilter_url_alias`
WHERE `language_id` = 4 AND `store_id` = 0 AND ( `path` = '' OR `path` = 'dohlyad-za-oblychchyam/kremy-dlya-oblychchya' )

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

SELECT *
FROM `oc_seo_url` AS `ua`
WHERE `query` IN('category_id=18','category_id=40') 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 = '40' 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 = '40' 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 = '40' 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:55:36'

REPLACE INTO `oc_customer_online` SET `ip` = '34.236.192.4', `customer_id` = '0', `url` = 'https://naturecare.com.ua/uk-ua/dohlyad-za-oblychchyam/kremy-dlya-oblychchya', `referer` = '', `date_added` = '2022-08-09 13:55:36'

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '49'

SELECT *
FROM oc_module
WHERE module_id = '48'

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

SELECT *
FROM oc_module
WHERE module_id = '45'

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '40'

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '42'

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

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

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '43'

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '44'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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