Page MenuHomePhabricator

DBQ-158 list of 100 users that made category and articles
Closed, ResolvedPublic

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-158.
Summary: list of 100 users that made category and articles
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>


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

Date: Mon, 26 Sep 2011 13:43:59

Hi,
I want a query that get for fa.wiki that get 100 first user that made articles except redirects
and sort them with new articles and give me this chart

users articles categories templates portal help
reza 100 30 10 0 20
ali 23 56 30 3 10
..
..

thank you
reza


Version: unspecified
Severity: major

Details

Reference
bz59422

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:30 AM
bzimport set Reference to bz59422.

From: Hoo man <hoo@online.de>

Date: Mon, 26 Sep 2011 13:58:55

For all time? I have some experience with that kind of queries though my API (http://toolserver.org/~hoo/api/pagesCreated.php) which already often has performance Problems on single users :/


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

Date: Mon, 26 Sep 2011 14:14:56

yse for all the time
also is it possible to add each user's first edition date (I want to know how many years or months it takes that they made these amount of editions)


From: Hoo man <hoo@online.de>

Date: Mon, 26 Sep 2011 14:15:42

Ok, let me see how I can get that done...


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

Date: Mon, 26 Sep 2011 16:15:46

thank you it is perfect
would you please add other version that is doesn't have bots?


From: Hoo man <hoo@online.de>

Date: Mon, 26 Sep 2011 16:52:19

Without bots:
http://toolserver.org/~hoo/dbq/dbq-158_2.txt


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

Date: Mon, 26 Sep 2011 17:18:53

code please ![][1]

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

From: Hoo man <hoo@online.de>

Date: Mon, 26 Sep 2011 17:24:25

Oh, sorry http://toolserver.org/~hoo/dbq/dbq-158_2.sh ![][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