Fórum query lenta #60770

select C.CPF, C.NUM_CARTAO, C.NOME, C.ENDER, C.BAIRRO, C.CIDADE, C.UF, C.CEP, 
C.TEL1, C.TEL2, C.TELC, C.TEL1EMP, sum(P.VLRPREST) as vlrprest
from CLIENTES C, PRESTACOES P, LOJAS L  
where C.CPF = P.CPF and P.CODLOJA in (25) and L.COD = P.CODLOJA and P.DTPAGTO is null
and P.DTVENC >= :DTVENCINICIO and P.DTVENC <= :DTVENCFINAL 

and NOT EXISTS (select P2.CODLOJA from PRESTACOES P2 where P2.CODLOJA = P.CODLOJA 
and P2.NUMREF = P.NUMREF and P2.DTPAGTO is null and P2.DTVENC < P.DTVENC)

group by C.CPF, C.NUM_CARTAO, C.NOME, C.ENDER, C.BAIRRO, C.CIDADE, C.UF, C.CEP,
C.TEL1, C.TEL2, C.TELC, C.TEL1EMP order by C.NOME