- Informacje
- N-ry oe
- Zamienniki
- Zastosowanie w autach
Zapytaj o produkt
Dodatkowe informacje o produkcie Koło pasowe, wał korbowy 122-02-211 ASHIKA
numery OEM:
TOYOTA | | 13470-0D040 |
TOYOTA | | 13470-22040 |
TOYOTA | | 13470-22041 |
select p.products_kod_oryginal, p.products_status as products_status, p.products_price, p.products_price_2, p.products_tax_class_id, m.manufacturers_name, p.kaucja, s.specials_new_products_price, s.status as special_status, sp.dostepny from products p left join specials s using(products_id) left join stany_products sp using(products_id), manufacturers m
where products_id = '685699'
and p.manufacturers_id = m.manufacturers_id