wybrany samochód:
Volkswagen Phaeton (3d1, 3d2, 3d3, 3d4, 3d6, 3d7, 3d8, 3d9) 3.6 V6 4motion (2008.11-2016.03) 280km
wskazówka - zaloguj się, aby dodać samochód do swojego profilu...
systemy komfortowe Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9)
Przeszukaj kategorię systemy komfortowe i już teraz zamów poszukiwaną część zamienną do swojego samochodu Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9).
systemy komfortowe Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9) 3.6 V6 4motion (2008.11-2016.03) 280km
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 = 4876 and ( p2c.categories_id = 100618 or p2c.categories_id = 100734 or p2c.categories_id = 100614 or p2c.categories_id = 100863 or p2c.categories_id = 100751 or p2c.categories_id = 100625 or p2c.categories_id = 100620 or p2c.categories_id = 100878 or p2c.categories_id = 100622 or p2c.categories_id = 100623 or p2c.categories_id = 103046 or p2c.categories_id = 100879 or p2c.categories_id = 102012 or p2c.categories_id = 100621 or p2c.categories_id = 100883 or p2c.categories_id = 100882 or p2c.categories_id = 102008 or p2c.categories_id = 100624 or p2c.categories_id = 100880 or p2c.categories_id = 100881 or p2c.categories_id = 100850 or p2c.categories_id = 100619 or p2c.categories_id = 100836 or p2c.categories_id = 102736 or p2c.categories_id = 100616 or p2c.categories_id = 100615 or p2c.categories_id = 100617 or p2c.categories_id = 105578 or p2c.categories_id = 104155 or p2c.categories_id = 105580 or p2c.categories_id = 104156 or p2c.categories_id = 104166 or p2c.categories_id = 105585 or p2c.categories_id = 104161 or p2c.categories_id = 104157 or p2c.categories_id = 104163 or p2c.categories_id = 104167 or p2c.categories_id = 105582 or p2c.categories_id = 104160 or p2c.categories_id = 105586 or p2c.categories_id = 105584 or p2c.categories_id = 104158 or p2c.categories_id = 104159 or p2c.categories_id = 104162 or p2c.categories_id = 104169 or p2c.categories_id = 105588 or p2c.categories_id = 104164 or p2c.categories_id = 104165)
and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6