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