Beverage Dispenser In The Shape Of Gasoline Pump, Serving Container 1lt For Drinks, Beer, Wine, Soft Drinks, Cocktails, Cocktail Fuel Up Bar Butler Liquor Pump

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 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 = '223' AND cd.language_id = '2' 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 = '1549' AND cd.language_id = '2' 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 = '1708' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

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 = '13738' 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` = '11095' AND `high` = '11149'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '11602'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '11822'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '11828'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '11843'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '12474'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '12550'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11095' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '11602'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '11822'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '11828'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '11843'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '12474'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '12550'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11149' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '11822'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '11828'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '11843'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '12474'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '12550'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '13688'

UPDATE `oc_alsoviewed` SET `number` = '49'
WHERE `id`='1199556'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '13730'

UPDATE `oc_alsoviewed` SET `number` = '67'
WHERE `id`='1199525'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '16370'

UPDATE `oc_alsoviewed` SET `number` = '65'
WHERE `id`='1167054'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11602' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '11828'

UPDATE `oc_alsoviewed` SET `number` = '90'
WHERE `id`='134708'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '11843'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '12474'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '12550'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11822' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '11843'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '12474'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '12550'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11828' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '12474'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '12550'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '16336'

UPDATE `oc_alsoviewed` SET `number` = '58'
WHERE `id`='516441'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '16658'

UPDATE `oc_alsoviewed` SET `number` = '58'
WHERE `id`='516443'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11843' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '12550'

UPDATE `oc_alsoviewed` SET `number` = '72'
WHERE `id`='576177'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '13730'

UPDATE `oc_alsoviewed` SET `number` = '76'
WHERE `id`='1122805'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '13981'

UPDATE `oc_alsoviewed` SET `number` = '37'
WHERE `id`='212248'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '16336'

UPDATE `oc_alsoviewed` SET `number` = '32'
WHERE `id`='189227'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '16658'

UPDATE `oc_alsoviewed` SET `number` = '87'
WHERE `id`='212249'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12474' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '12770'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '12776'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '16336'

UPDATE `oc_alsoviewed` SET `number` = '24'
WHERE `id`='696150'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '16658'

UPDATE `oc_alsoviewed` SET `number` = '58'
WHERE `id`='515703'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12550' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '12776'

UPDATE `oc_alsoviewed` SET `number` = '155'
WHERE `id`='341243'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12770' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '13489'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '13738'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12776' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '13688'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '13730'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '13738'

UPDATE `oc_alsoviewed` SET `number` = '61'
WHERE `id`='1134697'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '13895'

UPDATE `oc_alsoviewed` SET `number` = '40'
WHERE `id`='328074'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '13904'

UPDATE `oc_alsoviewed` SET `number` = '21'
WHERE `id`='986616'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '16336'

UPDATE `oc_alsoviewed` SET `number` = '21'
WHERE `id`='1210325'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '16370'

UPDATE `oc_alsoviewed` SET `number` = '21'
WHERE `id`='1210326'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '16658'

UPDATE `oc_alsoviewed` SET `number` = '20'
WHERE `id`='1210327'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13489' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '13730'

UPDATE `oc_alsoviewed` SET `number` = '133'
WHERE `id`='320262'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '13738'

UPDATE `oc_alsoviewed` SET `number` = '29'
WHERE `id`='893332'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13688' AND `high` = '16712'

UPDATE `oc_alsoviewed` SET `number` = '63'
WHERE `id`='331507'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '13738'

UPDATE `oc_alsoviewed` SET `number` = '49'
WHERE `id`='332430'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '13981'

UPDATE `oc_alsoviewed` SET `number` = '27'
WHERE `id`='1124084'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '16114'

UPDATE `oc_alsoviewed` SET `number` = '110'
WHERE `id`='295035'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13730' AND `high` = '16712'

UPDATE `oc_alsoviewed` SET `number` = '155'
WHERE `id`='892427'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '13895'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '16370'

UPDATE `oc_alsoviewed` SET `number` = '27'
WHERE `id`='407031'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13738' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '13904'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '16370'

UPDATE `oc_alsoviewed` SET `number` = '42'
WHERE `id`='341991'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13895' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13904' AND `high` = '13981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13904' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13904' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13904' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13904' AND `high` = '16370'

UPDATE `oc_alsoviewed` SET `number` = '54'
WHERE `id`='219101'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13904' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13904' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13981' AND `high` = '16040'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13981' AND `high` = '16114'

UPDATE `oc_alsoviewed` SET `number` = '40'
WHERE `id`='695300'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13981' AND `high` = '16336'

UPDATE `oc_alsoviewed` SET `number` = '36'
WHERE `id`='189315'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13981' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13981' AND `high` = '16658'

UPDATE `oc_alsoviewed` SET `number` = '54'
WHERE `id`='212245'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13981' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16040' AND `high` = '16114'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16040' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16040' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16040' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16040' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16114' AND `high` = '16336'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16114' AND `high` = '16370'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16114' AND `high` = '16658'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16114' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16336' AND `high` = '16370'

UPDATE `oc_alsoviewed` SET `number` = '22'
WHERE `id`='1210324'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16336' AND `high` = '16658'

UPDATE `oc_alsoviewed` SET `number` = '113'
WHERE `id`='515893'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16336' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16370' AND `high` = '16658'

UPDATE `oc_alsoviewed` SET `number` = '20'
WHERE `id`='1210328'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16370' AND `high` = '16712'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16658' AND `high` = '16712'

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

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'