This issue was converted from https://jira.toolserver.org/browse/DBQ-189.
Summary: firsttime contributors to DEWIKI in June
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: Mon, 02 Jul 2012 19:03:53
I'd need 3 things for a study of a friend of mine:
- users that manually signed up in 2012 and have not been blocked.
- All pages
- revisions by the users from 1.
As a Sidenode, could I have a SQL dump of a small wikipedia like simple.wikipedia.org so I can build and test the queries myself, so you don't have to? Tables: user (without sensitive columns of course), ipblocks, logging, revision, page.
Could anybody run these queries against DE wiki and send me the results? I think the SQL queries should look like this:
-- Users that manually signed up in 2012, flagged if they have been blockd SELECT user_id, user_name, log_timestamp AS signed_up_at ipb_timestamp AS blocked_at FROM user LEFT JOIN logging ON user_id = log_user LEFT JOIN ipblocks ON user_id = ipb_user WHERE type = 'new_users' AND action = 'create' AND log_timestamp > "2012"; -- all pages SELECT page_id, page_name, page_namespace, page_is_redirect, FROM page; -- revisions from 2012 SELECT rev_id, rev_page, rev_comment, rev_deleted, rev_user, rev_timestamp FROM revision WHERE rev_timestamp > "2012"; -- THANKS A LOT
Version: unspecified
Severity: major