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

WILDCAT This heavy-duty lock clamp is a perfect anti-theft device that will completely immobilise ..

OTHER BRANDS Protect your trailer from theft by installing this trailer lock. Provides security to..

OTHER BRANDS Protect your trailer from theft by installing this trailer lock. Provides security to..

WILDCAT The flexible Wildcat rubber number plate mount has been designed to suit the Narva model 3..

NARVA The 12/24V amber marker lamps are protected from water ingress with a two stage sealing syst..

NARVA Designed from the ground up, the multivolt Model 37 trailer lamp has been engineered for use..

NARVA Designed from the ground up, the multivolt Model 37 trailer license plate lamp has been engi..

NARVA Designed from the ground up, the Model 37 trailer lamp has been engineered for use on boat t..

NARVA Designed from the ground up, the Model 37 trailer lamp has been engineered for use on boat t..

NARVA The Model 37 plug and play trailer plug has a 5 pin extension along with a 1 meter lead...

NARVA The Model 37 plug and play trailer plug has a 2 pin extension along with a 1 meter lead...

NARVA Designed around the popular Model 42 range of rear combination lamps, the Model 41 family bo..

PROJECTA Projecta has released its new Sure Brake Trailer Breakaway Kit, which ensures safety in a..

NARVA Blanking caps to suit Model 37 plug and play marker lamp...