Publicaciones

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 1
SQL ==> SELECT TLS_Articulo.IdTLS_Articulo, TLS_Articulo.Nombre, TLS_Articulo.TituloH1, TLS_Articulo.TituloH2 , TLS_Articulo.Resumen, TLS_Articulo.Descripcion, TLS_Articulo.NomLink, TLS_Articulo.Link , TLS_Articulo.MetaTittle, TLS_Articulo.MetaDescription, TLS_Articulo.MetaKeywords , (SELECT Fichero FROM `TLS_Fichero` WHERE idTLS_Articulo =TLS_Articulo.IdTLS_Articulo AND Borrar IS NULL AND (TRIM(RIGHT(Fichero,3)) LIKE 'jpg' OR TRIM(RIGHT(Fichero,3)) LIKE 'png' OR TRIM(RIGHT(Fichero,4)) LIKE 'jpeg') limit 1) as FOTO , CONCAT_WS(' ', DAYOFMONTH(STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y')), CONCAT( UCASE(SUBSTRING(MONTHNAME(STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y')),1,1)), LCASE(SUBSTRING(MONTHNAME(STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y')),2)) ), YEAR(STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y')) ) AS Fecha FROM ( SELECT TLS_Articulo.*, GROUP_CONCAT(TLS_Tipologia.IdTLS_Tipologia SEPARATOR ', ') AS IdTipologias FROM TLS_Articulo LEFT JOIN TLS_ArticuloTipologia JOIN TLS_Tipologia USING (IdTLS_Tipologia) ON (TLS_ArticuloTipologia.IdTLS_Articulo = TLS_Articulo.IdTLS_Articulo) GROUP By TLS_Articulo.IdTLS_Articulo ) AS TLS_Articulo WHERE TLS_Articulo.Quitar IS NULL AND STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y') BETWEEN STR_TO_DATE('01/01/1970', '%d/%m/%Y') AND STR_TO_DATE('28/05/2023', '%d/%m/%Y') AND ( '1'='0' OR ( 1=1 AND Nombre like '%artrosis%' ) OR ( 1=1 AND TituloH1 like '%artrosis%' ) OR ( 1=1 AND Resumen like '%artrosis%' ) OR ( 1=1 AND Descripcion like '%artrosis%' ) ) GROUP By TLS_Articulo.IdTLS_Articulo ORDER By STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y') DESC LIMIT -8 , 8