Query para consultar documentos rejeitados por Certificado Expirado

SELECT DISTINCT
    TJ.JOBNAME, TC.EXPIRATIONDATE, TL.DOCUMENTNUMBER, TL.SERIE, TL.CNPJEMIT, TL.EMISSIONDATE, TM.MSGDESCRIPTION
    FROM TBLOGDOCMESSAGE TM WITH (NOLOCK)
    JOIN TBLOGDOCUMENT TL WITH (NOLOCK) ON TM.LOGDOCID = TL.LOGDOCID
    JOIN TBNDDJOB TJ WITH (NOLOCK) ON TL.JOBID = TJ.ID
    JOIN TBCERTIFICATE TC WITH (NOLOCK) ON TJ.CERTIFICATEID = TC.CERTIFICATEID
WHERE TM.MSGCODE = 192 AND TL.FINALSTATUS = 2
ORDER BY TJ.JOBNAME, TL.CNPJEMIT