Last modified: 2014-01-03 16:10:07 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-183. Summary: SQL Query Issue Issue type: Task - A task that needs to be done. Priority: Critical Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Franz Herbach <franzherbach@yahoo.de> Date: Wed, 11 Apr 2012 13:38:25 ------------------------------------------------------------------------------- Is there a possibility to complete this table ?? http://en.m.wikipedia.org/wiki/Wikipedia:Editing_frequency/Article_space_bots Thanks in advance
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Thu, 12 Apr 2012 23:55:41 ------------------------------------------------------------------------------- The way I did it isn't optimal and slow, but it worked. (I used the data from http://toolserver.org/~hoo/dbq/dbq-180_0.txt) Code: http://toolserver.org/~hoo/dbq/dbq-183.php.txt Result: http://toolserver.org/~hoo/dbq/dbq-183.txt (plain text) http://toolserver.org/~hoo/dbq/dbq-183.csv (csv)
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 13 Apr 2012 00:29:03 ------------------------------------------------------------------------------- Note: I've fixed the results a few minutes ago (just in case you were fast and already loaded them), cause my SQL query had an error.
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 13 Apr 2012 22:14:39 ------------------------------------------------------------------------------- Klar... diese Spalten listen die Anzahl der Bots die bis zu dem gegebenen Zeitpunkt mindestens X edits vorgenommen haben (im NS 0).
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sun, 15 Apr 2012 14:50:18 ------------------------------------------------------------------------------- "Bots with ≥ X edits in that month", die Anzahl der Bots mit X Edits in dem Monat, denke das ist klar. "Bots with ≥ X edits cumulative all-time", die Anzahl der Bots, die bis zu dem Monat X Edits vorgenommen haben (alle Artikelbearbeitungen bis zum gegebenen Monat aufaddiert) ![][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: hoo@online.de