SELECT * FROM #__jbjobs_job WHERE city='Delft' and is_active='y' AND expire_date >= '2020-07-07' AND publish_date <= '2020-07-07' AND expire_date <> '0000-00-00 00:00:00' ORDER BY ID DESC LIMIT 10