simplify the `current_communities` view
simplify the "new participants" query
remove broken and unused function