string(1053) "SELECT CONCAT(A.Id,'-',127,'-','cat'), CONCAT( (CASE WHEN coalesce(T.NomeSigla,'') <> '' THEN T.NomeSigla ELSE T.DescTipoArq END),' - ',coalesce(a.Numero,''),'/',Exercicio), UPPER(A.Descricao), Data, NULL, CASE WHEN DATEDIFF(CURDATE(), Data) <= 5 THEN CONCAT('NOVO') ELSE '' END FROM tabarquivos A LEFT JOIN tabcompetencia cp on (A.NComp = cp.IdComp), tabtipoarq T, tabcatarq C WHERE ((A.NTipoArq = T.IdTipoArq) or (A.NTipoArq IS NULL) ) AND ((T.NTipoCat = C.Id) or (T.NTipoCat IS NULL)) AND A.DtDelete IS NULL AND NTipoArq = :cat ORDER BY Data DESC, ABS(Numero) DESC"