CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_temporary` (PRIMARY KEY (`product_id`)) SELECT dcp.price, afv2.value AS PriceLevelXPrice, p.product_id, p.manufacturer_id, IF(p.quantity > 0, 6, p.stock_status_id) as stock_status_id, MIN(pd2.price) as discount, MIN(ps.price) as special, tax_p.sum_rate as tax_precent, tax_f.sum_rate as tax_fixed, AVG(rating) AS rating FROM oc_product p LEFT JOIN `oc_af_tax_fixed` tax_f ON p.tax_class_id = tax_f.tax_class_id LEFT JOIN `oc_af_tax_percent` tax_p ON p.tax_class_id = tax_p.tax_class_id INNER JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) INNER JOIN oc_category_path cp ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product_discount pd2 ON (pd2.product_id = p.product_id 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()) AND pd2.customer_group_id = '1') LEFT JOIN oc_product_special ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') LEFT JOIN oc_review r1 ON (r1.product_id = p.product_id AND r1.status = 1) INNER JOIN oc_product_to_store AS p2s ON p2s.product_id = p.product_id AND p2s.store_id = '0' LEFT JOIN dateline_customer_price dcp ON (p.product_id=dcp.product_id AND dcp.quantity=1 AND dcp.customer_id=0)LEFT JOIN oc_product_additional_field_value AS afv2 ON (p.product_id=afv2.product_id)LEFT JOIN oc_mpoints_additional_field_description AS afd2 ON (afv2.additional_field_id=afd2.additional_field_id AND afd2.name='PriceLevel1') WHERE p.date_available <= NOW() AND p.status = 1 AND cp.path_id = '566' GROUP BY p.product_id Light Bars
Griffiths Equipment
You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.
Light Bars

NARVA The all new range of Navigata L.E.D light bars feature advanced Optic Drive(TM) technology, ..

NARVA The all new range of Navigata L.E.D light bars feature advanced Optic Drive(TM) technology, ..

NARVA The all new range of Navigata L.E.D light bars feature advanced Optic Drive(TM) technology, ..

NARVA The all new range of Navigata L.E.D light bars feature advanced Optic Drive(TM) technology, ..

NARVA Extreme performance and reliability with a heavy-duty slimline die-cast and powder coated al..

NARVA Extreme performance and reliability with a heavy-duty slimline die-cast and powder coated al..

NARVA Extreme performance and reliability with a heavy-duty slimline die-cast and powder coated al..