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 tglPendaftaran DESC ,tglPendaftaran DESC LIMIT 0,20' at line 17
SELECT SQL_CALC_FOUND_ROWS IDPerkara, klasifikasiPerkara, jenisPerkara, statusAkhir, noPerkara, tglPendaftaran, pihakPertama, pihakKedua, (CASE WHEN IDProses<220 THEN DATEDIFF(CURDATE(),tglPendaftaran)-IFNULL(med.durasi_mediasi,0) ELSE DATEDIFF(tglPutusan,tglPendaftaran)-IFNULL(med.durasi_mediasi,0)END )AS durasi FROM dataumumweb LEFT JOIN (SELECT IDPerkara AS id_perkara, SUM(DATEDIFF(IF(tglLaporan IS NULL,NOW(),tglLaporan),tglMulaiMediasi)) AS durasi_mediasi FROM mediasiweb WHERE IDTahapan = 10 GROUP BY IDPerkara) AS med ON dataumumweb.IDPerkara = med.id_perkara WHERE klasifikasiPerkara IN (9-Ù) ORDER BY tglPendaftaran DESC ,tglPendaftaran DESC LIMIT 0,20
Filename: /home/pnpayaku/public_html/SIPP/models/perkara/perkara_m.php
Line Number: 216