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.LOCATION_TEXT, ps.LOCATION, ps.JOB_COUNTRY, ps.EXPERIENCE, ps.EMPLOYMENT_TYPE, (SELECT COUNT(DATA_ID) FROM recruiter_countview WHERE DATA_ID = ps.DATA_ID) AS CNT FROM recruiter_postjob ps INNER JOIN order_recruiter_package opr ON opr.MEMBER_ID = ps.MEMBER_ID AND opr.ACTIVE = 1 AND '2024-03-28' BETWEEN opr.START_DATE AND opr.EXPIRE_DATE LEFT JOIN recruiter_countview rc ON ps.DATA_ID = rc.DATA_ID LEFT JOIN job_category jc ON ps.JOB_CATEGORY1 = jc.DATA_ID WHERE jc.SEGMENT_ID = 3 AND ps.ACTIVE IN(1,2,3) GROUP BY ps.DATA_ID ORDER BY ps.UPDATE_TIME DESC,CNT 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