CARI LUAS HGB BADAN HUKUM

HGB YANG SU-nya GS
---------------------------------------------
select distinct
keca.kecanam,
desa.desanam,
inde.masterpk2,
inde.masterpk3,
decr.decrcodbpn,
decr.decrisudat,
decr.decrexpdat,
shak.shaknam,
gssuold.gssuare
from inde,indedecr,decr,shak,shakinde,
desa,keca,gsht,gssuold
where indedecr.indecod=inde.indecod
and inde.masterpk2="3"
and decr.decrisudat is not null
and decr.decrexpdat is not null
and decr.decrcod=indedecr.decrcod
and shakinde.indecod=inde.indecod
and shak.tsubcod="04"
and shak.shakcod=shakinde.shakcod
and desa.desaco8=inde.masterpk1
and desa.kecacod=keca.kecacod
and gsht.desaco8=desa.desaco8
and gsht.thakcod=inde.masterpk2
and gsht.htanseq=inde.masterpk3
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum
order by 2,4;

HGB YANG SU-nya SU
---------------------------------------------
select distinct
keca.kecanam,
desa.desanam,
inde.masterpk2,
inde.masterpk3,
decr.decrcodbpn,
decr.decrisudat,
decr.decrexpdat,
shak.shaknam,
gssu.gssuare
from inde,indedecr,decr,shak,shakinde,
desa,keca,paht,gssu
where indedecr.indecod=inde.indecod
and inde.masterpk2="3"
and decr.decrisudat is not null
and decr.decrexpdat is not null
and decr.decrcod=indedecr.decrcod
and shakinde.indecod=inde.indecod
and shak.tsubcod="04"
and shak.shakcod=shakinde.shakcod
and desa.desaco8=inde.masterpk1
and desa.kecacod=keca.kecacod
and paht.desaco8=desa.desaco8
and paht.thakcod=inde.masterpk2
and paht.htanseq=inde.masterpk3
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum
order by 2,4;

KECAMATAN|DESA|JENIS HAK(HGB)|NO HAK|NO SK|TGL TERBIK SK|TGL AKHIR SK|NAMA PEMEGANG HAK|LUAS