select * from `event` where `approved`=1 and ((date_from>='20221208000000' and date_from<='20221208240000') or (date_to>='20221208000000' and date_to<='20221208240000') or (date_from<='20221208000000' and date_to>='20221208240000')) ORDER BY `views` DESC LIMIT 0 , 4