Error: SELECT ps.DATA_ID,
ps.MEMBER_ID,
ps.COMPANY_NAME,
ps.JOB_TITLE,
ps.JOB_CATEGORY1,
ps.SALARY,
ps.PROVINCE,
ps.LOCATION_TEXT,
ps.LOCATION,
ps.JOB_COUNTRY,
ps.EXPERIENCE,
ps.EMPLOYMENT_TYPE,
COUNT(rc.DATA_ID) AS CNT
FROM recruiter_postjob ps
INNER JOIN order_recruiter_package as orp ON ps.MEMBER_ID = orp.MEMBER_ID AND '2025-04-04' BETWEEN orp.START_DATE AND orp.EXPIRE_DATE AND ps.ACTIVE IN(1,2,3)
LEFT JOIN recruiter_countview rc ON ps.DATA_ID = rc.DATA_ID
GROUP BY rc.DATA_ID ORDER BY CNT DESC,ps.UPDATE_TIME DESC LIMIT -10,10
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 '-10,10' at line 17