|
SELECT distinct j.id,j.featured_job,j.expiry_date,j.add_date,j.title, j.title_slug, j.description, j.preview,j.advertiser,j.url,j.add_date,j.expiry_date FROM Jobs j where active=1 and add_date <= '2012-02-06' and expired!='1' order by id desc, add_date desc LIMIT 0, 10
|