SELECT `data`
FROM `oc_session`
WHERE session_id = '35e07d8f255504fb00e309eef4' AND expire > 1660055313

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 = 'd64edb05da987da57cc16a514f' AND expire > 1660055313

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://naturecare.com.ua/'

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

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

SELECT *
FROM oc_currency

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '3'

SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '3'

DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 DAY)

SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC

SELECT language_id, code
FROM oc_language
WHERE status = '1'

SELECT *
FROM oc_language;

SELECT *
FROM oc_seo_url
WHERE keyword = 'dohlyad-za-volossyam' AND store_id = '0'

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

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

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

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

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

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

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

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

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

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

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

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '59'

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_description_seo pds ON (p.product_id = pds.product_id AND pds.language_id = '4')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '59' GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC,p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,12

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '4442' 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 = 4442 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=1333 AND ovd.language_id='4'
ORDER BY pocov.id ASC

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

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

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

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

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

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '4442' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '5224' 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 = 5224 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=834 AND ovd.language_id='4'
ORDER BY pocov.id ASC

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

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

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

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

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

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

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

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

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '5224' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

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

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '5217' 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 = 5217 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=40 AND ovd.language_id='4'
ORDER BY pocov.id ASC

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

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

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

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

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

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

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

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

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '5217' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

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

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '5223' 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 = 5223 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=837 AND ovd.language_id='4'
ORDER BY pocov.id ASC

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

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

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

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

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

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

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

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

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '5223' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

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

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '5218' 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 = 5218 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=831 AND ovd.language_id='4'
ORDER BY pocov.id ASC

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

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

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

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

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

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

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

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

SELECT *, ovd.name AS ovd_name, od.name AS od_name, o.sort_order as o_sort_order, ov.sort_order as ov_sort_order
FROM `oc_product_options_combinations` poc
INNER JOIN `oc_product_options_combinations_option_values` pocov ON (poc.id=pocov.combination_id)
INNER JOIN `oc_option_value` ov ON (pocov.option_value_id=ov.option_value_id)
INNER JOIN `oc_option_value_description` ovd ON (ov.option_value_id=ovd.option_value_id)
INNER JOIN `oc_option` o ON (pocov.option_id=o.option_id)
INNER JOIN `oc_option_description` od ON (o.option_id=od.option_id)
WHERE poc.product_id = '5218' AND ovd.language_id='4' AND od.language_id='4' AND (poc.subtract = 0 OR (poc.subtract = 1 AND poc.quantity > 0) OR 1 = 0)
ORDER BY o.sort_order, pocov.id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT filter_id
FROM oc_category_filter
WHERE category_id = '59'

SELECT *
FROM oc_module
WHERE module_id = '51'

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

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

SELECT *
FROM `oc_mfilter_values`
WHERE `type` = 'attribute' AND `value` IN('99255903e9f71877448c14733e0bdd9b','99255903e9f71877448c14733e0bdd9b','7292b2e5ebab2436930b66d93df0d050','aa54c91886ce80efb12f61e6ae12230b','ce5c0a6a52e41199901f7ed32fda149f','ce5c0a6a52e41199901f7ed32fda149f','aa5064cd5528262d2010f05cdf739891','5f2e71cf6159a21603b05acc75e876fa','5f2e71cf6159a21603b05acc75e876fa','9d48d39dd8a627061257aeff267633b4','f654b87d2d277ecc2416637dfd6c95e8','c746996cfd604b42e7de019c01b2994e','c746996cfd604b42e7de019c01b2994e','09e617e6c2933e99c43791e0616016b6','09e617e6c2933e99c43791e0616016b6','9d48d39dd8a627061257aeff267633b4','9d60f04dc5e8e18886108a588519ea3a','55b3c28663fc11e08426a015f8375f0f','aa54c91886ce80efb12f61e6ae12230b','aa54c91886ce80efb12f61e6ae12230b','f654b87d2d277ecc2416637dfd6c95e8','aa54c91886ce80efb12f61e6ae12230b','f654b87d2d277ecc2416637dfd6c95e8','cf945f058cf8836080d6c0eec498da41','dcfe2369455ffa35ae245b7258f50883','7a0ba6b8f4ac2a82e823d64f16403212','aa54c91886ce80efb12f61e6ae12230b','9d48d39dd8a627061257aeff267633b4','9d48d39dd8a627061257aeff267633b4','f654b87d2d277ecc2416637dfd6c95e8','9d48d39dd8a627061257aeff267633b4','f654b87d2d277ecc2416637dfd6c95e8','cf945f058cf8836080d6c0eec498da41','99e80ef5b4f6b21df61934c588e2837c','753b1faebc274b03d93ba0d6dc1962ad','6cf55418780cc954e263a5437084cfc3','92c8c96e4c37100777c7190b76d28233','18e9ee11e9231c956d0ef5804c22972a','43b74c1e1b66797b34cc1249492cb9b8','75fe17d0a80153d4e57862538f2e6fe2','aa54c91886ce80efb12f61e6ae12230b','2804bafea68f88c2bdecde544085d248','8aabf6855a239b77ba77aad04eae1fae','7292b2e5ebab2436930b66d93df0d050','aa54c91886ce80efb12f61e6ae12230b','050b6b89f4f4e1f6965c49acaf9ce1d7','1498c980f34f1228244c77c44b5ff111','9304c59076e5041370acebf75aab5af0','fe5b2187cd84211f244dfe5afd52a56d','d6f428d93e0155f21c673f18c97b0f77','d6f428d93e0155f21c673f18c97b0f77','d6f428d93e0155f21c673f18c97b0f77','1d5254e1f5e84ff219701eceaf4cec4e','d6f428d93e0155f21c673f18c97b0f77','1d5254e1f5e84ff219701eceaf4cec4e','4e60e49034ce8d46b834c98ddddfb436','a09100444761460e40b5b07d686aba37','a09100444761460e40b5b07d686aba37','18e9ee11e9231c956d0ef5804c22972a','a09100444761460e40b5b07d686aba37','18e9ee11e9231c956d0ef5804c22972a','f654b87d2d277ecc2416637dfd6c95e8','a09100444761460e40b5b07d686aba37','f654b87d2d277ecc2416637dfd6c95e8','f654b87d2d277ecc2416637dfd6c95e8','f654b87d2d277ecc2416637dfd6c95e8','c746996cfd604b42e7de019c01b2994e','87847a3d06d82062121dc20569d77f90','8aa043257f3ae4ac94e7bf3ce249143d','ff22d967e3091d85d87014b9dcce65e0','ff22d967e3091d85d87014b9dcce65e0','8aabf6855a239b77ba77aad04eae1fae','ff22d967e3091d85d87014b9dcce65e0','8aabf6855a239b77ba77aad04eae1fae','425898002eb239b7661028435438c18c','ff22d967e3091d85d87014b9dcce65e0','425898002eb239b7661028435438c18c','e51fb264afde4d806ad8cb080f091f21','522294913d027f3d3227ea37641b629a','197fa45d0772fe7c871e94447e905cd9','5b8551de6f055c171438d7cfee62063d','d37e32de3c36aae47eaa7c9dba85d080','5862152fbf131634e245f6e263a2b1b3','09e617e6c2933e99c43791e0616016b6','9d48d39dd8a627061257aeff267633b4','5862152fbf131634e245f6e263a2b1b3','09e617e6c2933e99c43791e0616016b6','9d48d39dd8a627061257aeff267633b4','f654b87d2d277ecc2416637dfd6c95e8','c746996cfd604b42e7de019c01b2994e','41f1db2eaa5409ea8eb495410ae8e56a','f5cd262901883dff68d06b215fb0f28e','ad64dd101919ff6018d94ec0fe313a26','ad64dd101919ff6018d94ec0fe313a26','71a731effc43ac8bab7455c5e4ce9cc5','76da22f0bb3477e6c1579126b540e6b5','d9ba89654f786fa825370ec6196b6cd8','1e413eeb541bc7a743f04eec9796c63b','eb36aa19494d3bfd6289a6ef9ef29bd0','db3f32fe445382471000fed51965dab4','3f2248134ed910bcf17e8b91f7269bed','3f2248134ed910bcf17e8b91f7269bed','387fa7f2a8f22814a0e32b6a00540cbe','71a731effc43ac8bab7455c5e4ce9cc5','8ada2aaf87666bee33ee7e48f4111ad3','c4ac34038d7add324676d278f98ca379','82622e6a7ebe020d01502bebe49b75b7','e95bbaed1e07ecc83ee2b08121d27072','24464786a3bc7a18a093237d35bb8298','540e009b42d0fe414b8036d3891fb510','2ddc460b9e21014c4326f4743df69154','ef8964f5b3dfe693ee41820775594a35','e10178d13d3d77fa4e41b2b806beb879','2da3c827ccabc4855cb9921b4f1addfa','ccbe9a185f7c5e937b01cbdd9e755729','717a3a498d5b15c3c76c5ed4841ef048','a1d1554c047a709d281d0a663642a947','2cd75613a2aa93a0def18cb2fca2c6f4','0195bf3b36f14cafe6a3f9ca3252e42a','90fdc93c8a6d98e8306b4027b124a6dc','34f3e3b72f2d22a8990e80605e123882','2eb16c7388f13207fa979bb085a54a2a','91efa9e46e4c6cbb78d9fd0a773cc6d5','6739210fc8d4ed300aa3eaa897e0b569','6739210fc8d4ed300aa3eaa897e0b569','725fccb5239074c3d722c5fae5188856','6739210fc8d4ed300aa3eaa897e0b569','71a731effc43ac8bab7455c5e4ce9cc5','2ef50b4c466304dc6ac77bac8a779971','cefc4f7cbc8c34762e0f76703e7e174e','76b88e7899abb3bfdd4b55b8c52726b0','5b8611653f8d6902853b98cc8f0eb03e','f8a3d79cfb30821264e5c6b8f9777a29','7c120866231a3c7cd6d5bc1f688f6d08','8583cd257d19ef79828fe8f11dacc587','a6b73d7072bc04d5736831dd278748e4','1db6247b1b5343d2383342e5f936dcc9','c2ad21c07984f2ba47de12b7e88766e3','db7e9e6891d33ee2a7879818ad8d4a84','e8153cd01f3a2f78cce151af079c99bf','50e362c3198de02293be78472d013af4','64a5348914f1a848aedf5f6b827b57ba','b47db63c60e30796b137656e5113afe0','bb89a674b72f8b4b2f4ab7956eedf9d5','71a731effc43ac8bab7455c5e4ce9cc5','7c1e9a80f50c2d3f419dd087e4d19d73','b58f9881591aa65d40f7153600a29be0','4607dfdd65b11d076a0d45eb749981a5','9c353765651777a467bb6e799411b28f','eab5c6684f6424321be1c641b3ebefba','8fa726af3ba7a903391de9411d56277f','2e3f25cd18e4b1b0a3829313b8127f00','abad33decd802cbc00593d0224376f84','387fa7f2a8f22814a0e32b6a00540cbe','e95444134783e2d310ad485b9f08cf8f','b53a8fe1c28fff0d4062c5b21795fad3','9efcecbe0fb1598e9368843c6cabcfcc','8540e0227bd648d17cd2be865538adfa','7c9c09f512cdc91392500b119f48f0d6','ed6b48dab752e736b0df8b0c89e64f85','e57c3a85aec304f9e5291cd9604a331d','754227d9a15d3e6b02655559325f868a','ff7934c53930272fa0059d2a3634f246','635c399b4d8c4af7c344385c5ad7635d','8170a218ade76f92b571077f8a38a92e','100113f141687d97a198ef4cc4afb60a','d5ecba92634a8a325f7925d75ad307ca','089602aa18f0f675e87a2d6c3fb46629','b65552b215b32acf5b41dd5f8cc5cfd0','d30973809f2e4238b7eb2bac9241674c','47f143232f2c460cb2d02f0d24ed71b9','eedfc25c7412e7860273f001307332a1','1eb9dab77e9b76316d224425b40cbd7f','f4bac1fe9f56b8914108500b9201dd0e','368e83f98fa8cf2224caf8c0f07102d4','8f21fcdc233ba4078679ca628453d06b','0c28a309ac2df1ed30baeb1e9e3bb02c','71a731effc43ac8bab7455c5e4ce9cc5','b0458c954f1c3b75e7f0a8ab5e3f9bb6','ef6572e4cd58bb39a3f4e82fc64fe9f0','11020c31684c51464925a9c714179856','c4cef4cbb910c02d3838c6374d21e5c2','18cedb337ea347cf3a7e4ee9969312d2','1611e5f3da8f7101c9bfcaf803555b32','71a731effc43ac8bab7455c5e4ce9cc5','0a5d466836e2eab8de99c74e17994c8e','70d52a4b4eff30f260db2baa35a66bea','b2262ae79ece716b6167070311dc1870','8ccfa51fc9b3e4017ecc60c826637c86','abd10d97ece68d1d0717d6818ef7dd2f','7916ac11c7ada5290ae99a499aaf7282','418dc319bc099f17c8c0205f0daa2920','130e8610840021466dfc4f52196e1e46','5611ca367bf9bb5b93d19908bd85218f','98ff8205de9378b99543cafb127a61ef','889d3c8fd731c2cda298d7e2ca7c745d','84eafeec60a91d1a3fa7fffa93a90928','d08d5207f5cb051a54638850d9ac32d7','c4bad561313315a1f152b65cff8c299f','a4cdda758d2e242c6c55129f8f56aeca','2b6bf04da33d82b9ff27c25f1e1d9381','d0031564c3ad37aac6f7dda22a5b977f','b03a1d8cf630858680bf2a13e3053a6b','c734db3ca2ebdad85bde0946c3bc517c','60954a9f31c30ec0a8c3bee6fc5cd882','83562caf59c341be070542af207f4872','7db0b52412fe2294657ff557208e9ef2','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','77697ae621ac10c8d9e9dbd0ca2448a9','4f1aeec160cd547359c1401e5728f47b','4f1aeec160cd547359c1401e5728f47b','4f1aeec160cd547359c1401e5728f47b','dc23338949db1b8e386d4a3d28b44083','4f1aeec160cd547359c1401e5728f47b','6178a84921624c2e6448ecbf8c2af147','4f1aeec160cd547359c1401e5728f47b','68e2f395be1efea0130226d1ef5471d5','4f1aeec160cd547359c1401e5728f47b','f186dd679037456b77af5c5f3e693bc9','4f1aeec160cd547359c1401e5728f47b','8078a3f344c7211aca335cf1f60e2f75','4f1aeec160cd547359c1401e5728f47b','762a2854ea71059f7b26b38b9fdf8cef','65d71225a3f29ab8c607c4d66305bed4','5dd2b55d85e2bf3e782e5f0be252a770','98a6d43861f5218e07d417aa5ffd1424','e3d1d4c17f0647700dc1faf4df0889e4','83562caf59c341be070542af207f4872','83562caf59c341be070542af207f4872','7db0b52412fe2294657ff557208e9ef2','9996e2a448c348522a902e2213645769','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','74f33d96776e9fcca1d69a389e7cf216','661a781a2f737f7e05e687fc33de4306','4d5d6512c8ed93705645bf543e1c00ca','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','83562caf59c341be070542af207f4872','ad8c9dba384d1f4844c7f6a4c349daab','dc23338949db1b8e386d4a3d28b44083','dc23338949db1b8e386d4a3d28b44083','6178a84921624c2e6448ecbf8c2af147','dc23338949db1b8e386d4a3d28b44083','f186dd679037456b77af5c5f3e693bc9','dc23338949db1b8e386d4a3d28b44083','8078a3f344c7211aca335cf1f60e2f75','f71a3899c310db920144abdb6a6e7bf5','da9e6b2d96198a25f805493a43c8e3c4','443a8b6fd54825ce1428b5e197675d08','443a8b6fd54825ce1428b5e197675d08','443a8b6fd54825ce1428b5e197675d08','96dbe03e823f89f042d31a1a19b575fb','2b77d602faefaa02ba7f913c4e991b75','9f27bef0b7ca1b5b422fc851730ebd74','a63a83ab3099d08a6c3a6849ea75f354','6191b9545b2c5a29b894f31408e94276','35400da52aeac41d9c0ea3b19336ba53','fc93ce3dfdf7d94b85c7dd171cc366a1','312b58fa679ce34ef8f0bb95109ac5d2','7565b6e3009d75e484574d2e664e2842','40cebbd097553b84071de59b5e66dc23','02d979075f9e4ea7262450f8df94d710','60c45fd404d20cf44ff82c1671f9ff1d','71828fa20669f9a02003001123114ba6','413f3d33b414f7f5ec3cfacf7b74e4e8','97b41866dd9f6bc19f1c6303bd143ba7','8528fb201ad8b804161636a9e6f594bc','8528fb201ad8b804161636a9e6f594bc','68e2f395be1efea0130226d1ef5471d5','8528fb201ad8b804161636a9e6f594bc','68e2f395be1efea0130226d1ef5471d5','8078a3f344c7211aca335cf1f60e2f75','f64bf294636045c134f458dc1bc04d7e','b7482f165e25a5da2555f61d4897655b','682b7d0975cdc31e11e1034c5a4ad1ae','e7133f4f26cb37254d390888ce3289be','a75b8448699db99a8b365d9fad69c801','6dad6ef2ccb22dbbccba4b88ce6dbf05','920ad8ec11e72888eb481df5560860ee','634c3d6c60712bf83aa54b11ff6787d1','6178a84921624c2e6448ecbf8c2af147','6178a84921624c2e6448ecbf8c2af147','dc23338949db1b8e386d4a3d28b44083','6178a84921624c2e6448ecbf8c2af147','20696844d2be9fc6871babadf4dc1441','6178a84921624c2e6448ecbf8c2af147','f186dd679037456b77af5c5f3e693bc9','6178a84921624c2e6448ecbf8c2af147','f186dd679037456b77af5c5f3e693bc9','762a2854ea71059f7b26b38b9fdf8cef','f8db4810a22e853ed148a1dd7b73d94a','7514b7968488243f7251ff728530fa17','3bc24002672bd6431ee0f4f9d64da892','f97ea3d5be62294882ad3cf78d20ca90','a97efb1fc53831bc4697d206f161f6f6','68e2f395be1efea0130226d1ef5471d5','b03a1d8cf630858680bf2a13e3053a6b','b03a1d8cf630858680bf2a13e3053a6b','2b6bf04da33d82b9ff27c25f1e1d9381','b03a1d8cf630858680bf2a13e3053a6b','0399d38d85db1a002b94f0173c01d1ba','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','ad72c0eb44caf17aba3a7e8c59c24842','b03a1d8cf630858680bf2a13e3053a6b','843a08ec63101520266e7bf542e683c9','b03a1d8cf630858680bf2a13e3053a6b','843a08ec63101520266e7bf542e683c9','2b6bf04da33d82b9ff27c25f1e1d9381','b03a1d8cf630858680bf2a13e3053a6b','843a08ec63101520266e7bf542e683c9','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','843a08ec63101520266e7bf542e683c9','b4e3e87c94ba83bf1926d1e4f389586b','b03a1d8cf630858680bf2a13e3053a6b','843a08ec63101520266e7bf542e683c9','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','843a08ec63101520266e7bf542e683c9','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','2b6bf04da33d82b9ff27c25f1e1d9381','b03a1d8cf630858680bf2a13e3053a6b','2b6bf04da33d82b9ff27c25f1e1d9381','843a08ec63101520266e7bf542e683c9','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','843a08ec63101520266e7bf542e683c9','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','843a08ec63101520266e7bf542e683c9','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','c01fdd8a06d16cc9ca0d889f76e89ff4','74f33d96776e9fcca1d69a389e7cf216','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','83562caf59c341be070542af207f4872','74f33d96776e9fcca1d69a389e7cf216','843a08ec63101520266e7bf542e683c9','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','74f33d96776e9fcca1d69a389e7cf216','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','83562caf59c341be070542af207f4872','2b6bf04da33d82b9ff27c25f1e1d9381','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','74f33d96776e9fcca1d69a389e7cf216','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','74f33d96776e9fcca1d69a389e7cf216','83562caf59c341be070542af207f4872','82bb7cbf178cee6b377cc26f2135619a','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','96dbe03e823f89f042d31a1a19b575fb','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','4d5d6512c8ed93705645bf543e1c00ca','7db0b52412fe2294657ff557208e9ef2','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','96dbe03e823f89f042d31a1a19b575fb','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','7db0b52412fe2294657ff557208e9ef2','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','7db0b52412fe2294657ff557208e9ef2','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','74f33d96776e9fcca1d69a389e7cf216','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','7db0b52412fe2294657ff557208e9ef2','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','96dbe03e823f89f042d31a1a19b575fb','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','ac2211805c704eff095dfb4f4eec8181','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','60954a9f31c30ec0a8c3bee6fc5cd882','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','60954a9f31c30ec0a8c3bee6fc5cd882','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','c01fdd8a06d16cc9ca0d889f76e89ff4','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','83562caf59c341be070542af207f4872','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','74f33d96776e9fcca1d69a389e7cf216','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','74f33d96776e9fcca1d69a389e7cf216','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','74f33d96776e9fcca1d69a389e7cf216','a63a83ab3099d08a6c3a6849ea75f354','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','d7efdd3375880e91e3941aac12a0f7d4','a4cdda758d2e242c6c55129f8f56aeca','a63a83ab3099d08a6c3a6849ea75f354','843a08ec63101520266e7bf542e683c9','b03a1d8cf630858680bf2a13e3053a6b','b4e3e87c94ba83bf1926d1e4f389586b','4d5d6512c8ed93705645bf543e1c00ca','ee560f8efe90324f20c8dff874ca8218','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','b4e3e87c94ba83bf1926d1e4f389586b','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','60954a9f31c30ec0a8c3bee6fc5cd882','a63a83ab3099d08a6c3a6849ea75f354','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','74f33d96776e9fcca1d69a389e7cf216','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','77e0ff75ee0155f92180e79ba5c4f86e','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','4d5d6512c8ed93705645bf543e1c00ca','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','77e0ff75ee0155f92180e79ba5c4f86e','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','77e0ff75ee0155f92180e79ba5c4f86e','96dbe03e823f89f042d31a1a19b575fb','b03a1d8cf630858680bf2a13e3053a6b','77e0ff75ee0155f92180e79ba5c4f86e','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','77e0ff75ee0155f92180e79ba5c4f86e','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','7db0b52412fe2294657ff557208e9ef2','b03a1d8cf630858680bf2a13e3053a6b','7db0b52412fe2294657ff557208e9ef2','83562caf59c341be070542af207f4872','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','7db0b52412fe2294657ff557208e9ef2','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','7db0b52412fe2294657ff557208e9ef2','4d5d6512c8ed93705645bf543e1c00ca','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','7db0b52412fe2294657ff557208e9ef2','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','60954a9f31c30ec0a8c3bee6fc5cd882','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','4d5d6512c8ed93705645bf543e1c00ca','ac2211805c704eff095dfb4f4eec8181','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','96dbe03e823f89f042d31a1a19b575fb','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','a63a83ab3099d08a6c3a6849ea75f354','96dbe03e823f89f042d31a1a19b575fb','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','83562caf59c341be070542af207f4872','d7efdd3375880e91e3941aac12a0f7d4','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','6d3ef39cd233a750b3e429b670df8e06','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','ac2211805c704eff095dfb4f4eec8181','b03a1d8cf630858680bf2a13e3053a6b','443a8b6fd54825ce1428b5e197675d08','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','843a08ec63101520266e7bf542e683c9','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','2b6bf04da33d82b9ff27c25f1e1d9381','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','b4e3e87c94ba83bf1926d1e4f389586b','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','a63a83ab3099d08a6c3a6849ea75f354','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','74f33d96776e9fcca1d69a389e7cf216','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','4d5d6512c8ed93705645bf543e1c00ca','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','77e0ff75ee0155f92180e79ba5c4f86e','b03a1d8cf630858680bf2a13e3053a6b','6d3ef39cd233a750b3e429b670df8e06','ac2211805c704eff095dfb4f4eec8181','b03a1d8cf630858680bf2a13e3053a6b','ac2211805c704eff095dfb4f4eec8181','b03a1d8cf630858680bf2a13e3053a6b','ac2211805c704eff095dfb4f4eec8181','83562caf59c341be070542af207f4872','b03a1d8cf630858680bf2a13e3053a6b','ee560f8efe90324f20c8dff874ca8218','b03a1d8cf630858680bf2a13e3053a6b','ee560f8efe90324f20c8dff874ca8218','2b6bf04da33d82b9ff27c25f1e1d9381','20696844d2be9fc6871babadf4dc1441','20696844d2be9fc6871babadf4dc1441','8528fb201ad8b804161636a9e6f594bc','20696844d2be9fc6871babadf4dc1441','68e2f395be1efea0130226d1ef5471d5','20696844d2be9fc6871babadf4dc1441','f186dd679037456b77af5c5f3e693bc9','40765402859cefe8227e79423d13526c','4444745c02a9a918613b786f6cb3963e','955544f0e9f7c4225764a3c69e2fdb61','26293625754338c570e44eebbb466155','26293625754338c570e44eebbb466155','661a781a2f737f7e05e687fc33de4306','e2381929c8ef8a631ac45ae003795090','f186dd679037456b77af5c5f3e693bc9','f186dd679037456b77af5c5f3e693bc9','8528fb201ad8b804161636a9e6f594bc','f186dd679037456b77af5c5f3e693bc9','68e2f395be1efea0130226d1ef5471d5','f186dd679037456b77af5c5f3e693bc9','20696844d2be9fc6871babadf4dc1441','f186dd679037456b77af5c5f3e693bc9','8078a3f344c7211aca335cf1f60e2f75','8528fb201ad8b804161636a9e6f594bc','f186dd679037456b77af5c5f3e693bc9','8078a3f344c7211aca335cf1f60e2f75','68e2f395be1efea0130226d1ef5471d5','f186dd679037456b77af5c5f3e693bc9','8078a3f344c7211aca335cf1f60e2f75','20696844d2be9fc6871babadf4dc1441','f186dd679037456b77af5c5f3e693bc9','762a2854ea71059f7b26b38b9fdf8cef','f186dd679037456b77af5c5f3e693bc9','762a2854ea71059f7b26b38b9fdf8cef','20696844d2be9fc6871babadf4dc1441','f186dd679037456b77af5c5f3e693bc9','762a2854ea71059f7b26b38b9fdf8cef','20696844d2be9fc6871babadf4dc1441','413f3d33b414f7f5ec3cfacf7b74e4e8','afd7fc79d2451edb086589225a3ccc1a','b7e7dfa0bf43a058752addd1eb1e1f47','4bdf2266d2d934e09e44dc8e213841ce','730a0c7123af6566f29d042e072cf5c5','ae4883ac305c3273dacb5906eafd02b7','2c2853d44b0d8cb21e8b0b2456f38207','8078a3f344c7211aca335cf1f60e2f75','8078a3f344c7211aca335cf1f60e2f75','8528fb201ad8b804161636a9e6f594bc','8078a3f344c7211aca335cf1f60e2f75','68e2f395be1efea0130226d1ef5471d5','0807431ee82f8e5df188778507da63e0','04490493392a913695515278d62b0162','2b1ff5a2befc1f1c899d57b158142319','762a2854ea71059f7b26b38b9fdf8cef','762a2854ea71059f7b26b38b9fdf8cef','20696844d2be9fc6871babadf4dc1441','b4f6c1f0b68cc058cb08d50828c69196','3e1e1bc7793041be9246939cd98f241d','b8824a341a9a18525e6a7e0b0f8789d4','a719f4ab5f07681d0d9fc7343cc01b68','e303c1405b7d4266db2c932f76bcf1fe','3920e60eff6f3475ccec801ca9163328','d6eaae41275d4a84d8b76a7bead3555f') AND ( `language_id` IS NULL OR `language_id` = 4 )

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

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

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(59) 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(59) AND `m2s`.`store_id` = '0' AND `p2s`.`store_id` = '0' GROUP BY `m`.`manufacturer_id`
ORDER BY `m`.`sort_order` ASC, `m`.`name` ASC

SELECT *
FROM `oc_seo_url`
WHERE `query` IN('manufacturer_id=75','manufacturer_id=66','manufacturer_id=108','manufacturer_id=89','manufacturer_id=83','manufacturer_id=114','manufacturer_id=106','manufacturer_id=100','manufacturer_id=118','manufacturer_id=97','manufacturer_id=91','manufacturer_id=77','manufacturer_id=103','manufacturer_id=73','manufacturer_id=74','manufacturer_id=84','manufacturer_id=105','manufacturer_id=71','manufacturer_id=101','manufacturer_id=113','manufacturer_id=104','manufacturer_id=107','manufacturer_id=92','manufacturer_id=72','manufacturer_id=78','manufacturer_id=35','manufacturer_id=96','manufacturer_id=70','manufacturer_id=119','manufacturer_id=81','manufacturer_id=37','manufacturer_id=38','manufacturer_id=39','manufacturer_id=40','manufacturer_id=44','manufacturer_id=43','manufacturer_id=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=56') AND `store_id` = 0 AND `language_id` = '4'

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_mfilter_url_alias`
WHERE `language_id` = 4 AND `store_id` = 0 AND ( `path` = '' OR `path` = 'dohlyad-za-volossyam/shampuny' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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