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 (11509,11581,11625,11621,11620,11644,11626,11667,11652,11654,11656,11650,11651)
ORDER BY view_count DESC
LIMIT 8
01 -
Lecturer In Mathematics
02 -
Lecturer Or Senior Lecturer In...
03 -
Lecturer/senior Lecturer In Ma...
04 -
Postdoctoral Fellow
05 -
Lecturer/senior Lecturer In Mi...
06 -
Lecturer In Classics
07 -
Senior Lecturer - Human Nutrit...
08 -
Lecturer / Senior Lecturer In ...