Wikipedia talk:WikiProject Medicine/Stats/Top medical editors 2017 (all)

Generating list
Description in more or less human-readable language (will try to improve it later). How I did it. -- Edgars2007  (talk/contribs) 06:27, 25 April 2018 (UTC)
 * 1) Run a SQL query to get all enwiki articles (and their Wikidata item), that are part of Wikiproject Medicine (gladfully we have a category, so no "overload" with querying with template)
 * 2) From the results, grab all WD items and do API query (I do them in batches of 500 items) to get all sitelinks
 * 3) Make a dictionary/array/list/JSON or whatever it's called in your preferred language in such form:
 * {'enwiki':['enwiki article 1','enwiki article 2',...],'frwiki':['frwiki article 1',...],...}
 * 1) Wiki by wiki do a SQL for articles (I made it by batches of 100 articles), first selecting page ids from page titles (don't forget about underscores :) ), and then get user edit history of 2017. And then simply group by the results in form that you prefer.
 * 2) Basically that's it :)