Atenção

Erro ao acessar o banco de dados Unknown column 'E.id_status_evento' in 'where clause' 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')