HRWIKI: Redirects from other namespaces to mainspace

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("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("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("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("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 ".*/.*";
SQL

Checking query status...
