How can I get a report of most duplicated questions ? Inspired by recent discussions and curiosity.
Thanks to @Shog9 's comment I had a go at using data.stackexchange.com to get the data. His example seems to be a bit out of date as regards the schema so I researched a new working version.
I'm not yet fully familiar with the full db schema so feel free to improve it.
Bear in mind this only lists actually declared duplicate questions, not tags or groups of "very similar but not duplicate" questions.
This only lists question with 3+ dups, there are a few 100 2 dups.