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('
  1. ', `Y`.`NamaTingkatPendidikan`, ' - ', IFNULL('', Z.NamaJurusan), ' ', `X`.`NamaInstansiPendidikan`, ', Tahun Lulus ', `X`.`TahunLulus`, '
  2. ') 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('
  1. ', `X`.`jabatan`, ', ', NAMA_SATKER(X.id_satker), ', Tahun ', YEAR(X.tgl_sk), '
  2. ') 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