Options

WATER PIPE KIT 5 SPEED

WATER PIPE KIT 5 SPEED
[K118667]

WATER PIPE KIT 5 SPEED
380.00EUR
Share Product
Share via E-Mail
Share on Facebook Share on Twitter

Kit contains:


all pipes for a 5 speed gearbox Delorean


(1) 105992 Front Coolant Pipe, RH
(1) 105988 Front Coolant Pipe, LH
(1) 105990 Coolant 'S' Pipe, RH
(1) 105989 Coolant 'S' Pipe, LH
(1) 100493 Main Coolant Pipe, LH
(1) 105993 Main Coolant Pipe, RH
(1) 101595 Rear Coolant Pipe, LH
(1) 110131 Rear Water Pipe, LH
(1) 105995 Coolant Pipe
(1) 105996 Water pipe rear RH

This product was added to our catalog on Tuesday 27 January, 2009.
BackReviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'DB_DeloreanEU_2334.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '156002' and opa.orders_id = opb.orders_id and opb.products_id != '156002' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]