| 0.1457 |
SELECT ej.title, ej.description, ej.salary, ej.start, ej.job_id, ej.hits, GROUP_CONCAT(ejs.skill_id) as skill_ids, ej.duration, ej.employment_type, ej.vacancy_duration, ej.categories, ej.subcategories, ej.time_added, ej.date_added, ej.last_updated, e.silent, e.deactivate, e.business_name, ej.contact_name, e.logo, e.website, e.rebill_date, e.city, e.country_id, e.zip, (SELECT count(1) FROM employer_inbox ei WHERE ei.employer_id = e.employer_id AND ei.job_id = ej.job_id AND ei.spam !=1) applicants FROM employers e, employer_jobs ej LEFT JOIN `employer_jobs_skills` `ejs` ON `ejs`.`job_id` = `ej`.`job_id` WHERE e.employer_id = ej.employer_id AND ej.job_id IN (1490397,1652678,1641102,1612448,1598752,1562463,1543344,1514708,1500505,1490990,1469995,1468992,1310485,1203686) GROUP BY `ej`.`job_id` ORDER BY FIELD(ej.job_id, 1490397,1652678,1641102,1612448,1598752,1562463,1543344,1514708,1500505,1490990,1469995,1468992,1310485,1203686)
|