Linked redirected categories

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 NOT LIKE "%‌%"  
    AND scnd.page_title = REPLACE(frst.page_title,'‌','_')
    )
  )
GROUP BY pl_title
ORDER BY count(*) DESC;
#ORDER BY pl_title;
SQL

Checking query status...
