|
Login / Register |
select distinct
j.id,
j.featured_job,
j.faculty,
j.expiry_date,
j.add_date,
j.worktype,
j.title,
j.description,
j.preview,
j.advertiser,
j.url,
j.add_date,
j.expiry_date
from Jobs j,JobLocation jl
where jl.jobid=j.id and
active=1 and priority_listing=0 and add_date <= '2010-09-10' and expired!='1' And (locationid=195 or locationid=181 or locationid=182 or locationid=192 or locationid=191 or locationid=198 or locationid=185 or locationid=184 or locationid=193 or locationid=190) order by id desc, add_date desc LIMIT 0, 10
|
|
|
|
|
|
|
|
|
