DBQ-46 User pages of users who have only edited the User: namespace on en.wiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:38 PM

Description

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!

Version: unspecified
Severity: minor

Details

Reference: bz59301

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:21 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59301.

JiraBugConverter created this task.Jan 3 2014, 3:38 PM

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

DBQ-46 User pages of users who have only edited the User: namespace on en.wikiClosed, ResolvedPublicActions