Artifact W11 + Wireless Gamepad For Ios & Android Black

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 *, 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 = '13699' 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` = '7175' AND `high` = '7535'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '7935'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '8151'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '9869'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '9986'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '11403'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '12435'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '12484'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7175' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '7935'

UPDATE `oc_alsoviewed` SET `number` = '136'
WHERE `id`='494197'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '8151'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '9869'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '9986'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '11403'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '12435'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '12484'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7535' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '8151'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '9869'

UPDATE `oc_alsoviewed` SET `number` = '83'
WHERE `id`='463721'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '9986'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '11403'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '12435'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '12484'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '7935' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '9869'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '9986'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '11403'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '12435'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '12484'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '8151' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '9986'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '11403'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '12435'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '12484'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9869' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '11403'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '12435'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '12484'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '14340'

UPDATE `oc_alsoviewed` SET `number` = '112'
WHERE `id`='1030082'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '9986' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '12435'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '12484'

UPDATE `oc_alsoviewed` SET `number` = '55'
WHERE `id`='584163'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '11403' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '12484'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12435' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '12487'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12484' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '13596'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '12487' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '13635'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '14364'

UPDATE `oc_alsoviewed` SET `number` = '49'
WHERE `id`='834308'

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13596' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '13699'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13635' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '14014'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '13699' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '14340'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14014' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14340' AND `high` = '14345'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14340' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14340' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14340' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14340' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14340' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14340' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14345' AND `high` = '14364'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14345' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14345' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14345' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14345' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14345' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14364' AND `high` = '14432'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14364' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14364' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14364' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14364' AND `high` = '16633'

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14432' AND `high` = '16111'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14432' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14432' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '14432' AND `high` = '16633'

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16111' AND `high` = '16601'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16111' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16111' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16601' AND `high` = '16618'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16601' AND `high` = '16633'

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

SELECT *
FROM `oc_alsoviewed`
WHERE `low` = '16618' AND `high` = '16633'

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

SHOW TABLES like 'oc_product_to_video'

SHOW TABLES like 'oc_product_to_video_to_description'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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