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,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 (9451)
ORDER BY view_count DESC
LIMIT 8
01 -
Lecturer/senior Lecturer In Sp...
02 -
Lecturer
03 -
Research Officer
04 -
2011 John David Stout Research...
05 -
Lecturer In Statistics
06 -
Veterinary Anaesthesiologist -...
07 -
Lecturer/senior Lecturer In Ac...
08 -
Lecturer