Invalid query : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
c4.id_skpd_sub, c4.nama_skpd_sub,
c2.id_bidang_pembangunan, c2.na' at line 1
@file : /var/www/e-planningkaltaraprovgoid/part-of-content/planning/low_end/5_view_usulan_kec.php line 150
On Query : SELECT a.*, ,
c4.id_skpd_sub, c4.nama_skpd_sub,
c2.id_bidang_pembangunan, c2.nama_bidang_pembangunan,
,
,
,
a3.id_tahun, a3.tahun, c.*, IFNULL(e.pagu,0) as pagu,
b1.id_urusan, b1.fid_daerah, b1.kode_urusan, b1.nama_urusan,
b2.id_bidang, b2.fid_urusan, b2.kode_bidang, b2.nama_bidang, b2.fid_fungsi,
b3.id_program, b3.fid_bidang, b3.kode_program, b3.nama_program, b3.group_program,
b4.id_kegiatan, b4.fid_program, b4.kode_kegiatan, b4.nama_kegiatan, b4.group_kegiatan, b4.jenis_kegiatan
FROM musrenbang_deskel a
INNER JOIN dm_21_kamus_usulan b ON b.id_kamus_usulan=a.fid_kamus_usulan AND b.sof_delete='0'
INNER JOIN ds_07_status_musrenbang c ON c.id_status_usulan=a.fid_status_usulan
INNER JOIN ds_08_musrenbang_usulan_dari d ON d.id_usulan_dari=a.fid_usulan_dari
INNER JOIN dm_03_tahun a3 ON a3.id_tahun=b.fid_tahun AND a3.sof_delete='0'
INNER JOIN dm_02_tahun_rpjm a2 ON a2.id_rpjm_tahun=a3.fid_rpjm_tahun AND a2.sof_delete='0'
INNER JOIN dm_01_tahun_rpjp a1 ON a1.id_rpjp_tahun=a2.fid_rpjp_tahun AND a1.sof_delete='0'
INNER JOIN dm_10_skpd_sub c4 ON c4.id_skpd_sub=b.fid_skpd AND c4.sof_delete='0'
INNER JOIN dm_09_skpd_induk c3 ON c3.id_skpd_induk=c4.fid_skpd_induk AND c3.dinas='1' AND c3.sof_delete='0'
INNER JOIN dm_08_bidang_pembangunan c2 ON c2.id_bidang_pembangunan=c3.fid_bidang_pembangunan AND c2.sof_delete='0'
INNER JOIN ds_03_group_skpd c1 ON c1.id_group_skpd=c3.fid_group_skpd
INNER JOIN ds_00_daerah c0 ON c0.id_daerah=c3.fid_daerah AND c0.id_daerah='1'
INNER JOIN dtr_1_satcil c5 ON a3.id_tahun=c5.fid_tahun AND c5.fid_skpd_sub=c4.id_skpd_sub AND c5.status_satcil='1' AND c5.sof_delete='0'
INNER JOIN dm_24_rw d3 ON d3.id_rw=a.fid_rw AND d3.sof_delete='0'
INNER JOIN dm_23_kelurahan d2 ON d2.id_kelurahan=d3.fid_kelurahan AND d2.sof_delete='0'
INNER JOIN dm_22_kecamatan d1 ON d1.id_kecamatan=d2.fid_kecamatan AND d1.sof_delete='0'
LEFT JOIN dm_11_pagu_indikatif e ON e.fid_tahun=a3.id_tahun AND e.fid_objek=d1.fid_skpd AND e.fid_jenis_pagu='2' AND e.sof_delete='0'
INNER JOIN dm_07_kegiatan b4 ON b4.id_kegiatan=a.fid_kegiatan AND b4.jenis_kegiatan='1' AND b4.sof_delete='0'
INNER JOIN dm_06_program b3 ON b3.id_program=b4.fid_program AND b3.sof_delete='0'
INNER JOIN dm_05_bidang b2 ON b2.id_bidang=b3.fid_bidang AND b2.sof_delete='0'
INNER JOIN dm_04_urusan b1 ON b1.id_urusan=b2.fid_urusan AND b1.fid_daerah=c0.id_daerah AND b1.sof_delete='0'
WHERE a.id_usulan_low>0 AND a.fid_status_usulan>='6' AND a.fid_kegiatan!='-1' AND a.sof_delete='0' AND a.id_usulan_low='' LIMIT 0,1
Invalid query : Table 'egov2018.dm_22_kecamatan' doesn't exist
@file : /var/www/e-planningkaltaraprovgoid/part-of-content/planning/low_end/5_view_usulan_kec.php line 189
On Query : SELECT c5.*
FROM dm_22_kecamatan c5
INNER JOIN dm_10_skpd_sub c4 ON c4.id_skpd_sub=c5.fid_skpd AND c4.sof_delete='0'
INNER JOIN dm_09_skpd_induk c3 ON c3.id_skpd_induk=c4.fid_skpd_induk AND c3.dinas='0' AND c3.sof_delete='0'
INNER JOIN dm_08_bidang_pembangunan c2 ON c2.id_bidang_pembangunan=c3.fid_bidang_pembangunan AND c2.sof_delete='0'
INNER JOIN ds_03_group_skpd c1 ON c1.id_group_skpd=c3.fid_group_skpd
INNER JOIN ds_00_daerah c0 ON c0.id_daerah=c3.fid_daerah AND c0.id_daerah='1'
WHERE c5.id_kecamatan>0 AND c5.sof_delete='0'
ORDER BY c5.kode_kecamatan, c5.nama_kecamatan
Invalid query : Table 'egov2018.dm_23_kelurahan' doesn't exist
@file : /var/www/e-planningkaltaraprovgoid/part-of-content/planning/low_end/5_view_usulan_kec.php line 209
On Query : SELECT c5.kode_kecamatan, c6.*
FROM dm_23_kelurahan c6
INNER JOIN dm_22_kecamatan c5 ON c5.id_kecamatan=c6.fid_kecamatan AND c5.sof_delete='0'
INNER JOIN dm_10_skpd_sub c4 ON c4.id_skpd_sub=c5.fid_skpd AND c4.sof_delete='0'
INNER JOIN dm_09_skpd_induk c3 ON c3.id_skpd_induk=c4.fid_skpd_induk AND c3.dinas='0' AND c3.sof_delete='0'
INNER JOIN dm_08_bidang_pembangunan c2 ON c2.id_bidang_pembangunan=c3.fid_bidang_pembangunan AND c2.sof_delete='0'
INNER JOIN ds_03_group_skpd c1 ON c1.id_group_skpd=c3.fid_group_skpd
INNER JOIN ds_00_daerah c0 ON c0.id_daerah=c3.fid_daerah AND c0.id_daerah='1'
WHERE c6.id_kelurahan>0 AND c6.jenis_kelurahan='Non-Kolektif' AND c6.sof_delete='0'
ORDER BY c5.kode_kecamatan, c5.nama_kecamatan, c6.kode_kelurahan, c6.nama_kelurahan