Digital Precision Scale 1108-2

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 = '1005' 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 = '14531' 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` = '7536' AND `high` = '10049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10068'

UPDATE `oc_alsoviewed` SET `number` = '88'
WHERE `id`='446928'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10889'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10923'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10926'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10930'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10945'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10948'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '11577'

UPDATE `oc_alsoviewed` SET `number` = '78'
WHERE `id`='568008'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7536' AND `high` = '16905'

UPDATE `oc_alsoviewed` SET `number` = '23'
WHERE `id`='1217357'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10068'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10889'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10923'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10926'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10930'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10945'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10948'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '13159'

UPDATE `oc_alsoviewed` SET `number` = '25'
WHERE `id`='652461'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10049' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '10889'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '10923'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '10926'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '10930'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '10945'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '10948'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10068' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '10923'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '10926'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '10930'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '10945'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '10948'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10889' AND `high` = '16905'

UPDATE `oc_alsoviewed` SET `number` = '33'
WHERE `id`='1214316'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '10926'

UPDATE `oc_alsoviewed` SET `number` = '108'
WHERE `id`='110132'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '10930'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '10945'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '10948'

UPDATE `oc_alsoviewed` SET `number` = '66'
WHERE `id`='365071'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10923' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '10930'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '10945'

UPDATE `oc_alsoviewed` SET `number` = '59'
WHERE `id`='739301'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '10948'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10926' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '10945'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '10948'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10930' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '10948'

UPDATE `oc_alsoviewed` SET `number` = '129'
WHERE `id`='110378'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '13159'

UPDATE `oc_alsoviewed` SET `number` = '39'
WHERE `id`='1057974'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10945' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '10979'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '13159'

UPDATE `oc_alsoviewed` SET `number` = '33'
WHERE `id`='1057975'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10948' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '11577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10979' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '12321'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11577' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '12437'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12321' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '13159'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '13461'

UPDATE `oc_alsoviewed` SET `number` = '31'
WHERE `id`='387370'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12437' AND `high` = '16905'

UPDATE `oc_alsoviewed` SET `number` = '23'
WHERE `id`='1217358'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '13217'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13159' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '13461'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13217' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '13480'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13461' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13480' AND `high` = '13746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13480' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13480' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13480' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13480' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13480' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13480' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13746' AND `high` = '14115'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13746' AND `high` = '14531'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13746' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13746' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13746' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13746' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14115' AND `high` = '14531'

UPDATE `oc_alsoviewed` SET `number` = '44'
WHERE `id`='883807'

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14115' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14115' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14115' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14115' AND `high` = '16905'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14531' AND `high` = '15572'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14531' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14531' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14531' AND `high` = '16905'

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15572' AND `high` = '16145'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15572' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15572' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16145' AND `high` = '16312'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16145' AND `high` = '16905'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16312' AND `high` = '16905'

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

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