Last modified: 2014-01-03 16:07:27 UTC
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.
------------------------------------------------------------------------------- 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