https://bugzilla.wikimedia.org/show_bug.cgi?id=59369
--- Comment #1 from Bugzilla Bug Importer (valhallasw)
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Fri, 31 Dec 2010 09:59:17
-------------------------------------------------------------------------------
SQL:
SELECT rev_user_text AS user_name, COUNT(*) AS edits FROM revision INNER
JOIN page ON revision.rev_page = page.page_id LEFT JOIN (SELECT ug_group as
is_bot, ug_user FROM user_groups WHERE ug_group = 'bot') as groups ON
revision.rev_user = groups.ug_user WHERE isnull(is_bot) AND page.page_namespace
= 0 GROUP BY revision.rev_user_text ORDER BY edits DESC;
Results:
http://toolserver.org/~hoo/dbq/dbq-117.txt (plain text)
http://toolserver.org/~hoo/dbq/dbq-117_wiki.txt (wiki table)
--
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
