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 '-4,4' 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 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 -4,4 in /home/sloki/user/t94436/sites/hrindo.com/www/system/database/mysql.php on line 49