https://bugzilla.wikimedia.org/show_bug.cgi?id=59458

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@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)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to