wybrany samochód:
Audi 80 B2 Sedan (811, 813, 814, 819, 853) 2.2 Quattro (1982.08-1984.07) 136km
wskazówka - zaloguj się, aby dodać samochód do swojego profilu...
smarowanie Audi 80 B2 sedan (811, 813, 814, 819, 853)
Przeszukaj kategorię smarowanie i już teraz zamów poszukiwaną część zamienną do swojego samochodu Audi 80 B2 sedan (811, 813, 814, 819, 853).
smarowanie Audi 80 B2 sedan (811, 813, 814, 819, 853) 2.2 quattro (1982.08-1984.07) 136km
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 = 26 and ( p2c.categories_id = 100474 or p2c.categories_id = 100483 or p2c.categories_id = 100485 or p2c.categories_id = 100488 or p2c.categories_id = 103072 or p2c.categories_id = 100470 or p2c.categories_id = 100479 or p2c.categories_id = 100512 or p2c.categories_id = 100475 or p2c.categories_id = 100491 or p2c.categories_id = 100489 or p2c.categories_id = 100490 or p2c.categories_id = 100472 or p2c.categories_id = 101994 or p2c.categories_id = 100476 or p2c.categories_id = 100494 or p2c.categories_id = 100492 or p2c.categories_id = 100493 or p2c.categories_id = 100885 or p2c.categories_id = 100481 or p2c.categories_id = 100838 or p2c.categories_id = 100477 or p2c.categories_id = 100513 or p2c.categories_id = 100478)
and sp.dostepny = 1 and p.manufacturers_id = m.manufacturers_id and pd.language_id = '19' and gf.Sort = 1 limit 6