|
Login / Register |
SELECT distinct j.id,j.featured_job,j.worktype,a.display_name,j.faculty,j.expiry_date,j.add_date,j.title, j.description, j.preview,j.advertiser,j.url,j.add_date,j.expiry_date FROM Jobs j
JOIN Advertiser as a ON a.id = j.advertiser
JOIN JobLocation as jl ON jl.jobid = j.id
JOIN Location as l ON jl.locationid = l.id
JOIN JobType as jt ON jt.jobid = j.id
JOIN Type t ON jt.typeid = t.id
where active=1 AND advertiser != 44 and priority_listing=0 and add_date <= '2010-09-10' and expired!='1' and (jl.locationid = 198) order by id desc, add_date desc LIMIT 0, 10
|
|
|
|
|
|
|
|
|
