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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Fri, 06 Jul 2012 14:38:36
-------------------------------------------------------------------------------

Detecting if a user was new at a given time isn't trivial, so I left that out
for now. Please notice, that IPs are counted as users as well.  
SQL:

    SELECT /* SLOW_OK */ COUNT(*) AS edit_count, COUNT(DISTINCT rev_user_text)
AS user_count, LEFT(rev_timestamp, 6) AS month FROM page INNER JOIN revision ON
rev_page = page_id WHERE page_namespace = 4 AND page_title LIKE
'Pagine_da_cancellare/%' AND LEFT(rev_timestamp, 6) > 201000 GROUP BY
LEFT(rev_timestamp, 6);

Result:  
http://toolserver.org/~hoo/dbq/dbq-190.txt (plain text)

-- 
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