This issue was converted from https://jira.toolserver.org/browse/DBQ-44.
Summary: List of users by most uploads on fr.wikipedia
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: SQL <sxwiki@gmail.com>
From: korrigan <le.korrigan@gmail.com>
Date: Mon, 29 Sep 2008 08:37:36
Hello. In order to help me transfer free images from fr.wikipedia to Commons, I would like to know who are the users on fr.wikipedia who have done the most uploads.
I don't know if it feasible as I don't kow SQL, so sorry if I'm asking for too much, but here is the desired output :
- one column with the 1000 users with most uploads, and if possible a link to their gallery (using http://toolserver.org/~daniel/WikiSense/Gallery.php?wikilang=fr&wikifam=.wikipedia.org&format=html&img_user_text=USER)
- one column with the number of uploads.
If it is possible at all, maybe images contained in [[:fr:Catégorie:Image protégée en tant que marque]] could be excluded ? These are not transferrable to Commons, and it's about half of the remaining images, so it wouldn't help to include these. Never mind if they can't be separated.
Output in wikicode would be great ![][1]
Thank you !
[1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
Version: unspecified
Severity: major