|
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='research' OR
t.image_slug='fellowships' OR
t.image_slug='junior_graduate_research_positions' OR
t.image_slug='postdoctoral_research_fellow' OR
t.image_slug='research_associate_research_fellow' OR
t.image_slug='research_manager_director' OR
t.image_slug='research_officer_assistant'
)
AND j.expired!=1 AND active = 1 AND priority_listing=0 GROUP BY j.id order by id desc, add_date desc LIMIT 0, 10
|
|
|
|
|
|
|
|
|
