Dunlop Push Up Stand 2 Piece Push Up Stand Blue

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 = '293' 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 = '858' 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 = '892' 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 = '287' 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 = '1718' 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 = '16870' 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` = '10534' AND `high` = '10597'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '11037'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '11367'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '11892'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '12551'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '12821'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '12844'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10534' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '11037'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '11367'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '11892'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '12551'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '12821'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '12844'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10597' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '11367'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '11892'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '12551'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '12821'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '12844'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11037' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '11892'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '12551'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '12821'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '12844'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11367' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '12551'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '12821'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '12844'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11892' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '12821'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '12844'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12551' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '12844'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12821' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '13253'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12844' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '13577'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13253' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '13955'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13577' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '14105'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13955' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '14232'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14105' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '14475'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14232' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '14630'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14475' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '14836'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '15294'

UPDATE `oc_alsoviewed` SET `number` = '68'
WHERE `id`='717930'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14630' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14836' AND `high` = '15294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14836' AND `high` = '15304'

UPDATE `oc_alsoviewed` SET `number` = '45'
WHERE `id`='594095'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14836' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14836' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14836' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14836' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14836' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15294' AND `high` = '15304'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15294' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15294' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15294' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15294' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15294' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15304' AND `high` = '15566'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15304' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15304' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15304' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15304' AND `high` = '16941'

UPDATE `oc_alsoviewed` SET `number` = '86'
WHERE `id`='308491'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15566' AND `high` = '15593'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15566' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15566' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15566' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15593' AND `high` = '15705'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15593' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15593' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15705' AND `high` = '16870'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15705' AND `high` = '16941'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16870' AND `high` = '16941'

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

SHOW TABLES like 'oc_product_to_video'

SHOW TABLES like 'oc_product_to_video_to_description'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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