Last modified: 2014-01-03 15:38:02 UTC
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
------------------------------------------------------------------------------- From: korrigan <le.korrigan@gmail.com> Date: Mon, 29 Sep 2008 19:23:55 ------------------------------------------------------------------------------- Actually maybe 1000 users is overkill. First 100 would be great already, and give me plenty of work to do ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Tue, 30 Sep 2008 14:24:17 ------------------------------------------------------------------------------- Results (1000) are at http://toolserver.org/~sql/DBQ/DBQ-44.txt SQL Query is at http://toolserver.org/~sql/DBQ/DBQ-44.sql I hope 1000 works fine for you, if you need the list updated, just re-open this ticket.
------------------------------------------------------------------------------- From: korrigan <le.korrigan@gmail.com> Date: Tue, 30 Sep 2008 15:16:08 ------------------------------------------------------------------------------- This is fine, thanks very much !
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: sxwiki@gmail.com CC list: le.korrigan@gmail.com, sxwiki@gmail.com