string(1132) "SELECT CONCAT(A.Id,'-',18,'-','car'), 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 A.NCaracteristica = :car AND NTipoArq IN (SELECT IdTipoArq FROM TabTipoArq WHERE IdTipoArq > 0) ORDER BY Data DESC, ABS(Numero) DESC"