detagging orphaned articles (including redirects; enwiki)

SQL

use enwiki_p;
SELECT pl.pl_namespace, pl.pl_title, count(pl.pl_from), pl.pl_from_namespace#p.page_title, COUNT(pl.pl_from)
from pagelinks pl
where pl.pl_namespace=0 

and pl.pl_from_namespace=0
and /*pl.pl_from_namespace=0 and  - svarīgi arī veidnēs izvākt*/ pl.pl_title in (SELECT p2.page_title
from pagelinks pl2
join page p2 on pl2.pl_from=p2.page_id
where p2.page_is_redirect=1 and pl2.pl_namespace=0
		and pl2.pl_from_namespace=0
      and /*pl2.pl_from_namespace=0 and  - svarīgi arī veidnēs izvākt*/pl2.pl_title in (SELECT p3.page_title
					FROM page p3
					INNER JOIN categorylinks c3 ON p3.page_id = c3.cl_from AND c3.cl_to = "All_orphaned_articles"
					INNER JOIN pagelinks pl3 ON p3.page_title = pl3.pl_title AND p3.page_namespace = pl3.pl_namespace
					INNER JOIN page p23 ON p23.page_id = pl3.pl_from
					AND pl3.pl_from_namespace = 0)
                                                                                                         
                                                                                                         )
group by pl.pl_title
having count(pl.pl_from)>2
order by count(pl.pl_from)
SQL

Checking query status...
