ventasenlinea@herrerayherrera.cl(+56) 2 2219 8800
Av. Jorge Alessandri Rodríguez 12667, San Bernardo.

herrerayherrera

Categorias
assignment0
favorite_border
volver
ALAMBRE GALVANIZADO N14 1KG
SKU: 1710062
Cotizar
Error description: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id ORDER BY p.posicion ASC limit 4' at line 1

SELECT pd.id, pd.nombre, p.id, p.marca_id FROM productos p, productos_detalles pd, lineas_productos lp WHERE p.id = pd.producto_id AND lp.producto_id = p.id AND p.publicado = 1 AND lp.categoria_id = GROUP BY p.id ORDER BY p.posicion ASC limit 4