grafikal&tekstual - check berkas

desc supersil;

select * from berkas where berkasnomor = 1971 and berkasyear = 2007;
select * from berkasprosedur where berkasid = '25d60af356694c1bbd52e8e0676635f9';
select * from regprosedur where berkasprosedurid = '7d646ac1b8c44287b47a9e6263c343d6';

select * from register where regid = '4d2c4a8d360e4298b169574ba0adb766'; -- HAT
select * from register where regid = '81c3e7a545f64e1ab4495f05f10962bd'; -- SU
select * from register where regid = '137676635fc0482182fa41fc28f7af86'; -- GU

select * from supersil where regsuid = '81c3e7a545f64e1ab4495f05f10962bd'; -- SUPERSIL

select kecamatan.kecanama, desa.desanama, persil.regid, persil.nib, persil.persilarea
from persil, desa, kecamatan
where kecamatan.kecamatanid = desa.kecamatanid
and persil.desaid = desa.desaid
and regid = 'ebc3c4240a724b49b83e046479e4e99a'; -- PERSIL

-- CHECK PERSIL
select kecamatan.kecanama, desa.desanama, persil.regid, persil.nib, persil.persilarea
from persil, desa, kecamatan
where kecamatan.kecamatanid = desa.kecamatanid
and persil.desaid = desa.desaid and NIB = '05928'
order by kecanama, desanama;

-- CHECK PERSIL By NIB
select kecamatan.kecanama, desa.desanama, persil.regid, persil.nib, persil.persilarea
from persil, desa, kecamatan
where kecamatan.kecamatanid = desa.kecamatanid
and persil.desaid = desa.desaid and NIB = &NIB
order by kecanama, desanama;