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 = '565' GROUP BY p.product_id Interior Lamps
Griffiths Equipment
You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.
Interior Lamps

NARVA This interior lamp is ideal for applications where night vision needs to be preserved. Eg. M..

NARVA This interior lamp is ideal for applications where night vision needs to be preserved,eg. Ma..

NARVA This interior lamp is ideal for applications where night vision needs to be preserved. Eg. M..

NARVA This interior lamp is ideal for applications where night vision needs to be preserved,eg. Ma..

NARVA These sleek and low profile strip lamps feature dual colour SMD technology enablingone lamp ..

NARVA Dual colour with white and red L.E.Ds. Red illumination allows for easy night timenavigation..

NARVA Designed for use in caravans, recreational vehicles and boats, this premium hand raillight p..

NARVA Designed for use in caravan, RV and marine applications, this L.E.D step light providesexcel..

NARVA Designed for use in caravan, RV and marine applications, this L.E.D step light providesexcel..

NARVA Designed for use in caravan, RV and marine applications, this L.E.D step light providesexcel..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, warm ambient light ideal for background illumination. I..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D tape provides a soft, cool white ambient light ideal for backgroundilluminati..

NARVA Flexible L.E.D strip provides superior light output ideal for illuminating large areasaround..

NARVA Flexible L.E.D strip provides superior light output ideal for illuminating large areasaround..

NARVA Flexible L.E.D strip provides superior light output ideal for illuminating large areasaround..