most linked redirects (non-space to space)

SQL

USE fawiki_p;
SELECT DISTINCT pl_title,count(*)
FROM pagelinks INNER JOIN page ON pl_from = page_id
WHERE pl_namespace = 0
AND page_namespace = 0
AND pl_title IN (
  SELECT page_title
  FROM page AS frst
  WHERE frst.page_namespace = 0
  AND frst.page_is_redirect=1
#  AND frst.page_title LIKE "%\_%"  
  AND EXISTS (
    SELECT null
    FROM page AS scnd
    WHERE scnd.page_namespace=0
    AND scnd.page_is_redirect=0
    AND scnd.page_title LIKE "%\_%"  
    AND frst.page_title = REPLACE(scnd.page_title,'_','')
    )
  )
GROUP BY pl_title
ORDER BY count(*) DESC;
#ORDER BY pl_title;

SQL

Checking query status...