|
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-07' and expired!='1' And (locationid=201 or locationid=202 or locationid=189)
|
|
|
|
|
|
|
|
|
