SELECT  REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(P.NumeCelu,'FC',''),'F',''),'CL',''),'TEC',''),'P','') matricula,
        AC.DataAces  AS data_acesso
FROM [Suricato].[suricato].[TbPessoa] P (NOLOCK)
INNER JOIN [suricato].[suricato].[TbColab] C (NOLOCK)
    ON P.IdPessoa = C.IdPessoa
INNER JOIN [Suricato].[suricato].[TbHistoFilia] FI (NOLOCK)
    ON FI.IdColab = C.IdColab
INNER JOIN [Suricato].[suricato].[tbmarcaacess] AC (NOLOCK)
    ON AC.Icard = FI.Icard
INNER JOIN [Suricato].[suricato].[tbtipoacess] TA (NOLOCK)
    ON TA.TipoAces = AC.TipoAces
INNER JOIN ACADEMICO_COLEGIO.dbo.Matricula M (NOLOCK)
    ON CONVERT(VARCHAR(20),M.matricula)+'CL' = P.NumeCelu
WHERE P.NumeCelu LIKE '%CL'
AND M.digito = 'CL'
AND TA.DescTipoAces LIKE '%Acesso Permitido%'
GROUP BY P.NumeCelu,AC.DataAces