Rooms tagged with #tickets active within the last 24 hours

(and their last active time)