AVISO IMPORTANTE: Por la compra de un juego completo llantas (4), se incluirán los aros centradores necesarios para su instalación.
EL TIEMPO DE ENTREGA DE ESTE PRODUCTO SI NO ESTA DISPONIBLE PUEDE SER DE 10 DIAS
METODOS DE PAGO: Transferencia bancaria, Tarjeta, Paypal y Pago Financiado hasta 12 meses. GASTOS DE ENVIO: GRATUITOS (solo peninsula)
Marca: SPARCO WHEELS Referencia: OC-S0Z2903155139
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY rand() limit 4' at line 10
select p.products_id, pa.products_name, p.products_model, p.products_free_shipping, p.products_date_available, p.products_price, p.products_quantity, p.products_tax_class_id, p.products_image
from products_description pa
inner join products p on (p.products_id = pa.products_id)
inner join products_to_categories ptc on ptc.products_id=p.products_id
where language_id = 3
and products_status = 1
and p.products_id != 6982720
and ptc.categories_id =
ORDER BY rand() limit 4