Caught exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mails.zenvia_id' in 'on clause' (SQL: select 
        COUNT(case when hook.request LIKE '%"SENT"%' then 1 end) AS enviado,
        COUNT(case when hook.request LIKE '%"DELIVERED"%' then 1 end) AS entregue,
        COUNT(case when hook.request LIKE '%"READ"%' then 1 end) AS aberto,
        COUNT(case when hook.request LIKE '%"CLICKED"%' then 1 end) AS clicado, 
        COUNT(case when hook.request LIKE '%"REJECTED"%' then 1 end) AS rejeitado,
        COUNT(case when hook.request LIKE '%"DELETED"%' then 1 end) AS excluido,
        COUNT(case when hook.request LIKE '%"NOT_DELIVERED"%' then 1 end) AS nao_entregue from `listagem_campanhas_sendmails` as `camp` left join `campanhas_emails_sendmails` as `mails` on `mails`.`campanha` = `camp`.`id` left join `web_hook_mensagem_status` as `hook` on `hook`.`request` like CONCAT('%','"',mails.zenvia_id,'"%') where camp.campanha = 'Dia do Consumidor FPT 2023' limit 1)