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...
nadwozie Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9)
Przeszukaj kategorię nadwozie i już teraz zamów poszukiwaną część zamienną do swojego samochodu Volkswagen PHAETON (3D1, 3D2, 3D3, 3D4, 3D6, 3D7, 3D8, 3D9).
nadwozie 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 = 100743 or p2c.categories_id = 100185 or p2c.categories_id = 100164 or p2c.categories_id = 100166 or p2c.categories_id = 100165 or p2c.categories_id = 100168 or p2c.categories_id = 100739 or p2c.categories_id = 100699 or p2c.categories_id = 100191 or p2c.categories_id = 100155 or p2c.categories_id = 100181 or p2c.categories_id = 100169 or p2c.categories_id = 100537 or p2c.categories_id = 100737 or p2c.categories_id = 100606 or p2c.categories_id = 101504 or p2c.categories_id = 100187 or p2c.categories_id = 104382 or p2c.categories_id = 104812 or p2c.categories_id = 104959 or p2c.categories_id = 103213 or p2c.categories_id = 103214 or p2c.categories_id = 103215 or p2c.categories_id = 103469 or p2c.categories_id = 100219 or p2c.categories_id = 100741 or p2c.categories_id = 100740 or p2c.categories_id = 100742 or p2c.categories_id = 100744 or p2c.categories_id = 100566 or p2c.categories_id = 100745 or p2c.categories_id = 100569 or p2c.categories_id = 100567 or p2c.categories_id = 102346 or p2c.categories_id = 100568 or p2c.categories_id = 100217 or p2c.categories_id = 103132 or p2c.categories_id = 101407 or 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 or p2c.categories_id = 101340 or p2c.categories_id = 101349 or p2c.categories_id = 101350 or p2c.categories_id = 101352 or p2c.categories_id = 101351 or p2c.categories_id = 101345 or p2c.categories_id = 101348 or p2c.categories_id = 101346 or p2c.categories_id = 101347 or p2c.categories_id = 101341 or p2c.categories_id = 101342 or p2c.categories_id = 101344 or p2c.categories_id = 101343 or p2c.categories_id = 101353 or p2c.categories_id = 101356 or p2c.categories_id = 101354 or p2c.categories_id = 101355 or p2c.categories_id = 100746 or p2c.categories_id = 102760 or p2c.categories_id = 100778 or p2c.categories_id = 102414 or p2c.categories_id = 100189 or p2c.categories_id = 102731 or p2c.categories_id = 100192 or p2c.categories_id = 100184 or p2c.categories_id = 101648 or p2c.categories_id = 101650 or p2c.categories_id = 101673 or p2c.categories_id = 101774 or p2c.categories_id = 101679 or p2c.categories_id = 101772 or p2c.categories_id = 101775 or p2c.categories_id = 101675 or p2c.categories_id = 101674 or p2c.categories_id = 101778 or p2c.categories_id = 101777 or p2c.categories_id = 101773 or p2c.categories_id = 101776 or p2c.categories_id = 103064 or p2c.categories_id = 101669 or p2c.categories_id = 101670 or p2c.categories_id = 101671 or p2c.categories_id = 101672 or p2c.categories_id = 101654 or p2c.categories_id = 101653 or p2c.categories_id = 101766 or p2c.categories_id = 101769 or p2c.categories_id = 101768 or p2c.categories_id = 101771 or p2c.categories_id = 101767 or p2c.categories_id = 101770 or p2c.categories_id = 103035 or p2c.categories_id = 101656 or p2c.categories_id = 101659 or p2c.categories_id = 101657 or p2c.categories_id = 101660 or p2c.categories_id = 101658 or p2c.categories_id = 101665 or p2c.categories_id = 101668 or p2c.categories_id = 101666 or p2c.categories_id = 101667 or p2c.categories_id = 101661 or p2c.categories_id = 101662 or p2c.categories_id = 101664 or p2c.categories_id = 101663 or p2c.categories_id = 101655 or p2c.categories_id = 101652 or p2c.categories_id = 101651 or p2c.categories_id = 101649 or p2c.categories_id = 104724 or p2c.categories_id = 101465 or p2c.categories_id = 101468 or p2c.categories_id = 101469 or p2c.categories_id = 101466 or p2c.categories_id = 101467 or p2c.categories_id = 100826 or p2c.categories_id = 101690 or p2c.categories_id = 101700 or p2c.categories_id = 101702 or p2c.categories_id = 101701 or p2c.categories_id = 101703 or p2c.categories_id = 102758 or p2c.categories_id = 101699 or p2c.categories_id = 101694 or p2c.categories_id = 101698 or p2c.categories_id = 101693 or p2c.categories_id = 101692 or p2c.categories_id = 101696 or p2c.categories_id = 101697 or p2c.categories_id = 101695 or p2c.categories_id = 101691 or p2c.categories_id = 101760 or p2c.categories_id = 101705 or 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 or p2c.categories_id = 101765 or p2c.categories_id = 101454 or p2c.categories_id = 100216 or p2c.categories_id = 105577 or p2c.categories_id = 104728)
and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6