From: Hoo man <hoo@online.de>

Date: Fri, 23 Sep 2011 17:50:54

Sorry, but I can't do that with so few information, please redefine your needs. (On which wiki? 100 non-sysops and 100 sysops? What format? ...)

From: DaB. <dab@ts.wikimedia.org>

Date: Fri, 23 Sep 2011 17:52:07

and which time-span?

From: reza <reza.energy@gmail.com>

Date: Fri, 23 Sep 2011 18:03:30

thank your for reply
we want to charts 1- with bot 2- no bot

• for fa.wiki

*for any user group (normal or sysops or bot) who had any contributions in fa.wiki sorted with most editions
*time-span= one month

• all of name spaces
• for 100 most contributed users

for example:

:r user ns0 ns10 ns14 .... user group
:1 rezabot 12000 234 0 bot
:2-reza2 545 444 4 user
:3-reza3 344 33 2 sysops
:4- rewa 22 2 1 user
:.
.
.100 .........................................

2-second query without bot contributions

From: Hoo man <hoo@online.de>

Date: Fri, 23 Sep 2011 22:37:44

SQL:
http://toolserver.org/~hoo/dbq/dbq-156.sh
Result:
http://toolserver.org/~hoo/dbq/dbq-156.txt (sysops, bots and user)
http://toolserver.org/~hoo/dbq/dbq-156_2.txt (sysops and users)

Hope this is what you wanted, cause it was quite some work to build the queries ![][1]
I used August 2011 as month, btw

[1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif

From: reza <reza.energy@gmail.com>

Date: Sat, 24 Sep 2011 11:12:08

thank you very much.it is perfect
In edits_all, it has bug because if you add all of namespaces contributions it is not equal

From: reza <reza.energy@gmail.com>

Date: Sat, 24 Sep 2011 11:35:25

for example
http://toolserver.org/~soxred93/pcount/index.php?name=reza1615&lang=fa&wiki=wikipedia

reza1615 edits in 08/2011 was 1175 but in report is 4700.

From: Hoo man <hoo@online.de>

Date: Sat, 24 Sep 2011 12:53:10

bah ![][1] ... I had a slight mistake within the queries. I've fixed the queries and re executed them, the results should be fine now ![][2]

[1]: https://jira.toolserver.org/images/icons/emoticons/tongue.gif
[2]: https://jira.toolserver.org/images/icons/emoticons/wink.gif

From: reza <reza.energy@gmail.com>

Date: Sat, 24 Sep 2011 14:25:08

thank it is fine!
i have other request is it possible to add user's total contribution in last column?
excuse me i wast your time.
this is the result in fa.wiki
http://fa.wikipedia.org/wiki/%D9%88%DB%8C%DA%A9%DB%8C%E2%80%8C%D9%BE%D8%AF%DB%8C%D8%A7:%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4_%D8%AF%DB%8C%D8%AA%D8%A7%D8%A8%DB%8C%D8%B3/%D9%81%D8%B9%D8%A7%D9%84%DB%8C%D8%AA_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D9%87%D8%A7/%D8%A8%D8%A7_%D8%B1%D8%A8%D8%A7%D8%AA/%DA%98%D9%88%D8%A6%DB%8C%D9%87_%DB%B2%DB%B0%DB%B1%DB%B1

From: Hoo man <hoo@online.de>

Date: Sat, 24 Sep 2011 19:20:06

Done as well ![][1]

[1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif

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: hoo@online.de
CC list: reza.energy@gmail.com, hoo@online.de, wikimedia-bugzilla@dabpunkt.eu