wybrany samochód:
Volkswagen Phaeton (3d1, 3d2, 3d3, 3d4, 3d6, 3d7, 3d8, 3d9) 420 (2003.05-2016.03) 335km
wskazówka - zaloguj się, aby dodać samochód do swojego profilu...
oświetlenie Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9)
Przeszukaj kategorię oświetlenie i już teraz zamów poszukiwaną część zamienną do swojego samochodu Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9).
oświetlenie Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9) 420 (2003.05-2016.03) 335km
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 = 101420 or p2c.categories_id = 102406 or p2c.categories_id = 101421 or p2c.categories_id = 101422 or p2c.categories_id = 101423 or p2c.categories_id = 101428 or p2c.categories_id = 101429 or p2c.categories_id = 101430 or p2c.categories_id = 101431 or p2c.categories_id = 101411 or p2c.categories_id = 101412 or p2c.categories_id = 101413 or p2c.categories_id = 101414 or p2c.categories_id = 101408 or p2c.categories_id = 101409 or p2c.categories_id = 101410 or p2c.categories_id = 101441 or p2c.categories_id = 101444 or p2c.categories_id = 101443 or p2c.categories_id = 101446 or p2c.categories_id = 101442 or p2c.categories_id = 101445 or p2c.categories_id = 101424 or p2c.categories_id = 101425 or p2c.categories_id = 101426 or p2c.categories_id = 101427 or p2c.categories_id = 101452 or p2c.categories_id = 101415 or p2c.categories_id = 101416 or p2c.categories_id = 101418 or p2c.categories_id = 101417 or p2c.categories_id = 101419 or p2c.categories_id = 101432 or p2c.categories_id = 101434 or p2c.categories_id = 101433 or p2c.categories_id = 101435 or p2c.categories_id = 103118 or p2c.categories_id = 100295)
and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6