QUERY: SELECT SQL_CALC_FOUND_ROWS TID,SET_DATE ,WEEKDAY(SET_DATE) as date_name,
(SELECT CURDATE() - INTERVAL (WEEKDAY(CURDATE())+1) DAY) AS date_interval1,
DATE_ADD((SELECT CURDATE() - INTERVAL (WEEKDAY(CURDATE())+1)DAY),INTERVAL 7 DAY) AS date_inteval2,
R_TITLE, R_TITLE_DESC, R_DESC, R_PIC , INSERT_DATE FROM t_renungan
WHERE R_STATUS='Y' AND SET_DATE <
(SELECT DATE_ADD((SELECT CURDATE() - INTERVAL (WEEKDAY(CURDATE())+1)DAY),INTERVAL 7 DAY))
ORDER BY SET_DATE DESC LIMIT 1319.5,7
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 '1319.5,7' at line 7