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 ('2','2AA','2AAC','2CPQ','2MPA','2DE','2DRC','2DRD','2DRI','2RDE','2DH','2GRI','2ROD','2SOI','2DO','2DCC','2DCP','2RPD','2FA','2FI','2CFR','2FCC','2FDL','2FLM','2LFR','2LG','2OI','2OIC','2OIM','2OIR','2OIS','2PQ','2SQ','2UVA') 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