ERROR ==> Unknown column 'IdTipologias' in 'having clause'
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 , 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('23/02/2012', '%d/%m/%Y') AND TLS_Articulo.DestacadoTipo IS NOT NULL GROUP By TLS_Articulo.IdTLS_Articulo HAVING IdTipologias like '%8%' ORDER By STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y') DESC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\tulesion.com\httpdocs\listados.php on line 261
ERROR ==> Unknown column 'IdTipologias' in 'having clause'
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 , 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('23/02/2012', '%d/%m/%Y') AND TLS_Articulo.DestacadoTipo IS NOT NULL GROUP By TLS_Articulo.IdTLS_Articulo HAVING IdTipologias like '%8%' ORDER By STR_TO_DATE(TLS_Articulo.Fecha, '%d/%m/%Y') DESC LIMIT 0, 6
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\tulesion.com\httpdocs\listados.php on line 383