Untitled query #79440

SQL

select	concat('{{-r|WP:',p.page_title,'}}') `Redirect`,
		concat('[[:',rd.rd_title,']]') `Target`
from	redirect rd
		left join page p
        on rd.rd_from = p.page_id
where	rd.rd_namespace = 0
and		p.page_namespace = 4
and		p.page_title not rlike '^(?:[A-Z:]+$|WikiProject)'
and		p.page_title not rlike '(?i)^(?:Article_Incubator|Articles_for_creation|Requested_articles|School_and_university_projects|United_States_Education_Program|WikiAfrica|WikiTown)/'
and		p.page_title not like '%_topics'
and		rd.rd_title not in ('Main_Page', 'UseModWiki')
and		rd.rd_title not rlike '(?:MediaWiki|Wikimedia|Wikipedia)'
and		rd.rd_title not like 'Project_%'
;
SQL

Checking query status...
