I have been playing around with Stack Exchange Data Explorer lately. Any interesting queries you found and care to share?
- Find suggested duplicates that haven't led to question closure
- Find suggested duplicates that haven't led to question closure in a tag
- Forum style questions - multiple self answers from asker
- Recent self answers
- You're probably doing it wrong (Questions with Multiple Answers by the OP)
- Not accepted self answers with negative votes
- Recent Not accepted self answers with negative votes
Not an answer
- Posts that could be marked as 'not an answer' to help get the Marshal badge
- Seek and Destroy: Comments with the phrase "not an answer"
- Something to Flag "Not an answer" in the body of an answer
- Answers With Questions
- Find Something to Flag 1 (small answers with links)
- Find "me too" (so-called) answers
- Finding bad answers through comments