Last modified: 2014-01-03 15:38:16 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-46. Summary: User pages of users who have only edited the User: namespace on en.wiki Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Wed, 08 Oct 2008 23:50:45 ------------------------------------------------------------------------------- I would like a list of all user pages on en.wiki where the user has only edited the User: namespace (or perhaps more simply only edited their own user page). Caveat: usernames are stored with actual spaces while User: pages are stored with underscores instead of spaces. This means you'll likely have to base everything on user IDs unless you can find a way to convert the spaces in usernames to underscores. Samples to verify data: http://en.wikipedia.org/wiki/User:MarisaWalker http://en.wikipedia.org/wiki/User:Martin.moensted http://en.wikipedia.org/wiki/User:Sloqlaria Thank you very much!
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Fri, 10 Oct 2008 06:57:32 ------------------------------------------------------------------------------- CBM wrote a query that resolves this task: SELECT CONCAT("# [[User:",user_name,"]]") FROM user JOIN page ON user_name = replace(page_title, '_', ' ') AND page_namespace = 2 WHERE user_editcount > 0 AND NOT EXISTS (SELECT 1 FROM revision JOIN page ON rev_page = page_id WHERE rev_user_text = user_name AND NOT page_namespace in (2)); The query ran for 81 minutes. It lists all users where the user has only edited the User: namespace. It does not check whether the user edited their own User: page.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: b@mzmcbride.com