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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Mon, 02 Jul 2012 23:06:43
-------------------------------------------------------------------------------

As told, this was an easy one, so here we go:  
SQL:

    --1
    SELECT user_id, user_name, user_registration FROM user INNER JOIN logging
ON log_user = user_id WHERE LEFT(user_registration, 4) = 2012 AND user_id NOT
IN (SELECT ipb_user FROM ipblocks) AND log_type = 'newusers' AND log_action =
'create';
    --2
    SELECT page_id, page_title, page_namespace, page_is_redirect FROM page;
    --3
    INSERT INTO u_hoo.dbq189 SELECT user_name FROM user INNER JOIN logging ON
log_user = user_id WHERE LEFT(user_registration, 4) = 2012 AND user_id NOT IN
(SELECT ipb_user FROM ipblocks) AND log_type = 'newusers' AND log_action =
'create';
    SELECT rev_id, rev_page, rev_comment, rev_user_text, rev_user,
rev_timestamp FROM revision INNER JOIN u_hoo.dbq189 ON rev_user_text =
dbq189.user_name WHERE rev_deleted = 0 AND rev_user != 0;

Result:  
http://toolserver.org/~hoo/dbq/dbq-189_0.txt (plain text)  
http://toolserver.org/~hoo/dbq/dbq-189_1.txt (plain text)  
http://toolserver.org/~hoo/dbq/dbq-189_2.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