Monitor de Acompanhamento - Entrada de Cliente - Novo Fluxo - Sem taxa de adesão

LEGENDA: Convertido | Whatsapp | Aguardando | sem status - (LIMPAR Filtro)

Erro: select a.id_novo_fluxo as id ,a.form_tipo ,a.nome ,a.email ,a.telefone ,a.cnpj_cpf ,a.etapa ,a.data_cadastro ,a.pago_transacao ,a.obs ,c.IdCSNFObs as id_obs ,c.Data as data_ult_parecer ,c.Obs as obs_ult_parecer ,c.Parecer as parecer ,a.data_nasc ,a.cidade ,a.uf ,a.atv1 ,a.atv2 ,a.atv3 ,a.pago ,a.pago_transacao ,a.whatsapp ,a.whatsapp_transacao ,a.sms ,a.sms_transacao ,a.etapa from _cs_tb_novo_fluxo a left join (SELECT max(IdCSNFObs) as id, IdNovoFluxo FROM _cs_tb_novo_fluxo_obs group by IdNovoFluxo) b on a.id_novo_fluxo=b.IdNovoFluxo left join _cs_tb_novo_fluxo_obs c on b.id=c.IdCSNFObs where a.etapa in ('2') and obs='atividade_nao_atendida' ORDER BY a.id_novo_fluxo
Column 'obs' in where clause is ambiguous