pasek klinowy do MERCEDES-BENZ KLASA M (W166)

wybierz typ samochodu MERCEDES-BENZ KLASA M (W166):

ML 250 CDI / BLUETEC 4-MATIC (166.004, 166.003) 204 KM(2011.06-2015.12)

ML 350 4-MATIC (166.057) 306 KM(2011.06-2015.12)

ML 350 BLUETEC 4-MATIC (166.024, 166.023) 258 KM(2011.06-2015.02)

ML 350 CDI 4-MATIC (166.023) 231 KM(2011.06-2015.02)

ML 400 4-MATIC (166.056) 333 KM(2013.08-2015.02)

ML 500 4-MATIC (166.073) 408 KM(2012.02-2015.02)

ML 63 AMG 4-MATIC (166.074) 558 KM(2011.11-2015.02)

ML 63 AMG 4-MATIC (166.074) 525 KM(2011.11-2015.02)

select p.products_id from products p, products_to_categories_new p2c, stany_products sp, typ_to_products t2p, typ t where p.products_status = '1' and p2c.categories_id = 100450 and p2c.products_id = p.products_id and sp.products_id = p.products_id and sp.dostepny = 1 and t.id_modelu = '9800' and t2p.typ_id = t.id_typu and t2p.products_id = p.products_id