wybrany samochód:
Volkswagen Amarok (2ha, 2hb, S1b, S6b, S7a, S7b) 2.0 Bitdi 4motion (2011.11-???) 180km
wskazówka - zaloguj się, aby dodać samochód do swojego profilu...
zawieszenie, wahacze, łożyska kół, stabilizator Volkswagen AMAROK (2HA, 2HB, S1B, S6B, S7A, S7B)
Przeszukaj kategorię zawieszenie, wahacze, łożyska kół, stabilizator i już teraz zamów poszukiwaną część zamienną do swojego samochodu Volkswagen AMAROK (2HA, 2HB, S1B, S6B, S7A, S7B).
zawieszenie, wahacze, łożyska kół, stabilizator Volkswagen AMAROK (2HA, 2HB, S1B, S6B, S7A, S7B) 2.0 BiTDI 4motion (2011.11-???) 180km
select distinct p.products_id, pd.products_name, pd.products_description, p.products_kod_oryginal, p.products_price, p.products_price_2, p.kaucja,
p.products_tax_class_id, gf.thumb, gf.images, m.manufacturers_name from products p, products_description pd, typ_to_products t2p, typ t,
products_to_categories_new p2c, stany_products sp, manufacturers m, grupy_foto_new gf
where p.products_id = pd.products_id and p.products_id = sp.products_id and t2p.products_id = p.products_id and p.products_id = p2c.products_id
and t2p.typ_id = t.id_typu and p.products_id = gf.products_id and t.id_marki = 121 and t.id_modelu = 8636 and ( p2c.categories_id = 100209 or p2c.categories_id = 100735 or p2c.categories_id = 103159 or p2c.categories_id = 100758 or p2c.categories_id = 100213 or p2c.categories_id = 100210 or p2c.categories_id = 100574 or p2c.categories_id = 100596 or p2c.categories_id = 100590 or p2c.categories_id = 100573 or p2c.categories_id = 100577 or p2c.categories_id = 100211 or p2c.categories_id = 100583 or p2c.categories_id = 100581 or p2c.categories_id = 100834 or p2c.categories_id = 100212 or p2c.categories_id = 100586 or p2c.categories_id = 100585 or p2c.categories_id = 100761 or p2c.categories_id = 100208 or p2c.categories_id = 100572 or p2c.categories_id = 100571 or p2c.categories_id = 101837 or p2c.categories_id = 102733 or p2c.categories_id = 100207 or p2c.categories_id = 100588 or p2c.categories_id = 102082 or p2c.categories_id = 100589 or p2c.categories_id = 100587 or p2c.categories_id = 100206 or p2c.categories_id = 100578 or p2c.categories_id = 100580 or p2c.categories_id = 100803 or p2c.categories_id = 100579 or p2c.categories_id = 102250)
and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6