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

  Job Title / Company
Experience Employment Type Location View