SQL: The most N used words per user (speak their language!)

A really cool query, but I’ve noticed some unexpected results.

Words from the Category and Topic tiles are being included in top_words, 1 time for each post made in the topic.

In other words, if the category is “ABC” and the topic is “XYZ” if a member makes 25 posts in various topics in the ABC category including 10 in the XXZ topic, even if they never made a post with either ABC or XYZ in it, the count will show as
ABC - 25, XYZ - 10

On a positive note, words inside quotes, img tags and links don’t appear to be included.