Sedang memproses...

Kesalahan

Kesalahan saat mengakses database : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS tahun,(SELECT nmprovinsi FROM provinsi WHERE kdprovinsi=LEFT(kode_bps,2)) ...' at line 1 select count(*) from (SELECT AS tahun,(SELECT nmprovinsi FROM provinsi WHERE kdprovinsi=LEFT(kode_bps,2)) AS provinsi, (SELECT nmkabkota FROM kabkota WHERE kdkabkota=LEFT(kode_bps,4)) AS kabkota, (SELECT nmkecamatan FROM kecamatan WHERE kdkecamatan=LEFT(kode_bps,6)) AS kecamatan,desa, SUM(IF(kode_desa IS NOT NULL,1,0))/COUNT(kode_bps)*100 AS persentase, SUM(IF(stapem=1,1,0)) AS jumlah_kelurahan,SUM(IF(stapem<>1,1,0)) AS jumlah_desa,SUM(IF(kode_desa IS NOT NULL AND stapem=1,1,0)) AS kelurahan_input ,SUM(IF(kode_desa IS NOT NULL AND stapem<>1,1,0)) AS desa_input, SUM(IF(kode_desa IS NOT NULL AND stapem=1,1,0))/SUM(IF(stapem=1,1,0))*100 AS persen_kelurahan, SUM(IF(kode_desa IS NOT NULL AND stapem<>1,1,0))/SUM(IF(stapem<>1,1,0))*100 AS persen_desa FROM master_desa a LEFT JOIN (SELECT * FROM permen WHERE tahun=) b ON a.kode_bps=b.kode_desa WHERE kode_bps LIKE '%' GROUP BY LEFT(kode_bps,2)) nm_sel_esp