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>
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!
Version: unspecified
Severity: major
From: Dan Collins <EN.WP.ST47@gmail.com>
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