| |
 |
Repuestos o Accesorios de Autos: |
 |
Metales de Bielas |
 |
|
|
Número OEM: 1323241910Z0 |
|
Código Takora: T181-0934-4 |
|
|
Stock en bodega: 4 últimas unidades
4545 clientes se han interesado en este repuesto. |
|
|
| |
|
|
| |
Metal de Biela, Std., Samsung Sm3 1.6 2006-2014 (Precio por 1/2 Puño)
• Samsung Sm3 1.5 2003-2008 QG15DE dohc bencina, 16 Valvulas, 4 Cilindros,
• Samsung Sm3 1.6 2005-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 = '38522' and opa.orders_id = opb.orders_id
and opb.products_id != '38522' 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]
|
