Notice: Error: 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 '-8,8' at line 10
Error No: 1064
SELECT c.nama as company, sc.title as title, wl.nama AS level, wf.nama AS workfunction, DATE_FORMAT(sc.date_add,'%d %M %Y') as tgl,logo_image,ct.nama as city,sc.selection_id FROM `SELECTION_CANDIDAT` sc JOIN COMPANY c ON sc.id_company = c.id and c.isdeleted = 0 JOIN WORKFUNCTION wf ON sc.workfunction = wf.id JOIN WORK_LEVEL wl ON sc.level = wl.id left JOIN CITY ct on c.id_city = ct.id where sc.isdeleted = 0 and ispublish = 1 group by c.nama, sc.title, wl.nama, wf.nama,sc.date_add,logo_image,ct.nama ORDER BY date(`date_add`) DESC limit -8,8 in /var/www/html/system/database/mysql.php on line 50