TOP 8 UNIVERSITY JOBS (by hits)
SELECT DISTINCT j.id as eliminated_job_id
FROM Jobs j
LEFT JOIN JobType jt ON ( j.id = jt.jobid )
JOIN Jobs_Session_Stats js ON ( j.id = js.job_id )
WHERE j.expired!='1'
AND jt.typeid!=526
AND jt.typeid=532
ORDER BY view_count DESC
SELECT distinct j.id, j.title,j.title_slug,a.name as university_name
FROM Jobs j
LEFT JOIN JobType jt ON ( j.id = jt.jobid )
JOIN Jobs_Session_Stats js ON ( j.id = js.job_id )
JOIN Advertiser a on (a.id=j.advertiser)
WHERE j.expired !='1'
AND jt.typeid !=526
AND j.id NOT IN (12170,12184,12174,12191,12267,12294,12298,12301,12304,12279,12284,12306)
ORDER BY view_count DESC
LIMIT 8
01 -
Lecturer/senior Lecturer/assoc...
02 -
Professor In Linguistics
03 -
Lecturer/assistant Lecturer In...
04 -
Associate Professor/professor ...
05 -
Senior Lecturer In Internation...
06 -
Lecturer In Political Science
07 -
Lecturer / Senior Lecturer - C...
08 -
Lecturer In Psychology: Resear...