QUERY: SELECT, nL.idNoticia, nL.titulo, SUBSTRING(nL.descripcion,1,500) as descripcion, nL.fecha, nL.fechaAlta, nL.portada, (SELECT nombre FROM archivos WHERE idB = nL.idNoticia AND origen=1 AND tipo=1 ORDER BY (Case When posicion Is Null Then 1 Else 0 End), posicion LIMIT 1) as imagen FROM noticiasLanguage nL INNER JOIN noticias no ON WHERE (nL.language=1) AND no.categoria=1 ORDER BY nL.fechaAlta DESC LIMIT -8, 8
ERROR: 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 2