osłona silnika i podłoga nadwozia do PORSCHE 911 kabriolet
wybierz typ samochodu PORSCHE 911 kabriolet:
select p.products_id from products p, products_to_categories_new p2c, stany_products sp, typ_to_products t2p, typ t
where p.products_status = '1' and p2c.categories_id = 100168 and p2c.products_id = p.products_id
and sp.products_id = p.products_id and sp.dostepny = 1 and t.id_modelu = '2075' and t2p.typ_id = t.id_typu and t2p.products_id = p.products_id