enwiki: Project redirects to main

SQL

select	concat('[[Wikipedia:',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 '^(?:MOS:|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 != 'Main_Page'
and		rd.rd_title not rlike '^(?:Project|Wikipedia)_'
;
SQL

Checking query status...
