Options

WATER PUMP KIT, NEW PULLY INSTALL

WATER PUMP KIT, NEW PULLY INSTALL
[K102119]

WATER PUMP KIT, NEW PULLY INSTALL
205.00EUR
Share Product
Share via E-Mail
Share on Facebook Share on Twitter
Kit contains:

(1) 102119 Pump, Water
(1) 102135 Gasket, Pump Cover
(1) 102143A Waterpump Pulley Aluminum
(1) 102149 Hose, Waterpump
(2) 102153 Hose, Waterpump Upr
(1) 102156 Gasket, Thermostat
(1) 102481 Hose, Heater Pipe
(1) K111171 Intake O-Ring Kit
(6) SP10097 Hose Clamp (102150)
(2) SP10350 Clamp, Hose
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 = '154003' and opa.orders_id = opb.orders_id and opb.products_id != '154003' 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]