string(1163) "SELECT A.Id, CASE WHEN COALESCE(cp.DescComp, '') <> '' THEN CONCAT(T.DescTipoArq,' - ', COALESCE(cp.DescComp, ''),'/',A.Exercicio) WHEN COALESCE(A.Numero, '') <> '' THEN CONCAT(T.DescTipoArq,' - ',COALESCE(A.Numero, ''),'/' ,A.Exercicio) ELSE CONCAT(COALESCE(DescTipoArq),' - ',A.Exercicio) END, CASE WHEN COALESCE(V.Nome, '') <> '' THEN CONCAT(COALESCE(A.Descricao, ''),' - ',V.Nome) ELSE COALESCE(A.Descricao, '') END, NULL, '' as A, CASE WHEN COALESCE(G.Descricao, '') <> '' THEN CONCAT(' ',DATE_FORMAT(A.Data,'%d/%m/%Y'),' - ', COALESCE(G.Descricao, '')) ELSE CONCAT(' ',DATE_FORMAT(A.Data,'%d/%m/%Y')) END , CASE WHEN DATEDIFF(CURDATE(), A.Data) <= 7 THEN CONCAT('NOVO') ELSE NULL END" string(471) " FROM tabarquivos A LEFT JOIN TabVereador V ON (A.NGestor = V.IdVereador) LEFT JOIN tabcompetencia cp on (A.NComp = cp.IdComp) LEFT JOIN tabogrupopublica G ON(A.NGrupo = G.IdGrupoPublica), tabtipoarq T, tabcatarq C WHERE (A.NTipoArq = T.IdTipoArq) AND (T.NTipoCat = C.Id) AND T.NTipoCat = 3 AND (VSite = 'S' or (VSite IS NULL)) AND A.DtDelete IS NULL " string(38) " ORDER BY A.Data DESC, cp.IdComp DESC"