-- Datas de campanha de sms com contrato assinado/pago tb_pessoa_meutudo:
select
p.num_cpf as cpf ,
p.matricula,
c.personid,
m.campaingid,
m.senton as dataenviosms,
c.contractdate as datacontrato,
cl.loanstatus as statuscontrato
from public.tb_pessoa_meutudo p
inner join public.tb_contrato_meutudo c on c.personid = p.id_person
inner join public.tb_contractloan_meutudo cl on c.id = cl.contractid
inner join public.mailing m on m.cpf = p.num_cpf
where cl.loanstatus in ('SIGNED','CCBSIGNED','PAID');