| |
 |
Repuestos o Accesorios de Autos: |
 |
Cilindros Embragues |
 |
|
|
Número OEM: 3140131010 |
|
Código Takora: T120-0584-9 |
|
|
|
| |
Cilindro Embrague Samsung SM3 1.5-1.6
(Nro. de Referencia/OEM: NISSAN 30620-95F0A, SAMSUNG 31401-31010, BREMBO E56033, KAVO PARTS CCS-6505, LPR 3016)
• Samsung Sm3 1.5 2003-2005 QG15DE dohc bencina, 16 Valvulas, 4 Cilindros,
• Samsung Sm3 1.6 2006-2014 QG16DE dohc bencina, 16 Valvulas, 4 Cilindros, |
|
|
|
|
|
|
3024 - Query execution was interrupted, maximum statement execution time exceeded
select p.products_id,
p.products_takora_code,
p.products_model,
p.products_image,
p.products_price,
p.products_multiple_of,
p.products_tax_class_id,
pd.products_name
from orders_products opa, products_description pd, orders_products opb, orders o, products p
where opa.products_id = '35108' and opa.orders_id = opb.orders_id
and opb.products_id != '35108' and opb.products_id = p.products_id
and opb.orders_id = o.orders_id
and p.products_status = '1'
group by p.products_id order
by o.date_purchased desc limit 9
[TEP STOP]
|
