Customer Service
Shop Phone +34 974 70 55 30
Morning 10-00 - 14.00
Afternoon 16.00-20.00
Falló la consulta solicitada.
SELECT idArticulo, SUM(pedidodetalle.Cantidad) AS Ventas
FROM articulo LEFT JOIN pedidodetalle USING(idArticulo)
WHERE ( (articulo.Mostrar = -1) OR
(articulo.Mostrar = 1 AND (stock(idArticulo) > 0) )
)AND articulo.Categoria = GROUP BY articulo.idArticulo
ORDER BY Ventas DESC
LIMIT 5
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 'GROUP BY articulo.idArticulo
ORDER BY Ventas DESC
LIMIT 5' at line 5