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 ('1','1BS','1DPP','1PL','1PP','1CCP','1CSP','1FPP','1TUR','1PR','1BPR','1CPD','1ESR','1FPR','1ILU','1LPF','1PAR','1PQP','1RES','1SC','1ECV','1EUV','1HCU','1SCQ','1UVC') 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