SELECT `data`
FROM `oc_session`
WHERE session_id = 'b415b32bea8e38876f00e244a2' AND expire > 1656307629

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 = '4fe280522135854793fb87bf22' AND expire > 1656307629

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

SELECT *
FROM oc_seo_url
WHERE keyword = 'telo' AND store_id = '0'

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `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 COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '51'

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '51' 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 = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4078' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4081' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4655' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4079' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4083' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4084' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1566' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5070' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4296' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4297' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5008' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4080' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4078' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4078' 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 = 4078 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 = '4078' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4081' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

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

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

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

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

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

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

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

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 = '4081' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4655' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4655' 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 = 4655 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 = '4655' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4079' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4079' 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 = 4079 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 = '4079' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4083' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4083' 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 = 4083 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 = '4083' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4084' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4084' 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 = 4084 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 = '4084' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1566' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '1566' 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 = 1566 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 = '1566' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5070' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '5070' 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 = 5070 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 = '5070' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4296' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4296' 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 = 4296 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 = '4296' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4297' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4297' 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 = 4297 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 = '4297' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5008' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '5008' 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 = 5008 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 = '5008' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '3')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4080' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4080' 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 = 4080 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 = '4080' AND ovd.language_id='3' AND od.language_id='3' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT filter_id
FROM oc_category_filter
WHERE category_id = '51'

SELECT *
FROM oc_module
WHERE module_id = '51'

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

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

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'attribute' AND `value` IN('99255903e9f71877448c14733e0bdd9b','99255903e9f71877448c14733e0bdd9b','75fe17d0a80153d4e57862538f2e6fe2','99255903e9f71877448c14733e0bdd9b','a09100444761460e40b5b07d686aba37','ce5c0a6a52e41199901f7ed32fda149f','5f2e71cf6159a21603b05acc75e876fa','5f2e71cf6159a21603b05acc75e876fa','9d60f04dc5e8e18886108a588519ea3a','aa54c91886ce80efb12f61e6ae12230b','5f2e71cf6159a21603b05acc75e876fa','9d60f04dc5e8e18886108a588519ea3a','9d48d39dd8a627061257aeff267633b4','5f2e71cf6159a21603b05acc75e876fa','aa54c91886ce80efb12f61e6ae12230b','5f2e71cf6159a21603b05acc75e876fa','9d48d39dd8a627061257aeff267633b4','5f2e71cf6159a21603b05acc75e876fa','9d48d39dd8a627061257aeff267633b4','d6f428d93e0155f21c673f18c97b0f77','d1a2a0771051e6899e8f8ae6ba0d8bb9','dd194f21a24bdf934ede35d642d5c4db','f8dd87e76c136ac81f110212ec208bb2','113c26ffd04b8a38d00fea829af691fb','80e89d995129bdcaea406919b2f0d4b7','97c9a3c1311fd3edac819bba97c7ccc3','7b88387a15577da97491a82b3816863b','f74fe8f1c33435fb6db25e11eebd64f2','641d74af47e371bbfaccb9168d6f3add','641d74af47e371bbfaccb9168d6f3add','eb615f1f110457e3a08d8da966c050c0','245d4648f9d158196e61ea85ffb54ee8','09e617e6c2933e99c43791e0616016b6','09e617e6c2933e99c43791e0616016b6','09e617e6c2933e99c43791e0616016b6','9d48d39dd8a627061257aeff267633b4','16833a919ee7b57a4b39371aad928a92','3cba5e055a39f4f4f1e9ace61b3ee04a','b902c3fafb68d5d1476b198f34d16b06','9d60f04dc5e8e18886108a588519ea3a','4c13c13052f5af4e09b166ad656d7932','55b3c28663fc11e08426a015f8375f0f','cb8eefe25ed68e06a7af9d7d157f00e6','8fe577bfe6945e83a330f533c62ac31d','aa54c91886ce80efb12f61e6ae12230b','aa54c91886ce80efb12f61e6ae12230b','d6f428d93e0155f21c673f18c97b0f77','9ee557a807fe72d246cb6a3569c25515','0832b3288f8861da760d522450e57437','d095261d7f5e7ef88917b676c5420345','7f058b9898f7d16be7af81d10b143943','6e6a714136860dfdaac14133e9c5a7df','eb615f1f110457e3a08d8da966c050c0','7a0ba6b8f4ac2a82e823d64f16403212','7a0ba6b8f4ac2a82e823d64f16403212','a09100444761460e40b5b07d686aba37','5f2e71cf6159a21603b05acc75e876fa','3cba5e055a39f4f4f1e9ace61b3ee04a','aa54c91886ce80efb12f61e6ae12230b','f654b87d2d277ecc2416637dfd6c95e8','c746996cfd604b42e7de019c01b2994e','0fe855e2e1cab2f69bf00cd9e659a286','a7b67e3226deeefb3d3d2f45651a4479','9d48d39dd8a627061257aeff267633b4','9d48d39dd8a627061257aeff267633b4','d6f428d93e0155f21c673f18c97b0f77','7f2700c40dc49aa4bc0fd2760765b024','5760d4c930d0670da88fd55dfdd8b165','99e80ef5b4f6b21df61934c588e2837c','753b1faebc274b03d93ba0d6dc1962ad','6cf55418780cc954e263a5437084cfc3','6175f4633501248bc61d2bf247d9021d','9034a7af1f6926065f0ef71aa09e2aa3','18e9ee11e9231c956d0ef5804c22972a','237e2f706265b171f2b8855067ee3f16','2e76ad9668f9835f4c4a779a4d0e2fef','75fe17d0a80153d4e57862538f2e6fe2','75fe17d0a80153d4e57862538f2e6fe2','aa54c91886ce80efb12f61e6ae12230b','75fe17d0a80153d4e57862538f2e6fe2','5862152fbf131634e245f6e263a2b1b3','c23ff60542d688e48e3b2d8d2b0c6115','2804bafea68f88c2bdecde544085d248','c26565416b2513b90077070aaf8b680c','050b6b89f4f4e1f6965c49acaf9ce1d7','e2e55f1a0923d5a02df249c1ca97b232','1498c980f34f1228244c77c44b5ff111','d84c8d4d1b01def0d764e12810d99ca5','43ebc6f27c183241f7c1111ac5b1c959','dc135a7ccf528a11fe19fd079d079277','aa5064cd5528262d2010f05cdf739891','d6f428d93e0155f21c673f18c97b0f77','ce6685a4271fe545b6387da111941dbb','ec2b777653f77244433060b78c4d5445','c140cc24a722427cbdfc734cbe0891be','651befc7398722f3e7667b75a41b7f6e','050de62189094cbb8f91a2260a3a8eab','fb2ac49093e87c74158679616308d07a','a09100444761460e40b5b07d686aba37','a09100444761460e40b5b07d686aba37','5f2e71cf6159a21603b05acc75e876fa','a09100444761460e40b5b07d686aba37','5f2e71cf6159a21603b05acc75e876fa','aa54c91886ce80efb12f61e6ae12230b','a09100444761460e40b5b07d686aba37','050b6b89f4f4e1f6965c49acaf9ce1d7','f654b87d2d277ecc2416637dfd6c95e8','e51fb264afde4d806ad8cb080f091f21','ce5c0a6a52e41199901f7ed32fda149f','94293736257bb16f3310275e70540a52','ee9be9b132d2704ab535edf48b7485ab','b5e420051d751d11dac96a3398b6744b','5862152fbf131634e245f6e263a2b1b3','5862152fbf131634e245f6e263a2b1b3','09e617e6c2933e99c43791e0616016b6','9d48d39dd8a627061257aeff267633b4','5862152fbf131634e245f6e263a2b1b3','9d48d39dd8a627061257aeff267633b4','1d5254e1f5e84ff219701eceaf4cec4e','ca9faa5d67e997dc53174e7a109dae02','3824f9b461f9deda63b73073fd49a11c','c901e53003c9a22e3a9be0c64e35c54e','3067395882ad76b9664702452b15422e','a09100444761460e40b5b07d686aba37','5f2e71cf6159a21603b05acc75e876fa','788d6d89ff7d902651b89002b84f73d2','88f46902caf11ff4d46a5b76f6a014b5','f5cd262901883dff68d06b215fb0f28e','ad64dd101919ff6018d94ec0fe313a26','0373121d6367957cd317b356d9ff6e85','d9ba89654f786fa825370ec6196b6cd8','90bbed46f58ce8b5afab112d1483b7fb','6f8d88cad13c759ac5dd15ab42a6a57c','3f2248134ed910bcf17e8b91f7269bed','3f2248134ed910bcf17e8b91f7269bed','890083810e17d190c5fcbcc507aff5ec','717a3a498d5b15c3c76c5ed4841ef048','71a731effc43ac8bab7455c5e4ce9cc5','3f2248134ed910bcf17e8b91f7269bed','387fa7f2a8f22814a0e32b6a00540cbe','71a731effc43ac8bab7455c5e4ce9cc5','8ada2aaf87666bee33ee7e48f4111ad3','5f9474690c45c0d0aee6378608e7c805','c4ac34038d7add324676d278f98ca379','d1bd32d9f152faf416d2fa3efa870513','82622e6a7ebe020d01502bebe49b75b7','75503ed94172a03c5b3040cf0f9d497b','e95bbaed1e07ecc83ee2b08121d27072','67268c0d3f4acfa8d82a00e0f1d1f497','f7c50ec3fc3e53df46a10a3d0f470f39','f8c891f66383c733ef89a7f2a3328a3a','8c9e51d43151d6722f5a8f716468cb4d','2f13aa1d45f844d2a02db93851ca99f1','90e6527f1c806820945540a168495f3d','540e009b42d0fe414b8036d3891fb510','725fccb5239074c3d722c5fae5188856','ccbe9a185f7c5e937b01cbdd9e755729','81aa05d271c10b3a3646957e4d3219df','c50011ad044fb16a9733a3c10e18894b','6cbda24f2ee35d20be6070072c8373c3','a1d1554c047a709d281d0a663642a947','50ec369b9b6b00b001db9e8e56184203','2cd75613a2aa93a0def18cb2fca2c6f4','0195bf3b36f14cafe6a3f9ca3252e42a','90fdc93c8a6d98e8306b4027b124a6dc','34f3e3b72f2d22a8990e80605e123882','2eb16c7388f13207fa979bb085a54a2a','6739210fc8d4ed300aa3eaa897e0b569','6739210fc8d4ed300aa3eaa897e0b569','725fccb5239074c3d722c5fae5188856','6739210fc8d4ed300aa3eaa897e0b569','71a731effc43ac8bab7455c5e4ce9cc5','8adc053702e1db844c7cc50f0a5318fa','24e996719315d6b101ce7b219ebf5c08','cefc4f7cbc8c34762e0f76703e7e174e','76b88e7899abb3bfdd4b55b8c52726b0','bffd6a869281928a1e1e0c8c79fa306a','b662b5725296bca0a5b8bc5480a08590','e177d102817f74297b6b5b53bac81caa','38f2a41ce54f26701097f4156e9da3d7','5b8611653f8d6902853b98cc8f0eb03e','d17f0c8c21a1a59c60238fb1ee89bc56','7e64619d24457d83465302cf09a239ee','7c120866231a3c7cd6d5bc1f688f6d08','8583cd257d19ef79828fe8f11dacc587','7850f57bca04fee8c72bb923837b5c1e','a6b73d7072bc04d5736831dd278748e4','1db6247b1b5343d2383342e5f936dcc9','e9c938062a7b6abcb38d68232d0d5849','1c9e0af6cc2fc9895e3313750b2a5e85','64a5348914f1a848aedf5f6b827b57ba','b47db63c60e30796b137656e5113afe0','bb89a674b72f8b4b2f4ab7956eedf9d5','71a731effc43ac8bab7455c5e4ce9cc5','7c1e9a80f50c2d3f419dd087e4d19d73','d6857596911dddee40e217a3e245848d','204a544c10b0416e30aefefe82bf3585','63e1d37f84f34c7a35dcc75723a88d66','9fcb7d6bc8582742f5e6732b5a7c08b5','bc723fb2c080a160fc97c622efa2ff83','8fa726af3ba7a903391de9411d56277f','76e1ca97cb509cb8d69de150e96458a6','093b5a045d765a2de0a95e839ad6febc','4c80bfeca3747ff258c7622662827c77','f06b52122cc0cd0bf106f239fc4e581b','4ba284dcacf33403de17628772f5aad8','387fa7f2a8f22814a0e32b6a00540cbe','387fa7f2a8f22814a0e32b6a00540cbe','71a731effc43ac8bab7455c5e4ce9cc5','e95444134783e2d310ad485b9f08cf8f','4483c817fc7620f72d5d5953e1e7f8f2','9efcecbe0fb1598e9368843c6cabcfcc','9efcecbe0fb1598e9368843c6cabcfcc','cda0e8e257c49dc2f9c427b6bf46ad15','29a1026c5266c4bbe21a1fcf7fab51b5','b494883b5747f241ac2ed3747f3a31ec','7c9c09f512cdc91392500b119f48f0d6','ed6b48dab752e736b0df8b0c89e64f85','e57c3a85aec304f9e5291cd9604a331d','754227d9a15d3e6b02655559325f868a','a353c16e3c85f429421a1287c507462c','635c399b4d8c4af7c344385c5ad7635d','100113f141687d97a198ef4cc4afb60a','ac02868d98b7e3aa80e548df163f40c1','d5ecba92634a8a325f7925d75ad307ca','6e51dd4019604a04839caa4e191a9f11','3a0c9846cf173c4443555aa83f1d6289','d30973809f2e4238b7eb2bac9241674c','89d6368756ba755f81d214591f94a2f8','eedfc25c7412e7860273f001307332a1','679007ed3a29d51ef416b7ae1e1687e1','fa10bdea710f9faf5c87a53ca8d2984c','1eb9dab77e9b76316d224425b40cbd7f','c588cad2d2ea5dfda489c6ff415b6afc','f4bac1fe9f56b8914108500b9201dd0e','8f21fcdc233ba4078679ca628453d06b','624f8ef92fc27027f110e02b76c30606','3124f571f0802397662b27f83c3b5d02','ece937ff8d2d0b8847b2069006d5fd87','4f1a774b41e6b7bfd7e3dce5f7005f81','0c6c93747300b837c6dad72975246f11','4936559013eb7df26a72dd37d1e33fb5','f5418011d2ace6f9fd06728e12f9a188','c4cef4cbb910c02d3838c6374d21e5c2','b1ab0aa168f72255f28c59d740b557d8','18cedb337ea347cf3a7e4ee9969312d2','97eeab177c5cccda3d3ca3443ff1a303','c3680a2c6859ba61dfcf0bdffd831d8c','2e513e9e17a6bd9748bd1396469323c2','79327117b195d3ef56bd847b1d927816','1611e5f3da8f7101c9bfcaf803555b32','9a4d22e24307f7affe323423c3450d0a','71a731effc43ac8bab7455c5e4ce9cc5','24c473b4cc4177eac7723dcea1539033','0a5d466836e2eab8de99c74e17994c8e','70d52a4b4eff30f260db2baa35a66bea','f2698231f570d738d78dbd243ff8dd4c','06b2adaa3a34223aeb6560cb2fbe024e','065d29f8fee69dc1140c70ded39bc4fc','5e3132138c58b13386dcda0d52be44d8','25a81701fbfa4a1efdf660a950c1d006','83dafb1abbae96bb1ce859bea4d928d8','ee059fcb1663f4d5547af2b438ec2035','c9baed786867e19ce12b799ad30a846a','bccb229880a01f28daaff0a0a06b8d57','9425b18c004386b3d9d011da58358a86','5622f5bced185b73a45b9a91c9f875ad','9425b18c004386b3d9d011da58358a86','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','14cc3c6d88cc7f8b324dd664c9262d1d','9425b18c004386b3d9d011da58358a86','a6822a598f144d16972dc61ca334c869','ac1ee8606c6a16113c184de9285bfa67','9425b18c004386b3d9d011da58358a86','e665430ed736112774e3c3389869ddf5','9425b18c004386b3d9d011da58358a86','14cc3c6d88cc7f8b324dd664c9262d1d','14b98abff524b7fd7688af111166a0f2','a6822a598f144d16972dc61ca334c869','6f1090526f1c8582f4344f7a1730f4a0','14b98abff524b7fd7688af111166a0f2','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','14b98abff524b7fd7688af111166a0f2','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','14b98abff524b7fd7688af111166a0f2','78d5bb499885787a54c3c066c2ae23da','14b98abff524b7fd7688af111166a0f2','78d5bb499885787a54c3c066c2ae23da','4c0ccbda76de3618f247f8f55da744ce','14b98abff524b7fd7688af111166a0f2','78d5bb499885787a54c3c066c2ae23da','136c463ae01bb9f451bfbf7fda2820e4','14b98abff524b7fd7688af111166a0f2','78d5bb499885787a54c3c066c2ae23da','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','14b98abff524b7fd7688af111166a0f2','0be8800ab702f20b5c3663a621f5e421','a72c1fcca713bbf84de080485bdaadd6','14b98abff524b7fd7688af111166a0f2','a72c1fcca713bbf84de080485bdaadd6','14b98abff524b7fd7688af111166a0f2','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','14b98abff524b7fd7688af111166a0f2','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','62c2b40398a6e5e1745957fb4c957f39','14b98abff524b7fd7688af111166a0f2','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','14b98abff524b7fd7688af111166a0f2','a72c1fcca713bbf84de080485bdaadd6','ac1ee8606c6a16113c184de9285bfa67','f2cab1d213e999697c3d4f92d47e1c38','f2cab1d213e999697c3d4f92d47e1c38','c01fdd8a06d16cc9ca0d889f76e89ff4','f2cab1d213e999697c3d4f92d47e1c38','3bc96a89ccba591864205ce62d49bd14','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','4c0ccbda76de3618f247f8f55da744ce','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','4c0ccbda76de3618f247f8f55da744ce','6f1090526f1c8582f4344f7a1730f4a0','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','f2cab1d213e999697c3d4f92d47e1c38','6f1090526f1c8582f4344f7a1730f4a0','f2cab1d213e999697c3d4f92d47e1c38','6f1090526f1c8582f4344f7a1730f4a0','136c463ae01bb9f451bfbf7fda2820e4','f2cab1d213e999697c3d4f92d47e1c38','6f1090526f1c8582f4344f7a1730f4a0','a72c1fcca713bbf84de080485bdaadd6','f2cab1d213e999697c3d4f92d47e1c38','d5991440f034de1e63d6cb7fd767be73','0be8800ab702f20b5c3663a621f5e421','f2cab1d213e999697c3d4f92d47e1c38','136c463ae01bb9f451bfbf7fda2820e4','f2cab1d213e999697c3d4f92d47e1c38','136c463ae01bb9f451bfbf7fda2820e4','6f1090526f1c8582f4344f7a1730f4a0','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','3b1f5fe8181ee4aec4cc0ef6efcbfecc','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','3bc96a89ccba591864205ce62d49bd14','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','136c463ae01bb9f451bfbf7fda2820e4','f2cab1d213e999697c3d4f92d47e1c38','ac1ee8606c6a16113c184de9285bfa67','f2cab1d213e999697c3d4f92d47e1c38','ac1ee8606c6a16113c184de9285bfa67','3b1f5fe8181ee4aec4cc0ef6efcbfecc','9dcba2ff5bdf8fcde09dd2f8dbceec57','e7081a9dfbdf08022bc93f9bd0fb759d','389657bad882dfebe150e231d98bf64b','5622f5bced185b73a45b9a91c9f875ad','5622f5bced185b73a45b9a91c9f875ad','a6822a598f144d16972dc61ca334c869','3bc96a89ccba591864205ce62d49bd14','cc1818c80d7c1bdc504bc7776af6b3f0','0923f5abba299e858c63a9e9e8a893e4','320d1e7a16e17af68aab0eab145bd711','14cc3c6d88cc7f8b324dd664c9262d1d','5622f5bced185b73a45b9a91c9f875ad','0be8800ab702f20b5c3663a621f5e421','5622f5bced185b73a45b9a91c9f875ad','a72c1fcca713bbf84de080485bdaadd6','5622f5bced185b73a45b9a91c9f875ad','a72c1fcca713bbf84de080485bdaadd6','136c463ae01bb9f451bfbf7fda2820e4','7e554f5f34afc2746b2262bd1b574819','82d83a3da63962e0e45ea9cd25ad4f10','1834e58a07a1bd761ded407b46f4d330','94b3afdd6233d8d4ed213d69d6390ac1','12a1c68aa2d819d6fd31e9323fb6e186','182537d0e8b67e14c5e4a5c96aa1e341','b4a27c7f350a35e638749fdf4affd8dc','180d15b48cc6b9d9307e3ef128cd8a16','bd7be55bd40d11a48a910dfba6f70029','a6822a598f144d16972dc61ca334c869','a6822a598f144d16972dc61ca334c869','9425b18c004386b3d9d011da58358a86','a6822a598f144d16972dc61ca334c869','600d9ef6320de628a6ceeb0d44d0e79a','d5991440f034de1e63d6cb7fd767be73','a6822a598f144d16972dc61ca334c869','1cccc1f48e992b34fb3118809269368b','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','536e3283d849e3ff71a5bca07240c5fd','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','600d9ef6320de628a6ceeb0d44d0e79a','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','6f1090526f1c8582f4344f7a1730f4a0','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','14cc3c6d88cc7f8b324dd664c9262d1d','a6822a598f144d16972dc61ca334c869','0be8800ab702f20b5c3663a621f5e421','a6822a598f144d16972dc61ca334c869','136c463ae01bb9f451bfbf7fda2820e4','a6822a598f144d16972dc61ca334c869','136c463ae01bb9f451bfbf7fda2820e4','ac1ee8606c6a16113c184de9285bfa67','a6822a598f144d16972dc61ca334c869','136c463ae01bb9f451bfbf7fda2820e4','14cc3c6d88cc7f8b324dd664c9262d1d','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','bcc9037a6eefd8318227101969f1ebeb','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','600d9ef6320de628a6ceeb0d44d0e79a','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','136c463ae01bb9f451bfbf7fda2820e4','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','ac1ee8606c6a16113c184de9285bfa67','a6822a598f144d16972dc61ca334c869','14cc3c6d88cc7f8b324dd664c9262d1d','a6822a598f144d16972dc61ca334c869','14cc3c6d88cc7f8b324dd664c9262d1d','4c0ccbda76de3618f247f8f55da744ce','729d3f6d9f48e79a8ffcad4f70b331d0','729d3f6d9f48e79a8ffcad4f70b331d0','729d3f6d9f48e79a8ffcad4f70b331d0','58e1f405487f14c196292aa68544f632','729d3f6d9f48e79a8ffcad4f70b331d0','59247931425dfacef4b9ef0cef237b0a','729d3f6d9f48e79a8ffcad4f70b331d0','d35a829f9f0c20b324cf2683f9fc39be','729d3f6d9f48e79a8ffcad4f70b331d0','15ebf3db4012b67f034d4c77a4767b3e','729d3f6d9f48e79a8ffcad4f70b331d0','2ca6d52649466e7404000a6e2f0c34bc','525e00d157f043c01e0134a2bb0a7150','898ef20b74ba8552aa7e47dfe9a0037a','1517cab5d50b6954071e79f945818b51','57946a170a6451b5d19a87847bf4d5e6','aeb9b67118424390d5dd6e5961eee4ec','0ec678c08c9ad5c69efdf0fd862f583a','c8b2062148a6433163b1e9a1493c3c1a','dc9ab642cd3f9b2a1c7942d9c2b87bf3','84947551243e89353a6f630418481e4d','b31a423ee3cf651804db082203008b9a','665b1ce58cd542e82cd50102de9ccbe7','df11ff148f84e36c0688cabbaf72c67c','d20027a6e6a181f96fdcf08a586c5377','c01fdd8a06d16cc9ca0d889f76e89ff4','0be8800ab702f20b5c3663a621f5e421','3bc96a89ccba591864205ce62d49bd14','f2cab1d213e999697c3d4f92d47e1c38','3bc96a89ccba591864205ce62d49bd14','f2cab1d213e999697c3d4f92d47e1c38','4c0ccbda76de3618f247f8f55da744ce','3bc96a89ccba591864205ce62d49bd14','4c0ccbda76de3618f247f8f55da744ce','3bc96a89ccba591864205ce62d49bd14','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','3bc96a89ccba591864205ce62d49bd14','136c463ae01bb9f451bfbf7fda2820e4','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','600d9ef6320de628a6ceeb0d44d0e79a','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','8f778eab0d3832210b002d0645acbd3b','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','8f778eab0d3832210b002d0645acbd3b','a72c1fcca713bbf84de080485bdaadd6','8f778eab0d3832210b002d0645acbd3b','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a99c5bc29869d7230096c37ea901f639','073f568cef07d851d45f6104c8671b66','58e1f405487f14c196292aa68544f632','87e10ccf9292580be89da33035be924d','c54fa54819070194d7a9097b1a0c98d5','c54fa54819070194d7a9097b1a0c98d5','982e5f050c02124808aee69eac007bcf','c54fa54819070194d7a9097b1a0c98d5','14cc3c6d88cc7f8b324dd664c9262d1d','d6a899cf3e4144d4445a838d3cf85d21','8af3189699aae24ff12a0d29220c89a5','6d98b131186a8a6875e1706500360524','558593249e55b4cc9099013e2e849bdd','d0e14e93e24eab2881b49cb4cacb0159','e48fa5f4fd84d08fef2c96cd0b55b9a3','f5e3128684662028af32a8b10525c427','65769bfb9cb2d08a2418eaff10e201f4','9c58e95b14718ad1deeb54c2a75eec4f','0bc98fd6ea454de7391f2e3c765454be','62ec5769e20091db873c0c235b3919a8','3e390cda14768ab6f721a55d2f060edf','932ed92b8a7f6885675fae2deede1932','7913834067cba9aaf0fedcb5e7ea6dc7','65bfc674408d5d35eaacc7f6ae1c7c51','65bfc674408d5d35eaacc7f6ae1c7c51','65bfc674408d5d35eaacc7f6ae1c7c51','f2cab1d213e999697c3d4f92d47e1c38','65bfc674408d5d35eaacc7f6ae1c7c51','78d5bb499885787a54c3c066c2ae23da','65bfc674408d5d35eaacc7f6ae1c7c51','a72c1fcca713bbf84de080485bdaadd6','65bfc674408d5d35eaacc7f6ae1c7c51','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','65bfc674408d5d35eaacc7f6ae1c7c51','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','6f1090526f1c8582f4344f7a1730f4a0','1619185fc7f1f3ba8a7bf7834b9dd28f','020e2384b6567509c6ce724584997c13','79ca2e18e3b9b7a8d66c025b54d678bf','5afe31f814a8d827516dde48a105af52','b376d54749cd0bd91e05bb633dcfe1e5','d32b67268c8fbdfc2e499e3d56800eaf','e2babb146dea62cd6646cea31302860a','fadc9bb68882169d1997a40a2af95a90','13359d81b3d5d59456146a5055993a24','1a47245eea686557993128542b791ba6','0353edf7fdf16d39a2b0fbf5c5ba1b84','f8cbc38830e92cafc4b1889dfdf4d3e8','f356263d95aa16b86d694f4ff4676d8e','406437e3b31602265842105e1b3f5aad','e665430ed736112774e3c3389869ddf5','e665430ed736112774e3c3389869ddf5','14cc3c6d88cc7f8b324dd664c9262d1d','029df0d59f306a30b5e6c789610729b9','78d5bb499885787a54c3c066c2ae23da','78d5bb499885787a54c3c066c2ae23da','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','bf19c80e2f48b7498ae5e7c9c1a9b615','dc4c0b7d491238866cb0c29ff4927e01','9eb87ae341e58a490f08ed49f7056caa','9826325994dc17ccbbdaa57a41ae6042','e80b7f15e3746502e3dfdf2e20126c70','ae2c1b56741441ccc5c8d5d4b616e20a','befbb9fedd2350b96ecf9afc54f86f51','991ce356a5aa8126bb71edeb5b9f7100','96d31d5a4564e01572fb431d53cae66e','324b6bf028f59e306df0490f1c455e29','646982eb374c612c6f9e0bd9b1ff14f6','d6adec680b3581e4a7ebe22490cdb536','324b6bf028f59e306df0490f1c455e29','d6adec680b3581e4a7ebe22490cdb536','7affa89654aec2441d0b47a3a29210f2','bab03d845974aae0fa56f9f754a6b4e9','646982eb374c612c6f9e0bd9b1ff14f6','d6adec680b3581e4a7ebe22490cdb536','646982eb374c612c6f9e0bd9b1ff14f6','d6adec680b3581e4a7ebe22490cdb536','324b6bf028f59e306df0490f1c455e29','d6adec680b3581e4a7ebe22490cdb536','d6adec680b3581e4a7ebe22490cdb536','324b6bf028f59e306df0490f1c455e29','c3b4428bbb11772b2206ae73b5d2c1f7','c896ac52d7b16a01d2f2bcee91484874','b7ca1666ce775ed18c1f23928bcd63be','db62fb93967659c4db076be602e83de2','0a5a96979270240cbb938191e4bd30f5','b838f0b130c4310854bbed8882f3b5b0','72ee10c9930b59a65cb5334db7bcb972','414d338b867308907c4d048925a7dbc1','1eabe288ffb645f3a77d1cae2a794cf3','0874d41c7c098b59dc17630e706ebff5','9c718ca1ba6ad730379d72c2f8955830','44dce186710874cea65ee04b404e4967','982e5f050c02124808aee69eac007bcf','14cc3c6d88cc7f8b324dd664c9262d1d','0be8800ab702f20b5c3663a621f5e421','fa6d5f9abb041d422711cfed2d3820a9','c2342eb9c3be303c391b65105406b15a','b6f6a20311332231fe76f7f3321283e6','b6f6a20311332231fe76f7f3321283e6','87e10ccf9292580be89da33035be924d','b6f6a20311332231fe76f7f3321283e6','d35a829f9f0c20b324cf2683f9fc39be','b6f6a20311332231fe76f7f3321283e6','d35a829f9f0c20b324cf2683f9fc39be','2ca6d52649466e7404000a6e2f0c34bc','61f677dd5cc97f02b050d168bfd965aa','70ea6db54c2c35c1c49cc45fe705e822','f3dee5f12a5c555cfb771e26262aa371','ceeb428e2468fbbe528d99595f6e6980','3b1f5fe8181ee4aec4cc0ef6efcbfecc','1cccc1f48e992b34fb3118809269368b','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','1cccc1f48e992b34fb3118809269368b','a72c1fcca713bbf84de080485bdaadd6','1cccc1f48e992b34fb3118809269368b','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','66c23c1ad6ff1915d1b14497dc36378f','d6b38127925a8c0b328e459a521472f8','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','d6b38127925a8c0b328e459a521472f8','14cc3c6d88cc7f8b324dd664c9262d1d','bcc9037a6eefd8318227101969f1ebeb','4b894aad4af1590b0c738029a7ce2400','536e3283d849e3ff71a5bca07240c5fd','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','e08aeac54441337b2a34b8bc9a04fb2a','14b98abff524b7fd7688af111166a0f2','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','14b98abff524b7fd7688af111166a0f2','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','14b98abff524b7fd7688af111166a0f2','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','e08aeac54441337b2a34b8bc9a04fb2a','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','f2cab1d213e999697c3d4f92d47e1c38','a6822a598f144d16972dc61ca334c869','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','f2cab1d213e999697c3d4f92d47e1c38','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','f2cab1d213e999697c3d4f92d47e1c38','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','14b98abff524b7fd7688af111166a0f2','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','c01fdd8a06d16cc9ca0d889f76e89ff4','e08aeac54441337b2a34b8bc9a04fb2a','c01fdd8a06d16cc9ca0d889f76e89ff4','349ad56c55cdcbac021a6146085c1281','d5991440f034de1e63d6cb7fd767be73','e08aeac54441337b2a34b8bc9a04fb2a','c01fdd8a06d16cc9ca0d889f76e89ff4','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','c01fdd8a06d16cc9ca0d889f76e89ff4','a72c1fcca713bbf84de080485bdaadd6','e08aeac54441337b2a34b8bc9a04fb2a','600d9ef6320de628a6ceeb0d44d0e79a','e08aeac54441337b2a34b8bc9a04fb2a','65bfc674408d5d35eaacc7f6ae1c7c51','e08aeac54441337b2a34b8bc9a04fb2a','65bfc674408d5d35eaacc7f6ae1c7c51','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','78d5bb499885787a54c3c066c2ae23da','e08aeac54441337b2a34b8bc9a04fb2a','1cccc1f48e992b34fb3118809269368b','a72c1fcca713bbf84de080485bdaadd6','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','c01fdd8a06d16cc9ca0d889f76e89ff4','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','c01fdd8a06d16cc9ca0d889f76e89ff4','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','65bfc674408d5d35eaacc7f6ae1c7c51','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','0be8800ab702f20b5c3663a621f5e421','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','a72c1fcca713bbf84de080485bdaadd6','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','14cc3c6d88cc7f8b324dd664c9262d1d','e08aeac54441337b2a34b8bc9a04fb2a','349ad56c55cdcbac021a6146085c1281','ac1ee8606c6a16113c184de9285bfa67','e08aeac54441337b2a34b8bc9a04fb2a','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','4c0ccbda76de3618f247f8f55da744ce','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','4c0ccbda76de3618f247f8f55da744ce','d5991440f034de1e63d6cb7fd767be73','e08aeac54441337b2a34b8bc9a04fb2a','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','6f1090526f1c8582f4344f7a1730f4a0','a72c1fcca713bbf84de080485bdaadd6','e08aeac54441337b2a34b8bc9a04fb2a','d5991440f034de1e63d6cb7fd767be73','e08aeac54441337b2a34b8bc9a04fb2a','d5991440f034de1e63d6cb7fd767be73','a72c1fcca713bbf84de080485bdaadd6','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','0be8800ab702f20b5c3663a621f5e421','e08aeac54441337b2a34b8bc9a04fb2a','0be8800ab702f20b5c3663a621f5e421','f2cab1d213e999697c3d4f92d47e1c38','e08aeac54441337b2a34b8bc9a04fb2a','0be8800ab702f20b5c3663a621f5e421','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','0be8800ab702f20b5c3663a621f5e421','6f1090526f1c8582f4344f7a1730f4a0','e08aeac54441337b2a34b8bc9a04fb2a','0be8800ab702f20b5c3663a621f5e421','a72c1fcca713bbf84de080485bdaadd6','e08aeac54441337b2a34b8bc9a04fb2a','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','136c463ae01bb9f451bfbf7fda2820e4','78d5bb499885787a54c3c066c2ae23da','e08aeac54441337b2a34b8bc9a04fb2a','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','e08aeac54441337b2a34b8bc9a04fb2a','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','78d5bb499885787a54c3c066c2ae23da','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','e08aeac54441337b2a34b8bc9a04fb2a','a72c1fcca713bbf84de080485bdaadd6','136c463ae01bb9f451bfbf7fda2820e4','e08aeac54441337b2a34b8bc9a04fb2a','ac1ee8606c6a16113c184de9285bfa67','476aa642ae23de2cb297d341fbd8f4ea','32b8d1967b704feb3b87830d7a04f87b','2092d3352e6c44fc220b0f14ced468c5','349ad56c55cdcbac021a6146085c1281','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','a7e844990210e90f7376e212799882b7','4c0ccbda76de3618f247f8f55da744ce','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','0be8800ab702f20b5c3663a621f5e421','4c0ccbda76de3618f247f8f55da744ce','71149ab2713dae26f9533e87ba6a76e3','4c0ccbda76de3618f247f8f55da744ce','600d9ef6320de628a6ceeb0d44d0e79a','4c0ccbda76de3618f247f8f55da744ce','536e3283d849e3ff71a5bca07240c5fd','4c0ccbda76de3618f247f8f55da744ce','6f1090526f1c8582f4344f7a1730f4a0','71149ab2713dae26f9533e87ba6a76e3','4c0ccbda76de3618f247f8f55da744ce','d5991440f034de1e63d6cb7fd767be73','6f1090526f1c8582f4344f7a1730f4a0','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','a6822a598f144d16972dc61ca334c869','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','372bf29a59dddcfb187e1e9e261e5f6a','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','001315bcafd913bc40a6da92b3e6677d','4c0ccbda76de3618f247f8f55da744ce','14cc3c6d88cc7f8b324dd664c9262d1d','4c0ccbda76de3618f247f8f55da744ce','14cc3c6d88cc7f8b324dd664c9262d1d','600d9ef6320de628a6ceeb0d44d0e79a','e0779b73a3dd585719373ef400d06209','d63afca184e9d7b926109965645354cb','794b38063f11c180f7b55e0154a65422','0923f5abba299e858c63a9e9e8a893e4','781c9e82d5d649aa5d6cfc01b6398c0b','cca9a5f84d28a12fc7708ebf5d053fc0','6f1090526f1c8582f4344f7a1730f4a0','320d1e7a16e17af68aab0eab145bd711','320d1e7a16e17af68aab0eab145bd711','e0c691f518701eb34048422ede200d79','a72c1fcca713bbf84de080485bdaadd6','49a2884e1911ac603cdd1dab23b0991c','d5991440f034de1e63d6cb7fd767be73','d5991440f034de1e63d6cb7fd767be73','4c0ccbda76de3618f247f8f55da744ce','93070cec7d6c15869763173fe75f646f','1ed1c408a4ac822b728a2077a1d9935c','72e9a5ef7e2ed28fbbcf1361c353a9a7','70b61cff07a8458d87dba0fb1dadc323','ff26bad38a8074179c37b606df48af34','c0afd0148102afd748d31112256e34a5','17336693bd5f475bf564f7142e77420d','f59bf35aa4033a1725b423bd127400ca','984d03b7cf2329779f78e9de5b92d678','377e61389154c7f548b61417938c5911','d8d36ac96d00a893de2f8ee06e493dcf','278473f32990d07452046f01557303ac','fc29a46a9484ec663256cde5dae062ef','9395c5ccb0ab8ece6fe98ed9f1241fc3','12bf68b795495a3b37ffd2acba1d224b','6209777b1e29dcf58e06304ffd50f5f9','e2fb9cc81f07aedf72b27e397d04d24d','c70c67c8e5248881e832f9e9efb35a91','8221aaa9a04951705258548aa9af1110','0be8800ab702f20b5c3663a621f5e421','0be8800ab702f20b5c3663a621f5e421','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','14cc3c6d88cc7f8b324dd664c9262d1d','d5991440f034de1e63d6cb7fd767be73','1351913739a899cfa8fcf12270d4cea4','a825ec2b2b50af934c8c80a942c71a93','0490c439159e2b0a2fbcbe85e857a209','7a1faec526464bcc5c36f961ffe14492','9c95caf294d90d100e19bea838c3b4f7','1f251c46101230f53a00795331bd22a7','07daa3321ba53e2946081604f58f4bf7','d35a829f9f0c20b324cf2683f9fc39be','d35a829f9f0c20b324cf2683f9fc39be','61f677dd5cc97f02b050d168bfd965aa','d35a829f9f0c20b324cf2683f9fc39be','2ca6d52649466e7404000a6e2f0c34bc','d35a829f9f0c20b324cf2683f9fc39be','2ca6d52649466e7404000a6e2f0c34bc','61f677dd5cc97f02b050d168bfd965aa','15ebf3db4012b67f034d4c77a4767b3e','59247931425dfacef4b9ef0cef237b0a','b7e7dfa0bf43a058752addd1eb1e1f47','5d69ac6011ba586f88bc3d61eb5b4170','c7e6e5a027fbee1c80b8fe1aec3043af','136c463ae01bb9f451bfbf7fda2820e4','136c463ae01bb9f451bfbf7fda2820e4','a6822a598f144d16972dc61ca334c869','136c463ae01bb9f451bfbf7fda2820e4','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','d5991440f034de1e63d6cb7fd767be73','136c463ae01bb9f451bfbf7fda2820e4','0be8800ab702f20b5c3663a621f5e421','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','e4c67a2bbf4fccafb15df4ea3239c9c5','a72c1fcca713bbf84de080485bdaadd6','a72c1fcca713bbf84de080485bdaadd6','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','a6822a598f144d16972dc61ca334c869','d5991440f034de1e63d6cb7fd767be73','a72c1fcca713bbf84de080485bdaadd6','a6822a598f144d16972dc61ca334c869','d5991440f034de1e63d6cb7fd767be73','001315bcafd913bc40a6da92b3e6677d','a72c1fcca713bbf84de080485bdaadd6','a6822a598f144d16972dc61ca334c869','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','a6822a598f144d16972dc61ca334c869','ac1ee8606c6a16113c184de9285bfa67','a72c1fcca713bbf84de080485bdaadd6','a6822a598f144d16972dc61ca334c869','14cc3c6d88cc7f8b324dd664c9262d1d','a72c1fcca713bbf84de080485bdaadd6','71149ab2713dae26f9533e87ba6a76e3','a72c1fcca713bbf84de080485bdaadd6','600d9ef6320de628a6ceeb0d44d0e79a','a72c1fcca713bbf84de080485bdaadd6','d6b38127925a8c0b328e459a521472f8','6f1090526f1c8582f4344f7a1730f4a0','14cc3c6d88cc7f8b324dd664c9262d1d','c175c711d8dce7573126f0f82af428c4','a72c1fcca713bbf84de080485bdaadd6','7b525c33e544207b34fc33a7be5494d3','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','f2cab1d213e999697c3d4f92d47e1c38','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','71149ab2713dae26f9533e87ba6a76e3','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','d5991440f034de1e63d6cb7fd767be73','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','a6822a598f144d16972dc61ca334c869','ac1ee8606c6a16113c184de9285bfa67','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','71149ab2713dae26f9533e87ba6a76e3','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','600d9ef6320de628a6ceeb0d44d0e79a','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','d6b38127925a8c0b328e459a521472f8','c175c711d8dce7573126f0f82af428c4','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','d6b38127925a8c0b328e459a521472f8','ac1ee8606c6a16113c184de9285bfa67','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','001315bcafd913bc40a6da92b3e6677d','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','6f1090526f1c8582f4344f7a1730f4a0','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','d5991440f034de1e63d6cb7fd767be73','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','6f1090526f1c8582f4344f7a1730f4a0','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','0be8800ab702f20b5c3663a621f5e421','14cc3c6d88cc7f8b324dd664c9262d1d','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','ac1ee8606c6a16113c184de9285bfa67','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','14cc3c6d88cc7f8b324dd664c9262d1d','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','14cc3c6d88cc7f8b324dd664c9262d1d','a6822a598f144d16972dc61ca334c869','c175c711d8dce7573126f0f82af428c4','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','83a4ade35514bb241f221ffa248c3a3d','a72c1fcca713bbf84de080485bdaadd6','6f1090526f1c8582f4344f7a1730f4a0','600d9ef6320de628a6ceeb0d44d0e79a','a72c1fcca713bbf84de080485bdaadd6','d5991440f034de1e63d6cb7fd767be73','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','a6822a598f144d16972dc61ca334c869','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','71149ab2713dae26f9533e87ba6a76e3','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','001315bcafd913bc40a6da92b3e6677d','3bc96a89ccba591864205ce62d49bd14','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','d5991440f034de1e63d6cb7fd767be73','a72c1fcca713bbf84de080485bdaadd6','0be8800ab702f20b5c3663a621f5e421','14cc3c6d88cc7f8b324dd664c9262d1d','a72c1fcca713bbf84de080485bdaadd6','136c463ae01bb9f451bfbf7fda2820e4','a72c1fcca713bbf84de080485bdaadd6','136c463ae01bb9f451bfbf7fda2820e4','f2cab1d213e999697c3d4f92d47e1c38','a72c1fcca713bbf84de080485bdaadd6','136c463ae01bb9f451bfbf7fda2820e4','d5991440f034de1e63d6cb7fd767be73','a72c1fcca713bbf84de080485bdaadd6','14cc3c6d88cc7f8b324dd664c9262d1d','a72c1fcca713bbf84de080485bdaadd6','14cc3c6d88cc7f8b324dd664c9262d1d','001315bcafd913bc40a6da92b3e6677d','a36132306e4574ca78381ceaac5b9e15','ac1ee8606c6a16113c184de9285bfa67','ac1ee8606c6a16113c184de9285bfa67','78d5bb499885787a54c3c066c2ae23da','4c0ccbda76de3618f247f8f55da744ce','ac1ee8606c6a16113c184de9285bfa67','136c463ae01bb9f451bfbf7fda2820e4','ac1ee8606c6a16113c184de9285bfa67','a72c1fcca713bbf84de080485bdaadd6','f2cab1d213e999697c3d4f92d47e1c38','536e3283d849e3ff71a5bca07240c5fd','ac1ee8606c6a16113c184de9285bfa67','a72c1fcca713bbf84de080485bdaadd6','4c0ccbda76de3618f247f8f55da744ce','c4a2cf48d6435252e95ade1cd899b0c6','316be482d3b106417328cbacaf1c60e1','14cc3c6d88cc7f8b324dd664c9262d1d','14cc3c6d88cc7f8b324dd664c9262d1d','600d9ef6320de628a6ceeb0d44d0e79a','14cc3c6d88cc7f8b324dd664c9262d1d','0be8800ab702f20b5c3663a621f5e421','14cc3c6d88cc7f8b324dd664c9262d1d','a72c1fcca713bbf84de080485bdaadd6','5d980cc51dd76a4a63269099fc8f55f5','d37179884c87a1a35b251a38b7a2d557','19c8db3f581db0bfb980ce40acaa18b9','7954da367de778a0f1cde37e74f477c1','32f873f12a3ca779069e1e709990619d','3dd206fc670913a8b5d1ea3afbb7ec66','77d6b8cfe6d210d84ddf06a5cd84bb19','2ca6d52649466e7404000a6e2f0c34bc','74a86b5543f0ea4c8fc7591a13ed021b','0b0acd01d308e82077a39de9a4512e96','e923b86029b9fbe728976677873c6cc5','6c079d5239b37f1d02fc34ba5f23a782','cbf1d42b79f82d408afe0adc9ad3a68d','e751287acd5ebe4ed07f441da964749f') AND ( `language_id` IS NULL OR `language_id` = 3 )

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

SELECT `o`.`option_id`, `ov`.`option_value_id`, `od`.`name` AS `gname`, `od`.`mf_tooltip` AS `tooltip`, `ov`.`image`, `ovd`.`name`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN `oc_product_option_value` AS `pov` ON `p`.`product_id` = `pov`.`product_id`
INNER JOIN `oc_option_value` AS `ov` ON `ov`.`option_value_id` = `pov`.`option_value_id`
INNER JOIN `oc_option_value_description` AS `ovd` ON `ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 3
INNER JOIN `oc_option` AS `o` ON `o`.`option_id` = `pov`.`option_id`
INNER JOIN `oc_option_description` AS `od` ON `od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 3
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `ov`.`option_value_id` IN(57,59,60,61,80,86,119) AND `p2c`.`category_id` IN(51) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `o`.`option_id`, `ov`.`option_value_id`
ORDER BY `ov`.`sort_order`, `ovd`.`name`

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'option' AND `value_id` IN(119,59,80,60,61,57,86) AND ( `language_id` IS NULL OR `language_id` = 3 )

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

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(51) 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(51) 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=93','manufacturer_id=75','manufacturer_id=66','manufacturer_id=108','manufacturer_id=83','manufacturer_id=115','manufacturer_id=100','manufacturer_id=79','manufacturer_id=118','manufacturer_id=97','manufacturer_id=91','manufacturer_id=74','manufacturer_id=84','manufacturer_id=105','manufacturer_id=71','manufacturer_id=104','manufacturer_id=107','manufacturer_id=90','manufacturer_id=92','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=41','manufacturer_id=46','manufacturer_id=47','manufacturer_id=48','manufacturer_id=50','manufacturer_id=51','manufacturer_id=52','manufacturer_id=53','manufacturer_id=54','manufacturer_id=55','manufacturer_id=56','manufacturer_id=58','manufacturer_id=61') AND `store_id` = 0 AND `language_id` = '3'

SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max`
FROM( SELECT `price_tmp` AS `price`
FROM( SELECT IFNULL( ( SELECT `price`
FROM `oc_product_special` AS `ps`
WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW()))
ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1 ), IFNULL( ( SELECT `price`
FROM `oc_product_discount` AS `pd2`
WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` >= '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW()))
ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1 ), `p`.`price` ) ) AS `price_tmp`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 3
INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(51) ) AS `tmp` ) AS `tmp`

SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max`
FROM( SELECT `price_tmp` AS `price`
FROM( SELECT IFNULL( ( SELECT `price`
FROM `oc_product_special` AS `ps`
WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW()))
ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1 ), IFNULL( ( SELECT `price`
FROM `oc_product_discount` AS `pd2`
WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` >= '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW()))
ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1 ), `p`.`price` ) ) AS `price_tmp`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 3
INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `p2c`.`category_id` IN(51) ) AS `tmp` ) AS `tmp`

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_mfilter_url_alias`
WHERE `language_id` = 3 AND `store_id` = 0 AND ( `path` = '' OR `path` = 'uhod-za-telom/telo' )

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

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

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

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

SELECT *
FROM oc_category_to_layout
WHERE category_id = '51' 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 = '51' 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 = '51' AND store_id = '0'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DELETE
FROM `oc_customer_online`
WHERE date_added < '2022-06-27 04:27:09'

REPLACE INTO `oc_customer_online` SET `ip` = '44.192.47.87', `customer_id` = '0', `url` = 'https://naturecare.com.ua/uhod-za-telom/telo', `referer` = '', `date_added` = '2022-06-27 05:27:09'

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '49'

SELECT *
FROM oc_module
WHERE module_id = '48'

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

SELECT *
FROM oc_module
WHERE module_id = '45'

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '40'

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '42'

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

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

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

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

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

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

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

SELECT *
FROM oc_module
WHERE module_id = '43'

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

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

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

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

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