In my continuing efforts to battle spam, I had set the default profile view to "Members Only". I've set the members template to noindex to remove thin content from Google. The trouble here is that the member page won't render the noindex if it's viewable by members only. I think at this point, my best option would be to reset accounts to viewable by visitors, run the sitemap and have Google deindex any remaining pages from their index.
Is there a mySQL query to set all members to be viewable by visitors?