cleaner query to fetch recent rooms