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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Bryan Tong Minh <br...@tools.wikimedia.de>
Date: Sat, 14 Jun 2008 09:44:16
-------------------------------------------------------------------------------

SELECT rev_user_text, COUNT![][1] AS creations FROM (SELECT rev_user_text,
rev_user, MIN(rev_timestamp) FROM revision, page WHERE rev_page = page_id AND
page_namespace = 0 AND page_is_redirect = 0 GROUP BY rev_page) AS p LEFT JOIN
user_groups ON (ug_user, ug_group) = (rev_user, 'sysop') WHERE ug_group IS NULL
GROUP BY rev_user_text HAVING creations > 100 ORDER BY creations;

http://toolserver.org/~bryan/stats/dbquery/enwiki_page_creations_non_admins.txt

   [1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif

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