Home  >>  Candidate
Hot Jobs
  Job Title / Company
Experience Employment Type Location View

List Recruiter Jobs

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 '2024-05-03' 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

  Job Title / Company
Experience Employment Type Location View