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

AERPRO This infodapter interface enables the use of factory steering wheel controls, optical parki..

AERPRO This infodapter interface enables the use of factory steering wheel controls, optical parki..

AERPRO This Aerpro Replacement OEM Harness suits your Ford Falcon EA, EB, ED vehicle. It is ideal ..

AERPRO This Aerpro Replacement OEM Harness suits your Hyundai vehicle 1986 - 1991 including Excel ..

AERPRO This Aerpro Replacement OEM Harness suits your Toyota 86, Camry, Celica, Caldina, Blade, Av..

AERPRO This Aerpro Replacement OEM Harness suits your Holden Commodore VR, VS vehicle. It is ideal..

AERPRO This Aerpro Replacement OEM Harness suits your Mitsubishi early model vehicle with 2-plug r..

AERPRO This Aerpro Replacement OEM Harness suits your Mitsubishi late model vehicle 1996 - 2005 wi..

AERPRO This Aerpro Replacement OEM Harness suits various Nissan vehicles 1995-on. It is ideal for ..

AERPRO This Aerpro Replacement OEM Harness suits your Ford Courier, Falcon EF-EL or Mazda B Series..

AERPRO The Aerpro AA53AU02 Amplifier Retention Harness suits Audi active system adaptor suits Audi..

AERPRO This Aerpro Harness plugs into your Ford Falcon AU factory headunit wiring system. Allowing..

AERPRO This Aerpro Harness plugs into your Ford Falcon factory headunit wiring system. Allowing fo..

AERPRO This Aerpro Harness plugs into your Honda Civic, Integra, Legend, Prelude, Accord, CRV and ..

AERPRO This Aerpro Harness plugs into your Hyundai Excel factory headunit wiring system. Allowing ..

AERPRO Allowing for the installation of an aftermarket headunit without the need to remove the fac..

AERPRO Bare wire primary harnesses are designed to plug into your vehicle's factory wiring and giv..

AERPRO This Aerpro Harness plugs into your Holden Commodore VN, VP and Toyota Lexcen VN, VS factor..

AERPRO This Aerpro Harness plugs into your Holden Commodore VT, VU, VX, Monaro V2, Statesman WH an..

AERPRO This Aerpro Harness plugs into your Subaru Forester SF, SG; Impreza GC, GD, GG; and Liberty..

AERPRO Bare wire primary harnesses are designed to plug into your vehicle's factory wiring and giv..

AERPRO This Aerpro Harness plugs into your Mitsubishi Hyundai Excel, Lantra and Sonata factory hea..

AERPRO This Aerpro Harness plugs into your Hyundai Elantra, Getz, Santa Fe, Sonata, Tiburon; Kia C..

AERPRO This Aerpro Harness plugs into your Nissan 350Z, Maxima (Cefiro), Murano (Z50), Navara, Pat..

AERPRO This Aerpro Harness plugs into your Nissan 300ZX, Maxima (Cefiro), Maxima, Navara, Pathfind..

AERPRO This Aerpro Harness plugs into your Ford Courier, Falcon, Festiva, Laser; Mazda 121 (Autoza..

AERPRO Aerpro Patch Leads are custom made to connect your chosen brand of headunit to the Steering..

AERPRO Connect directly from your device's audio outlet using these "AUX" input adaptor harnesses ..

AERPRO Audi A2DP Streaming Interface allowing you to stream music from your mobile device via A2DP..

AERPRO Aerpro USB retention adapters allow the factory OEM USB socket in a vehicle to be retained ..

AERPRO Retain Vehicles USB sockets or replace factory switch panel. Retains OE USB port on select ..

AERPRO Retain Vehicles USB sockets or replace factory switch panel Features USB adapt to suit H..

AERPRO Retain Vehicles USB sockets or replace factory switch panel Features Retains the OE USB ..

AERPRO Universal ISO connecters and extension cables will suit European cars and any of our other ..

AERPRO Aerpro USB retention adapters allow the factory OEM USB socket in a vehicle to be retained ..

AERPRO Aerpro patch leads are custom made to connect your chosen brand of headunit to the steering..

AERPRO Connect directly from your device's audio outlet using these "AUX" input adaptor harnesses ..

AERPRO Retain Vehicles USB sockets or replace factory switch panel. Features Retains the OE USB..

AERPRO Universal ISO connecters and extension cables will suit European cars and any of our other ..

AERPRO Universal ISO connecters and extension cables will suit European cars and any of our other ..

AERPRO This USB adaptor allows you to retain the factory USB port for use with aftermarket stereos..

AERPRO This USB adaptor allows you to retain the factory USB port for use with aftermarket stereos..

AERPRO The Aerpro APP0110 is a Primary Harness designed to plug into your Mitsubishi Galant, L300 ..

AERPRO The primary harness is the harness that plugs into your car's main entertainment system con..

AERPRO The primary harness is the harness that plugs into your car's main entertainment system con..

AERPRO The primary harness is the harness that plugs into your car's main entertainment system con..

AERPRO The primary harness is the harness that plugs into your car's main entertainment system con..

AERPRO The primary harness is the harness that plugs into your car's main entertainment system con..