ENDEREÇO, Centro
Taió - SC - Cep: 89190-000
Fone: (47) 3562-2828
[ Ocultar Dados ]
select A.* from gedoc_tab_007 A LEFT join gedoc_tab_091 B on (B.CODIGO=A.ARQTEXTO and A.CNPJ=B.CNPJ and B.AUTOR like '%VALDECIR JOÃO DA CRUZ (CAPILÉ)%') where A.CNPJ='79372660000153' and (GERADO is null or GERADO='') and A.DATA<>'0000-00-00' and A.DATA is not null and (A.AUTOR like '%VALDECIR JOÃO DA CRUZ (CAPILÉ)%' or (B.AUTOR like '%VALDECIR JOÃO DA CRUZ (CAPILÉ)%')) order by A.DATA desc, CAST(SUBSTRING(numero, 1,5) as signed integer) desc limit 0, 10