reg--------------------
select reg_codigo as codigo,reg_descricao as descricao
from municipios_br_163
join municipios_sdt on mun_br_163_codigo_ibge_7=mun_sdt_codigo_ibge_7
join municipios_ibge on mun_sdt_codigo_ibge_7=mun_ib_codigo_ibge_7
join ufs on mun_ib_uf_sigla=uf_sigla
join regioes on uf_reg_codigo=reg_codigo
group by codigo,descricao
order by descricao
uf--------------------
select uf_sigla as codigo,uf_descricao as descricao
from municipios_br_163
join municipios_sdt on mun_br_163_codigo_ibge_7=mun_sdt_codigo_ibge_7
join municipios_ibge on mun_sdt_codigo_ibge_7=mun_ib_codigo_ibge_7
join ufs on mun_ib_uf_sigla=uf_sigla and uf_reg_codigo like '$_regiao'
group by codigo,descricao
order by descricao
ter--------------------
select ter_codigo as codigo,ter_descricao as descricao
from municipios_br_163
join municipios_sdt on mun_br_163_codigo_ibge_7=mun_sdt_codigo_ibge_7
join territorios on mun_sdt_ter_codigo=ter_codigo
group by codigo,descricao
order by descricao
mun--------------------
select mun_ib_uf_sigla,
case when ter_descricao is null then '-' else ter_descricao end as ter_descricao,
mun_ib_descricao,
case when mun_sa_codigo_ibge_7 is null then '-' else 'X' end as semi_arido,
mun_ib_codigo_ibge_7
from
(select mun_sdt_codigo_ibge_7 as codigo_ibge_7
from municipios_sdt as mun
join (select mun_sdt_ter_codigo
from municipios_semi_arido
join municipios_sdt on mun_sa_codigo_ibge_7=mun_sdt_codigo_ibge_7
group by mun_sdt_ter_codigo
) as ter on mun.mun_sdt_ter_codigo=ter.mun_sdt_ter_codigo
union
select mun_sa_codigo_ibge_7 as codigo_ibge_7
from municipios_semi_arido
) as mun
join municipios_ibge on codigo_ibge_7=mun_ib_codigo_ibge_7
join ufs on mun_ib_uf_sigla=uf_sigla
left join municipios_sdt on codigo_ibge_7=mun_sdt_codigo_ibge_7
left join territorios on mun_sdt_ter_codigo=ter_codigo
left join municipios_semi_arido on codigo_ibge_7=mun_sa_codigo_ibge_7
where uf_reg_codigo like '%s' and uf_sigla like '%s'
order by mun_ib_uf_sigla,ter_descricao,mun_ib_descricao