wybrany samochód:
Audi 100 C1 Sedan (801, 803, 805, 807, 811, 813, F104) 1.8 (1971-1974) 85km
wskazówka - zaloguj się, aby dodać samochód do swojego profilu...
przód pojazdu Audi 100 C1 sedan (801, 803, 805, 807, 811, 813, F104)
Przeszukaj kategorię przód pojazdu i już teraz zamów poszukiwaną część zamienną do swojego samochodu Audi 100 C1 sedan (801, 803, 805, 807, 811, 813, F104).
przód pojazdu Audi 100 C1 sedan (801, 803, 805, 807, 811, 813, F104) 1.8 (1971-1974) 85km
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 = 5 and t.id_modelu = 53 and ( 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)
and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6