| |
 |
Repuestos o Accesorios de Autos: |
 |
Extremos/ Terminales |
 |
|
|
de Direccion |
|
|
|
Número OEM: 4649031020K0 |
|
Código Takora: T170-0143-4 |
|
|
|
| |
Extremo Direccion Delantero Exterior Izquierdo/Derecho
• Nissan Almera 1.6 2009-2010 QG16DE N16 dohc bencina, 16 Valvulas, 4 Cilindros,
• 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 = '40535' and opa.orders_id = opb.orders_id
and opb.products_id != '40535' 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]
|
