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<='2025-11-27' 
        and cpm.status='1' 
        and EXISTS(
            select *
            from Movement as m 
    		where m.idObj=p.id 
            	and m.objType='2' 
    		    and m.registered between '2025-11-22 23:00:28' and '2025-11-27 23:00:28'
          		and m.status='1'
        )
     group by p.id<br>0<br>