Gembird Ultimate 4-In-1 Gaming Kit Us Layout

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

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

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

SELECT *
FROM oc_currency

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

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

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

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

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

SELECT *
FROM oc_event

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '10874'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '10950'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '10974'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '10983'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '12310'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '12664'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '16713'

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

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

UPDATE `oc_alsoviewed` SET `number` = '85'
WHERE `id`='928169'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9959' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '10874'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '10950'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '10974'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '10983'

UPDATE `oc_alsoviewed` SET `number` = '81'
WHERE `id`='371466'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '12310'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '12664'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10867' AND `high` = '16970'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '10950'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '10974'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '10983'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '12310'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '12664'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '13242'

UPDATE `oc_alsoviewed` SET `number` = '80'
WHERE `id`='1061542'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '13531'

UPDATE `oc_alsoviewed` SET `number` = '52'
WHERE `id`='1043279'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10874' AND `high` = '16970'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '10974'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '10983'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '12310'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '12664'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10950' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '10983'

UPDATE `oc_alsoviewed` SET `number` = '114'
WHERE `id`='111312'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '12310'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '12664'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10974' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '12310'

UPDATE `oc_alsoviewed` SET `number` = '96'
WHERE `id`='1196494'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '12664'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '10983' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '12664'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12310' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '13129'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12664' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '13242'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13129' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '13531'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13242' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '13609'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13531' AND `high` = '16970'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '14138'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13609' AND `high` = '16970'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '14141'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14138' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14141' AND `high` = '14974'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14141' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14141' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14141' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14141' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14141' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14141' AND `high` = '16970'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14974' AND `high` = '15772'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14974' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14974' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14974' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14974' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14974' AND `high` = '16970'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15772' AND `high` = '16073'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15772' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15772' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15772' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '15772' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16073' AND `high` = '16434'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16073' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16073' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16073' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16434' AND `high` = '16570'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16434' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16434' AND `high` = '16970'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16570' AND `high` = '16713'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16570' AND `high` = '16970'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16713' AND `high` = '16970'

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

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

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

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