DBQ-168 list of redirect pages with history more that 1 revisions
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:07 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-168.
Summary: list of redirect pages with history more that 1 revisions
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>

From: reza <reza.energy@gmail.com>

Date: Fri, 18 Nov 2011 11:23:51

Hi,
Would you please give me a list of all pages that they are redirect but their history has more that 1 revisions ?
for ns:1 ,wiki:en , number:all of pages.
please also give also the target page name.
i want this for merging histories.

Version: unspecified
Severity: major

Details

Reference: bz59436

Event Timeline

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

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

• bzimport set Reference to bz59436.

JiraBugConverter created this task.Jan 3 2014, 4:07 PM

From: Hoo man <hoo@online.de>

Date: Sun, 20 Nov 2011 22:15:34

Have fun with it... the result is quite big.

SQL:

SELECT page_title, rd_namespace, rd_title, COUNT(*) as edits FROM revision INNER JOIN page ON rev_page = page_id INNER JOIN redirect ON rev_page = rd_from WHERE page_namespace = 0 AND page_is_redirect = 1 GROUP BY page_title HAVING COUNT(*) > 1;

Result:
http://toolserver.org/~hoo/dbq/dbq-168.txt

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: hoo@online.de
CC list: reza.energy@gmail.com, hoo@online.de

DBQ-168 list of redirect pages with history more that 1 revisionsClosed, ResolvedPublicActions