Você está aqui: Home › Notícias

# 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tb1.id_noticia' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT tb1.*, tbnoticias_categorias.* FROM (SELECT * FROM tbnoticias ORDER BY data DESC) as tb1 INNER JOIN tbnoticias_categorias ON (tb1.id_categoria = tbnoticias_categorias.id_categoria) WHERE tb1.imagem NOT LIKE '' GROUP BY tb1.id_categoria ORDER BY tb1.data DESC LIMIT 3;