A Database Error Occurred
Error Number: 1064
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 ')
ORDER BY `B`.`tingkat` DESC, `B`.`id_jabatan_fix` ASC' at line 13
SELECT `A`.`nip`, `A`.`tempat_lahir`, `A`.`tgl_lahir`, `A`.`jenis_kelamin`, `A`.`FotoPegawai`, `A`.`FotoFormal`, `A`.`nama_gelar`, `A`.`nama_satker`, `A`.`golongan`, `A`.`pangkat_ruang`, `A`.`agama`, TMT_MAX(A.id_pegawai) AS tmt_jabatan_terakhir, (SELECT link FROM data_lhkpn WHERE id_pegawai = A.id_pegawai AND tahun='2023' LIMIT 1) AS link_lhkpn_tahun1, (SELECT link FROM data_lhkpn WHERE id_pegawai = A.id_pegawai AND tahun='2022' LIMIT 1) AS link_lhkpn_tahun2, (SELECT
CONCAT('
', (SELECT GROUP_CONCAT(CONCAT('- ', `Y`.`NamaTingkatPendidikan`, ' - ', IFNULL('', Z.NamaJurusan), ' ', `X`.`NamaInstansiPendidikan`, ', Tahun Lulus ', `X`.`TahunLulus`, '
') ORDER BY X.TahunLulus ASC SEPARATOR '')
FROM sikep.trans_riwayat_pendidikan AS X
LEFT JOIN sikep.tref_tingkat_pendidikan AS Y ON X.IdTingkatPendidikan = Y.IdRefTingkatPendidikan
LEFT JOIN sikep.tref_jurusan AS Z ON X.IdJurusan = Z.IdJurusan
WHERE X.IdPegawai=A.IdPegawai), '
')) AS riwayat_pendidikan, (SELECT
CONCAT('
', (SELECT GROUP_CONCAT(CONCAT('- ', `X`.`jabatan`, ', ', NAMA_SATKER(X.id_satker), ', Tahun ', YEAR(X.tgl_sk), '
') ORDER BY X.tgl_sk ASC SEPARATOR '')
FROM data_mutasi AS X
WHERE X.id_pegawai=A.IdPegawai), '
')) AS riwayat_pekerjaan, `A`.`jabatan_lengkap` AS `jabatan`
FROM `data_pegawai` AS `A`
LEFT JOIN `master_jabatan_add` AS `B` ON `A`.`id_jabatan` = `B`.`id_jabatan` AND (`A`.`id_unit_kerja` = `B`.`id_unit_kerja` OR `B`.`id_unit_kerja` = 0)
WHERE `A`.`id_status_pegawai` = '1'
AND `A`.`nip` IN ()
ORDER BY `B`.`tingkat` DESC, `B`.`id_jabatan_fix` ASC
Filename: models/Model_share.php
Line Number: 87