Options

WATERPUMP INSTALL KIT

WATERPUMP INSTALL KIT
[K111170]

WATERPUMP INSTALL KIT
44.18EUR
Share Product
Share via E-Mail
Share on Facebook Share on Twitter

Kit contains:

(2) 102146 Seal, O Ring
(1) 102149 Hose, Waterpump
(2) 102153 Hose, Waterpump Upr
(6) 102168 Seal, O Ring
(2) 102283 Seal, O Ring
(2) 102284 Gasket, Int Manifold
(1) 102481 Hose, Heater Pipe
(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 = '155002' and opa.orders_id = opb.orders_id and opb.products_id != '155002' 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]