Splat Flexible Tripod 3n1 Blue - SP-3N150

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

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

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

SELECT *
FROM oc_currency

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

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

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

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

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

SELECT *
FROM oc_event

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '10860'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '10870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '11885'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '11893'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '12288'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '12655'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10205' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '10860'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '10870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '11885'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '11893'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '12288'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '12655'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10793' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '10870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '11885'

UPDATE `oc_alsoviewed` SET `number` = '34'
WHERE `id`='369153'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '11893'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '12288'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '12655'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '13049'

UPDATE `oc_alsoviewed` SET `number` = '75'
WHERE `id`='346924'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '13763'

UPDATE `oc_alsoviewed` SET `number` = '48'
WHERE `id`='741786'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10860' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '11885'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '11893'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '12288'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '12655'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10870' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '11893'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '12288'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '12655'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '13763'

UPDATE `oc_alsoviewed` SET `number` = '30'
WHERE `id`='1099288'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11885' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '12288'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '12655'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11893' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '12655'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12288' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '12685'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '12746'

UPDATE `oc_alsoviewed` SET `number` = '104'
WHERE `id`='503722'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12655' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '12746'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12685' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '13049'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12746' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '13618'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '13763'

UPDATE `oc_alsoviewed` SET `number` = '84'
WHERE `id`='741798'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13049' AND `high` = '16981'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '13763'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13618' AND `high` = '16981'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '14691'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13763' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14691' AND `high` = '14760'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14691' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14691' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14691' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14691' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14691' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14691' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14760' AND `high` = '14793'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14760' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14760' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14760' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14760' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14760' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14793' AND `high` = '15722'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14793' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14793' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14793' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14793' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15722' AND `high` = '15771'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15722' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15722' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15722' AND `high` = '16981'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15771' AND `high` = '16192'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15771' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15771' AND `high` = '16981'

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

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

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

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

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16192' AND `high` = '16819'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16192' AND `high` = '16981'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16819' AND `high` = '16981'

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

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'