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