SELECT * FROM #__jbjobs_job WHERE city='Oxford' and is_active='y' AND expire_date >= '2018-08-14' AND publish_date <= '2018-08-14' AND expire_date <> '0000-00-00 00:00:00' ORDER BY ID DESC LIMIT 10