Last modified: 2014-01-03 15:32:04 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-12. Summary: Cross-namespace redirects on en.wiki Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Tue, 12 Feb 2008 15:46:36 ------------------------------------------------------------------------------- If possible, it would be great if I could get a list of all redirects that go from NS:0 to NS:1, NS:2, or NS:3 on en.wiki. Thanks!
------------------------------------------------------------------------------- From: Dan Collins <EN.WP.ST47@gmail.com> Date: Tue, 12 Feb 2008 23:51:38 ------------------------------------------------------------------------------- select concat('[[',pf.page_title,']]') from redirect, page as pf, page as pt where pf.page_namespace=0 and rd_title = pt.page_title and rd_namespace=pt.page_namespace and (pt.page_namespace=1 or pt.page_namespace=2 and pt.page_namespace=3) and rd_from=pf.page_id and pf.page_namespace=0; --------------------------------------------------------------------------- concat('[[',pf.page_title,']]') --------------------------------------------------------------------------- [[Allegations_of_state_terrorism_by_United_States_of_America/strawpolls]] [[Architecture_of_Houston/sandbox]] [[Britney_Spears_discography/Album_Sales]] [[DNA/More_simple]] [[Great_power/History]] [[Herbert_Dingle/Draft_revision]] [[Héctor_López/positions_chart]] [[Introduction_to_evolutiont/sandbox_for_drafting_the_lead"]] [[Introduction_to_evolutiont/sandbox_for_drafting_the_lead]] [[Khayrpur_(princely_state)/proposed]] [[Logistic_distribution/Generalized_log-logistic_distribution]] [[London_Borough_of_Croydon/to_do]] [[Mancini_(Brazilian_player)]] [[Milla_Jovovich/Archive_1]] [[Patriarch_Alexius_II/Archive_1]] [[Recurring_jokes_in_SpongeBob_SquarePants]] [[Underoath/Archive_2]] ---------------------------------------------------------------------------
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, EN.WP.ST47@gmail.com
*** Bug 59265 has been marked as a duplicate of this bug. ***