Help finding some monthly site stats about topics and user trust levels

I’ve updated the “Topic Participation” query:

  • Include posts information
  • separated exclusions for “topics created by user from group” and “posts created by user from group”
  • impersonate a particular users view of topics - use an admin user like system to see everything.
  • optionally restrict results to that month (-1) for responses or check for replies within X days.
  • support output of response rate as percentage ready for Excel (i.e. a value between 0 and 1).

It would be nice if someone would sanity check the query please.

To check and:

  • ensure it makes sense
  • I’m not 100% confident the Discourse internals for security lookups
  • at over 200 lines of SQL it’s quite long.
4 Likes