Error: SELECT ps.DATA_ID,
ps.MEMBER_ID,
ps.COMPANY_NAME,
ps.JOB_TITLE,
ps.JOB_CATEGORY1,
ps.SALARY,
ps.WAGE_SALARY,
ps.SE_WAGE_SALARY,
ps.PROVINCE,
ps.LOCATION_TEXT,
ps.LOCATION,
ps.JOB_COUNTRY,
ps.EXPERIENCE,
ps.EMPLOYMENT_TYPE,
IF(opr.PRIORITY_LISTING IS NULL,'0','1') as valt
FROM recruiter_postjob ps
INNER JOIN order_recruiter_package opr ON opr.MEMBER_ID = ps.MEMBER_ID AND opr.ACTIVE = 1 AND '2025-02-05' BETWEEN opr.START_DATE AND opr.EXPIRE_DATE
INNER JOIN member_detail md ON ps.MEMBER_ID = md.MEMBER_ID
WHERE 1 AND ps.ACTIVE IN(1,2,3) ORDER BY valt DESC,ps.CREATE_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 19