|
Login / Register |
SELECT distinct
j.id,
j.faculty,
j.expiry_date,
j.add_date,
j.title,
j.description,
j.preview,
j.advertiser,
j.url,
j.featured_job,
j.add_date,
j.expiry_date
FROM
Jobs j JOIN
JobType jt
ON j.id=jt.jobid JOIN
Type t ON jt.typeid=t.id WHERE
(
t.image_slug='deans_and_dept_heads' OR
t.image_slug='director' OR
t.image_slug='managers_exec_managers' OR
t.image_slug='principals_senior_managers' OR
t.image_slug='vice_chancellor'
)
AND j.expired!=1 AND active = 1 AND priority_listing=0 GROUP BY j.id
|
|
|
|
|
|
|
|
|
