Error: SELECT rp.DATA_ID,
rp.MEMBER_ID,
rp.COMPANY_NAME,
rp.JOB_TITLE,
rp.JOB_CATEGORY1,
rp.WAGE_SALARY,
rp.SE_WAGE_SALARY,
rp.PROVINCE,
rp.LOCATION_TEXT,
rp.LOCATION,
rp.JOB_COUNTRY,
rp.EXPERIENCE,
rp.EMPLOYMENT_TYPE
FROM recruiter_postjob AS rp
INNER JOIN order_recruiter_package as orp ON rp.MEMBER_ID = orp.MEMBER_ID AND '2024-03-29' BETWEEN orp.START_DATE AND orp.EXPIRE_DATE AND orp.ACTIVE = 1
WHERE rp.JOB_CATEGORY1 = 22 AND rp.ACTIVE IN(1,2,3)
ORDER BY rp.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