wybrany samochód:
Volkswagen Phaeton (3d1, 3d2, 3d3, 3d4, 3d6, 3d7, 3d8, 3d9) 3.2 V6 (2002.04-2005.05) 241km
wskazówka - zaloguj się, aby dodać samochód do swojego profilu...
tył pojazdu Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9)
Przeszukaj kategorię tył pojazdu i już teraz zamów poszukiwaną część zamienną do swojego samochodu Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9).
tył pojazdu Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9) 3.2 V6 (2002.04-2005.05) 241km
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 = 101779 or p2c.categories_id = 101745 or p2c.categories_id = 101750 or p2c.categories_id = 101748 or p2c.categories_id = 101751 or p2c.categories_id = 101746 or p2c.categories_id = 101747 or p2c.categories_id = 101752 or p2c.categories_id = 101749 or p2c.categories_id = 101727 or p2c.categories_id = 101729 or p2c.categories_id = 101728 or p2c.categories_id = 101730 or p2c.categories_id = 101735 or p2c.categories_id = 101737 or p2c.categories_id = 101736 or p2c.categories_id = 101738 or p2c.categories_id = 101718 or p2c.categories_id = 101719 or p2c.categories_id = 101720 or p2c.categories_id = 101721 or p2c.categories_id = 101715 or p2c.categories_id = 101716 or p2c.categories_id = 101717 or p2c.categories_id = 101783 or p2c.categories_id = 101711 or p2c.categories_id = 101785 or p2c.categories_id = 101788 or p2c.categories_id = 101787 or p2c.categories_id = 101790 or p2c.categories_id = 101786 or p2c.categories_id = 101789 or p2c.categories_id = 101731 or p2c.categories_id = 101733 or p2c.categories_id = 101732 or p2c.categories_id = 101734 or p2c.categories_id = 103036 or p2c.categories_id = 101708 or p2c.categories_id = 101707 or p2c.categories_id = 101782 or p2c.categories_id = 101781 or p2c.categories_id = 101780 or p2c.categories_id = 101739 or p2c.categories_id = 101741 or p2c.categories_id = 101740 or p2c.categories_id = 101742 or p2c.categories_id = 101722 or p2c.categories_id = 101723 or p2c.categories_id = 101725 or p2c.categories_id = 101724 or p2c.categories_id = 101726 or p2c.categories_id = 101784 or p2c.categories_id = 101710 or p2c.categories_id = 101763 or p2c.categories_id = 101706)
and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6