This is a newer query to return the list of words that have the highest ratio of being used in 'closed as non-constructive' vs all posts. Although I've tried two different methods of splitting, the sheer amount of data and my rustiness with SQL optimization is causing all the methods I have tried to timeout, even when doing a pre-query for just words in closed posts.
Currently running most recent 25% of posts and sorting by ratio desc, so words with largest chance of being closed.
Q&A for community managers, administrators, and moderators
select * from closereasontypes