Consultar via banco EVENTOS DE CANCELAMENTO sem inserção em Cold?

SELECT DISTINCT
    TJ.ID, TC.NAME, TL.LOGDOCID, +
    REPLICATE('0', 18 - len(ISNULL(CONVERT(VARCHAR(18),DOCUMENTKEY1) ,0))) + CONVERT(VARCHAR(18),DOCUMENTKEY1) +
   REPLICATE('0', 18 - len(ISNULL(CONVERT(VARCHAR(18),DOCUMENTKEY2) ,0))) + CONVERT(VARCHAR(18),DOCUMENTKEY2) +
    REPLICATE('0', 8 - len(ISNULL(CONVERT(VARCHAR(8),DOCUMENTKEY3) ,0))) + CONVERT(VARCHAR(8),DOCUMENTKEY3) as 'CHAVE DE ACESSO', 
    TL.DOCUMENTNUMBER, TL.CNPJEMIT, TL.SERIE, TL.AGENTID, TL.EMISSIONDATE
FROM TBLOGDOCUMENT TL
    JOIN TBEVENT TE WITH (NOLOCK) ON TL.LOGDOCID = TE.LOGDOCID
    JOIN TBNDDJOB TJ WITH (NOLOCK) ON TL.JOBID = TJ.ID
    JOIN TBCONCENTRATOR TC WITH (NOLOCK) ON TJ.ID = TC.JOBID
    JOIN TBLOGDOCMESSAGE TM WITH (NOLOCK) ON TL.LOGDOCID = TM.LOGDOCID
WHERE TL.FINALSTATUS = 1 AND TE.COLDED = 0 AND TE.DHREGEVENTO > '2019-12-10 00:00:01.000' AND TL.DOCUMENTDATE < Dateadd (mi, -120, getdate ())
    AND TM.LOGDOCID NOT IN (SELECT DISTINCT LOGDOCID FROM TBLOGDOCMESSAGE WITH (NOLOCK) WHERE MSGCODE = 221)
ORDER BY TL.EMISSIONDATE DESC --Consultar eventos não inseridos em COLD