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

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Mon, 22 Aug 2011 13:13:45
-------------------------------------------------------------------------------

SQL:

    INSERT /* SLOW_OK */ INTO u_hoo.dbq151 (user_name) SELECT DISTINCT
rev_user_text FROM revision INNER JOIN page ON rev_page = page_id WHERE
rev_user != 0 AND LEFT(rev_timestamp, 6) = 200904 AND page_namespace < 6 LIMIT
10000;

Which selects 10,000 users and saves them to a temp. table (ran it for every
month). Afterwards I just needed to get all entries of that user list:

    SELECT DISTINCT * FROM u_hoo.dbq151;

Many users are in the temp table multiple times, so from the 120,000 only
57,825 unique ones have been selected.

Result:  
http://toolserver.org/~hoo/dbq/dbq-151.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