Gembird Universal Tablet Stand White

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://greecemart.gr/'

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

SELECT *
FROM `oc_language`
WHERE status = '1'

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 = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1285')
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 = '2'

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 = '2'

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

SELECT *
FROM oc_extension
WHERE `type` = 'openbay'

SELECT *
FROM oc_event

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '4582' AND m2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '11311' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '10837'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216917'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '11060'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216845'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '11311'

INSERT INTO `oc_alsoviewed` SET `low` = '8154', `high`='11311',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '13128'

UPDATE `oc_alsoviewed` SET `number` = '28'
WHERE `id`='935767'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '13493'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216853'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '13759'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216881'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '13852'

UPDATE `oc_alsoviewed` SET `number` = '56'
WHERE `id`='343992'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '13951'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216846'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216847'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216870'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216931'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216848'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216904'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '81'
WHERE `id`='1022047'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216849'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216850'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216851'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '11'
WHERE `id`='1216852'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8154' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216890'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '11060'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216918'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '11311'

INSERT INTO `oc_alsoviewed` SET `low` = '10837', `high`='11311',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '13128'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216943'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '13493'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216919'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '13759'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='358477'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '13852'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216920'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '13951'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216921'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216922'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216923'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '41'
WHERE `id`='930419'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216924'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216925'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216926'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1213111'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216927'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216928'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216929'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10837' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='1216930'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '11311'

INSERT INTO `oc_alsoviewed` SET `low` = '11060', `high`='11311',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '13128'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216944'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '13493'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216854'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '13759'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216882'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '13852'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216862'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '13951'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='1216826'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '13'
WHERE `id`='1216832'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216871'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216932'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='1216827'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216905'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='1216828'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '12'
WHERE `id`='1216838'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='1216829'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='1216830'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='1216831'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11060' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216891'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '13128'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='13128',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '13493'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='13493',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '13759'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='13759',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '13852'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='13852',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '13951'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='13951',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '14120'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='14120',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '14259'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='14259',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '14338'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='14338',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '14710'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='14710',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '15252'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='15252',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '15347'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='15347',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '16065'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='16065',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '16124'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='16124',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '16710'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='16710',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '16721'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='16721',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11311' AND `high` = '16742'

INSERT INTO `oc_alsoviewed` SET `low` = '11311', `high`='16742',`number` = '1', `date_added`=NOW()

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '13493'

UPDATE `oc_alsoviewed` SET `number` = '57'
WHERE `id`='1094451'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '13759'

UPDATE `oc_alsoviewed` SET `number` = '4'
WHERE `id`='431801'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '13852'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216945'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '13951'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216946'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216947'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216948'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216949'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216950'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216951'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216952'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216953'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216954'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216955'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216956'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13128' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '2'
WHERE `id`='1216957'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '13759'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216883'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '13852'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216863'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '13951'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216855'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216856'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216872'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216933'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216857'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216906'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '26'
WHERE `id`='788010'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216858'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216859'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216860'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='1216861'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13493' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216892'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '13852'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='778858'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '13951'

UPDATE `oc_alsoviewed` SET `number` = '10'
WHERE `id`='829015'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216884'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216885'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216934'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216886'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216907'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '74'
WHERE `id`='938959'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='778901'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216887'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216888'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '7'
WHERE `id`='1216889'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13759' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216893'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '13951'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216864'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '35'
WHERE `id`='874139'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216873'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='874752'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216865'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216908'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216866'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '60'
WHERE `id`='778133'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216867'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216868'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='1216869'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13852' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216894'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '14120'

UPDATE `oc_alsoviewed` SET `number` = '14'
WHERE `id`='217510'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216874'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216935'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '15'
WHERE `id`='1216821'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216909'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '15'
WHERE `id`='1216822'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '12'
WHERE `id`='1216839'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '15'
WHERE `id`='1216823'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '15'
WHERE `id`='1216824'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '15'
WHERE `id`='1216825'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13951' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216895'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '14259'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216875'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '9'
WHERE `id`='874759'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '13'
WHERE `id`='1216833'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216910'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '13'
WHERE `id`='1216834'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '12'
WHERE `id`='1216840'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '13'
WHERE `id`='1216835'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '13'
WHERE `id`='1216836'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '13'
WHERE `id`='1216837'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14120' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216896'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '14338'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216936'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '168'
WHERE `id`='262742'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '161'
WHERE `id`='262906'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216876'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216877'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216878'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216879'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '8'
WHERE `id`='1216880'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14259' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216897'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '14710'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216937'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216938'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216939'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216940'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '38'
WHERE `id`='1068774'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '43'
WHERE `id`='772927'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216941'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14338' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '3'
WHERE `id`='1216942'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14710' AND `high` = '15252'

UPDATE `oc_alsoviewed` SET `number` = '161'
WHERE `id`='262915'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14710' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '17'
WHERE `id`='1216814'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14710' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '12'
WHERE `id`='1216841'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14710' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '19'
WHERE `id`='1216811'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14710' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '18'
WHERE `id`='1216812'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14710' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '16'
WHERE `id`='1216817'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14710' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216898'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15252' AND `high` = '15347'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216911'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15252' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216912'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15252' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216913'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15252' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216914'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15252' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216915'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15252' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '5'
WHERE `id`='1216916'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15347' AND `high` = '16065'

UPDATE `oc_alsoviewed` SET `number` = '12'
WHERE `id`='1216842'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15347' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '17'
WHERE `id`='1216815'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15347' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '17'
WHERE `id`='1216816'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15347' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '16'
WHERE `id`='1216818'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15347' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216899'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16065' AND `high` = '16124'

UPDATE `oc_alsoviewed` SET `number` = '12'
WHERE `id`='1216843'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16065' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '52'
WHERE `id`='352420'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16065' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '12'
WHERE `id`='1216844'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16065' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216900'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16124' AND `high` = '16710'

UPDATE `oc_alsoviewed` SET `number` = '18'
WHERE `id`='1216813'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16124' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '16'
WHERE `id`='1216819'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16124' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216901'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16710' AND `high` = '16721'

UPDATE `oc_alsoviewed` SET `number` = '16'
WHERE `id`='1216820'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16710' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216902'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16721' AND `high` = '16742'

UPDATE `oc_alsoviewed` SET `number` = '6'
WHERE `id`='1216903'

SHOW TABLES like 'oc_product_to_video'

SHOW TABLES like 'oc_product_to_video_to_description'

SELECT *
FROM `oc_module`
WHERE `code` = 'como_productlabels'
ORDER BY `module_id`

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '11343' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '10632' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '13201' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '13202' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '12065' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '12062' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '11361' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '12071' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '12070' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '12074' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

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

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

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

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

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '16981' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '16983' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '15875' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '15774' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '14134' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '16124' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '13423' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '15292' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '15291' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '14535' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '15372' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '11594' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '11589' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '11592' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '16126' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '15872' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '14542' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS manu_image, (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 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 = '2') 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 = '2') 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 = '2') 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 = '15874' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'