10 Most Common Words Showing in Posts Closed as Not Constructive

2

Please login or register to vote for this query.

(click on this box to dismiss)

Less than performant query that takes all the words (sort of) that show up in post titles that have been closed a not constructive (I think) and selects the 10 that occur the most frequently. Added a filter for common words, but what it probably needs to do is analyze words that were and were not included in closed posts, then return only the top 10 that had no instances of non-constructive (or below a threshold?) Replace the "TOP 100 PERCENT" with a much smaller number, 1000 took about 40s when I ran it, 100 was about 300ms

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT *
FROM Posts P
  -- INNER JOIN Comments C ON C.PostId = P.Id
WHERE P.Id = 6474113

Enter Parameters

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