Powertech Set Of Screws With Nuts NETW-0011 For Rack Column, M6 * 16, 20pcs

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 = '383' 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 = '1775' 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 = '1781' 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 = '12698' 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` = '9970' AND `high` = '9985'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10050'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10567'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10842'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10850'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10944'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9970' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10050'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10567'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10842'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10850'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10944'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9985' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10567'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10842'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10850'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10944'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '11882'

UPDATE `oc_alsoviewed` SET `number` = '51'
WHERE `id`='651966'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10050' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10842'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10850'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10944'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '14517'

UPDATE `oc_alsoviewed` SET `number` = '53'
WHERE `id`='953986'

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10567' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '10850'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '10940'

UPDATE `oc_alsoviewed` SET `number` = '89'
WHERE `id`='364588'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '10944'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10842' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '10940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '10944'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '10960'

UPDATE `oc_alsoviewed` SET `number` = '46'
WHERE `id`='1198289'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10850' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '10944'

UPDATE `oc_alsoviewed` SET `number` = '141'
WHERE `id`='110335'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10940' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '10954'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10944' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '10960'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '10990'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10954' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '10990'

UPDATE `oc_alsoviewed` SET `number` = '93'
WHERE `id`='111550'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '10995'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10960' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '10995'

UPDATE `oc_alsoviewed` SET `number` = '93'
WHERE `id`='111580'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10990' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '11882'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10995' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '11891'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11882' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '12294'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11891' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '12471'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12294' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12471' AND `high` = '12623'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12471' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12471' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12471' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12471' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12471' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12471' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12623' AND `high` = '12698'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12623' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12623' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12623' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12623' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12623' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12698' AND `high` = '12940'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12698' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12698' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12698' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12698' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12940' AND `high` = '13481'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12940' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12940' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12940' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13481' AND `high` = '13914'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13481' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13481' AND `high` = '16845'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13914' AND `high` = '14517'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13914' AND `high` = '16845'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14517' AND `high` = '16845'

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

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

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

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'