We would like to get multiple lists of the 100 most-viewed articles in various Wikipedias, for the inevitable press requests/interest in "top 50" etc. (cf. current thread on the private comcom mailing list)
I believe this has previously been done one wiki at a time, per T183903#3874401 (Zhwiki results) and similar. [because the API doesn't have a 'yearly' endpoint yet, per T154381]
milimetric has very helpfully made a draft mysql query that //should// work for all wikis, at T183903#4818567
We need someone to run (or fix) that query, and provide us with the results. Please and thank you!
NOTE: Details are still being discussed. In particular, we're not sure whether to wait for January 1 (to be precise/complete) or get the list now (when there's the most external interest in these types of lists). -- Maybe doing both is feasible?