Error en la consulta limitada: SELECT MIN(pv.PVP) as PVP, a.CODIGO, a.DESCRIPCION, a.DESCRIPCIONINGLES, a.COLORES, a.TALLADO, a.IVA, a.MARCA, a.FAMILIA, IF (pv.PVP = 0, 1, 0) as SIN_PRECIO FROM ARTICULOS a LEFT JOIN PRECIOSVENTA pv ON ( pv.ARTICULO=a.CODIGO ) WHERE a.FAMILIA IN ('tienda') AND a.ESTADO IN ('W','X') AND pv.TARIFA = '1' GROUP BY a.CODIGO ORDER BY SIN_PRECIO ASC, pv.PVP ASC LIMIT -8,8. Mysql dijo: 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 '-8,8' at line 10