Page MenuHomePhabricator

DBQ-183 SQL Query Issue
Closed, ResolvedPublic

Description

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


Version: unspecified
Severity: critical

Details

Reference
bz59463

Event Timeline

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

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