select 
    	p.*, 
        cpm.id as idCustomerPaymentMethod 
    from Project as p 
    inner join CustomerPaymentMethod as cpm 
    	on cpm.idCustomer=p.idCustomer 
    where p.automaticCharge='1' 
    	and p.cutoff<='2026-05-12' 
        and cpm.status='1' 
        and EXISTS(
            select *
            from Movement as m 
    		where m.idObj=p.id 
            	and m.objType='2' 
    		    and m.registered between '2026-05-07 07:10:42' and '2026-05-12 07:10:42'
          		and m.status='1'
        )
     group by p.id<br>0<br>