T-shirts

SET time_zone = '+00:00'

SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'

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

SET time_zone = '+02:00'

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '55163dd3e7ca899c44c68d9ba9' AND `expire` > '2025-06-02 18:18:04'

SELECT redirect, language_id
FROM oc_url_redirect
WHERE query = 'https://gajcom.si/index.php?_route_=/en/product/t-shirts/fol-kids-iconic-150-t-kids-t-shirt' OR query = '/index.php?_route_=/en/product/t-shirts/fol-kids-iconic-150-t-kids-t-shirt' OR query = '/index.php*' OR (redirect LIKE 'product/product&product_id=%' AND query = '/index.php') OR (redirect LIKE 'product/category&path=%' AND query = '/index.php')

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '/en/product/t-shirts/fol-kids-iconic-150-t-kids-t-shirt' OR `keyword` LIKE '%//en/product/t-shirts/fol-kids-iconic-150-t-kids-t-shirt') AND `store_id` = '0'

SELECT query, language_id
FROM oc_url_absolute
WHERE redirect = 'index.php?_route_=/en/product/t-shirts/fol-kids-iconic-150-t-kids-t-shirt' OR redirect = 'index.php*' LIMIT 1

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'en' OR `keyword` LIKE '%/en') AND `store_id` = '0'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'product' OR `keyword` LIKE '%/product') AND `store_id` = '0'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 't-shirts' OR `keyword` LIKE '%/t-shirts') AND `store_id` = '0'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'fol-kids-iconic-150-t-kids-t-shirt' OR `keyword` LIKE '%/fol-kids-iconic-150-t-kids-t-shirt') AND `store_id` = '0'

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` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
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` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
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` = '1'

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` = '1'

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

SELECT DISTINCT `extension`
FROM `oc_extension`

SELECT *
FROM `oc_startup`
WHERE `status` = '1'
ORDER BY `sort_order` ASC

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '55163dd3e7ca899c44c68d9ba9'

SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_label'

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) 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 ) 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 ) special, pw.viewed as `p.viewed`, if (p.quantity, 1, 0) in_stock
FROM `oc_product` p
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0, 100

SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'admingajcomsi' AND TABLE_NAME = 'oc_journal3_product_sales'

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) 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 ) 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 ) special, pw.viewed as `p.viewed`, if (p.quantity, 1, 0) in_stock , sales
FROM `oc_journal3_product_sales` j3ps
LEFT JOIN `oc_product` p ON (p.product_id = j3ps.product_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' GROUP BY p.product_id
ORDER BY sales DESC, LCASE(pd.name) DESC LIMIT 0, 30

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) 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 ) 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 ) special, pw.viewed as `p.viewed`, if (p.quantity, 1, 0) in_stock
FROM `oc_product` p
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND p.manufacturer_id IN (22) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 99

SELECT *
FROM `oc_event`
WHERE `status` = '1'
ORDER BY `sort_order` ASC

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/category'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/category' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT COUNT(DISTINCT p.`product_id`) AS total
FROM `oc_category_path` cp
LEFT JOIN `oc_product_to_category` p2c ON (cp.`category_id` = p2c.`category_id`)
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_to_store` p2s ON (p.`product_id` = p2s.`product_id`)
WHERE pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0' AND cp.`path_id` = '225'

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_category_path` cp
LEFT JOIN `oc_product_to_category` p2c ON (cp.`category_id` = p2c.`category_id`)
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_to_store` p2s ON (p.`product_id` = p2s.`product_id`)
WHERE pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0' AND cp.`path_id` = '225' GROUP BY p.product_id
ORDER BY p.`sort_order` ASC, LCASE(pd.`name`) ASC

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` = '1') 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` = '1') 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` = '1') 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_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` = '4338' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '3' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '4338' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '4339' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '3' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '4339' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '4882' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '28' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '4882' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '4875' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '28' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '4875' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '5938' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '51' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '5938' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '5918' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '51' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '5918' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14498' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '177' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14498' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14362' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '177' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14362' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14354' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '177' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14354' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3472' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3472' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3474' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3474' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3475' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3475' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3476' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3476' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3477' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3477' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3478' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3478' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3479' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3479' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14479' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14479' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14403' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14403' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3507' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3507' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3508' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3508' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3509' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3509' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3511' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3511' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3512' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3512' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3514' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3514' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3518' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3518' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14486' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14486' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14381' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14381' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14372' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14372' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14405' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14405' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3531' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3531' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3533' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3533' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3534' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3534' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3540' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3540' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3541' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3541' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3544' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3544' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3545' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3545' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '3546' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '15' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '3546' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '11512' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '109' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '11512' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '11909' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '109' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '11909' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14415' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '109' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14415' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14393' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '17' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14393' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '12454' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '6' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '12454' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14522' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '6' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14522' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14429' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '19' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14429' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14402' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '19' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14402' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14343' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'

SELECT *
FROM oc_seo_manufacturer_description d
WHERE manufacturer_id = '19' AND language_id = '1'AND store_id = '0'

SELECT *
FROM oc_product_description d
WHERE product_id = '14343' AND language_id = '1'

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` = '1') 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` = '1') 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` = '1') 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_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` = '14485' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'