This issue was converted from https://jira.toolserver.org/browse/DBQ-195.
Summary: Firsttime contributors to DEWIKI in 2012
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>
From: Gregor Martynus <gregor@martynus.net>
Date: Thu, 06 Sep 2012 23:57:40
Can somebody please run the following 3 SQL queries and provide me the results?
--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;
These queries are put together by user hoo in this ticket:
https://jira.toolserver.org/browse/DBQ-189
Thanks for your help
Version: unspecified
Severity: major