HRWIKI: Redirects from other namespaces to mainspace

Fork of redirects from root talk/user/user talk pages to mainspace articles by 1234qwer1234qwer4
This query is marked as a draft This query has been published by Ivi104.
SQL

Select CONCAT("Razgovor:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 1
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Suradnik:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 2
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_sa_suradnikom:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 3
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Wikipedija:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 4
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_Wikipedija:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 5
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Datoteka:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 6
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_datoteci:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 7
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("MediaWiki:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 8
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("MediaWiki_razgovor:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 9
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Predložak:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 10
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_predlošku:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 11
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Pomoć:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 12
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_pomoći:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 13
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Kategorija:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 14
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_kategoriji:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 15
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Portal:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 100
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_portalu:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 101
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Dodatak:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 102
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_dodatku:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 103
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Nacrt:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 118
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_nacrtu:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 119
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Modul:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 828
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Razgovor_o_modulu:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = 829
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Mediji:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = -2
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";

Select CONCAT("Posebno:", page_title), rd_title from page join redirect on page_id = rd_from
Where page_namespace = -1
And rd_namespace = 0
And page_title NOT REGEXP ".*/.*";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
