|
Login / Register |
select distinct
j.id,
j.featured_job,
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,JobLocation jl
where jl.jobid=j.id and
active=1 and priority_listing=0 and add_date <= '2010-09-06' and expired!='1' And (locationid=187 or locationid=186 or locationid=188 or locationid=199 or locationid=183 or locationid=200 or locationid=194) order by id desc, add_date desc LIMIT 0, 10
|
|
|
|
|
|
|
|
|
