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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Bryan Tong Minh <br...@tools.wikimedia.de>
Date: Mon, 05 Nov 2007 09:20:49
-------------------------------------------------------------------------------

Final query:

mysql -hsql-s1 enwiki_p -e "SET SESSION TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED; SELECT lr_user, COUNT(lr_title) AS lr_creation_count FROM (SELECT
page_title AS lr_title, MIN(rev_id) AS lr_rev_id, rev_user_text AS lr_user FROM
page, revision WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_page =
page_id GROUP BY rev_page) AS lowest_revision GROUP BY lr_user HAVING
lr_creation_count > 5 ORDER BY lr_creation_count DESC;"
>enwiki_page_creation.txt

Approximate runtime: 30h

Results:
http://tools.wikimedia.de/~bryan/stats/dbquery/enwiki_page_creation.txt

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