Have you looked at using the Discourse Data Explorer Plugin if you have it installed? The plugin comes with some queries you may find helpful. If not, have a look in the data & reporting category for help. I’m no sql wizard but others are more than happy to help you out 
5 Likes