Atenção

Erro ao acessar o banco de dados Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_esculapio_II.E.dt_inicio' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT DATE_FORMAT(E.dt_inicio,'%Y-%m') AS competencia, COUNT(E.cd_paciente) AS qtd_atendimento FROM db_esculapio_II.tb_policlinica_eventos E INNER JOIN db_esculapio_II.tb_policlinica_eventos_emoji EE ON E.id_status_emoji = EE.id_status_emoji WHERE (E.id_status_evento = 5 OR EE.id_status_emoji IN (3,5) ) AND E.cd_paciente <> 0 AND dt_inicio BETWEEN (CURDATE() - INTERVAL 6 MONTH) AND CURDATE() - INTERVAL 1 MONTH GROUP BY DATE_FORMAT(E.dt_inicio,'%m-%Y')