owp4.1 most frequent categories of orphan articles

SQL

USE enwiki_p;
SELECT REPLACE(pg.page_title,'_',' ') page_title, REPLACE(rd.page_title,'_',' ') old_link, REPLACE(rd_title,'_',' ') new_link
#SELECT REPLACE(pg.page_title,'_',' ') page_title, REPLACE(rd.page_title,'_',' ') old_link, REPLACE(rd_title,'_',' ') new_link, COUNT(rd.page_title)
FROM page AS rd JOIN redirect ON rd_from = rd.page_id JOIN pagelinks ON pl_title = rd.page_title JOIN page AS pg ON pl_from = pg.page_id
WHERE rd.page_namespace = 0
AND rd.page_is_redirect = 1 
AND rd.page_title LIKE "%(film)"
AND rd_namespace = 0
AND rd_title LIKE "%(film\_%"
AND MID(rd_title,1,LOCATE('(film',rd_title)-2) = MID(rd.page_title,1,LOCATE('(film',rd.page_title)-2)
AND pl_from_namespace = 0 
AND pl_namespace = 0
AND pg.page_namespace = 0
AND pg.page_is_redirect = 0

LIMIT 100;
#GROUP BY rd.page_title
#ORDER BY COUNT(rd.page_title) DESC;
SQL

Checking query status...
