Last modified: 2014-01-03 16:09:29 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-180. Summary: Database Query (question) 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: Sat, 07 Apr 2012 02:16:20 ------------------------------------------------------------------------------- =D
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 07 Apr 2012 23:57:48 ------------------------------------------------------------------------------- Ok, first of all, no I can't find information about the task(s) of bots in the database. But of course I can tell how many bots are active, so here we go: First of all I once again gathered a list of how many edits to the article namespace which bot made in which year, month with the following query: SELECT /* SLOW_OK */ LEFT(rev_timestamp, 4) as year, SUBSTR(rev_timestamp, 5, 2) as month, rev_user_text as user, COUNT(*) as edits FROM revision INNER JOIN page ON page_id = rev_page WHERE rev_user_text = 'USER' AND page_namespace = 0 GROUP BY LEFT(rev_timestamp, 4), SUBSTR(rev_timestamp, 5, 2); and then I ran the following query on this data (after I imported it again): SELECT year, month, COUNT(*) AS 'active bots' FROM dbq180_0 GROUP BY year, month; Results: The interim results (as I guess they are helpful for you): http://toolserver.org/~hoo/dbq/dbq-180_0.txt (plain text) http://toolserver.org/~hoo/dbq/dbq-180_0.csv (csv) What you actually asked for: http://toolserver.org/~hoo/dbq/dbq-180_1.txt (plain text) http://toolserver.org/~hoo/dbq/dbq-180_1.csv (csv)
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