Last modified: 2014-01-03 16:06:10 UTC
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
------------------------------------------------------------------------------- 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: Hoo man <hoo@online.de> Date: Mon, 26 Sep 2011 15:03:10 ------------------------------------------------------------------------------- SQL: http://toolserver.org/~hoo/dbq/dbq-158.sh Result: http://toolserver.org/~hoo/dbq/dbq-158.txt
------------------------------------------------------------------------------- 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