10 Words Likely To Get Post Closed as Non-Constructive - Too Slow

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

Moderators

Q&A for community managers, administrators, and moderators

select * from closereasontypes

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results