A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 20' at line 29

SELECT jobs.id AS job_id, jobs.company_id, comp.company_name, comp.license_status AS company_license_status, comp.mobile_status AS company_mobile_status, jobs.title, jobs.create_time, jobs.duty, jobs.hits, jobs.create_time, jobs.department_id, cit.city AS city, are.area AS area, sal.title AS salary, edu.title AS education, exp.title AS experience, nat.title AS jobnature FROM yk_company_jobs jobs LEFT JOIN yk_company comp ON comp.company_id = jobs.company_id LEFT JOIN yk_city cit ON cit.city_id = jobs.city_id LEFT JOIN yk_area are ON are.area_id = jobs.area_id LEFT JOIN yk_salary sal ON sal.id = jobs.salary_id LEFT JOIN yk_education edu ON edu.id = jobs.education_id LEFT JOIN yk_experience exp ON exp.id = jobs.experience_id LEFT JOIN yk_jobnature nat ON nat.id = jobs.jobnature_id WHERE jobs.status = 2 AND jobs.industry_id IN (1023) ORDER BY LIMIT 0, 20

Filename: D:/wwwroot/QiYeRenCaiKu/application/controllers/jobs.php

Line Number: 291