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

RAIN X The Rain-X glass cleaner + rain repellent improves wet weather driving visibility and is ea..

RAIN X This glass cleaner removes harsh build-up from windshields and headlights to deliver ultima..

RAIN X The foaming glass cleaner and rain repellent improves wet weather driving visibility and is..

RAIN X Rain-X Windshield Repair Kit helps you minimize the appearance and stop the spread of chips..

RAIN X A specially formulated car wash formula that leaves a spot free shine without the need of h..

RAIN X Watch water bead up and roll away on motorcycle windscreens, goggles, visors and boat winds..

RAIN X This glass cleaner delivers automotive strength cleaning for glass and mirrors leaving a st..

RAIN X Rain-X 2-in-1 Glass Cleaner + Rain Repellent improves wet weather driving visibility and is..

RAIN X Rain-X Glass Water Repellent uses advanced technology that causes water to bead and slide o..

RAIN X Rain-X Bathroom Mirror Anti-Fog uses advanced technology for a superior, long-lasting coati..

RAIN X Rain-X Shower Door X-treme Clean removes harsh build-up on glass shower doors to deliver th..

RAIN X The Rain-X anti-fog prevents interior fogging before the problem begins. Reduces interior f..

RAIN X Over time, headlight lenses become oxidized rendering them hazy and yellow. This causes hea..

RAIN X Over a period of time, plastic headlights become oxidized rendering them hazy and yellow. T..

RAIN X Drive safer in wet weather conditions with Rain-X's Glass Water Repellent. It dramatically ..

RAIN X Drive safer in wet weather conditions with Rain-X's Glass Water Repellent. It dramatically ..

RAIN X Simple to apply - just spray on the windshield or apply to a clean napkin/towel, spread, le..

RAIN X Simply add Rain-X washer fluid additive to water or any windshield washer fluid and apply. ..

RAIN X Rain-X High Foaming Wash & Wax is a specialty car wash that washes and waxes your vehicle i..