mp1.3 DAB pages with redirected links (old version)

SQL

USE fawiki_p;
SELECT DISTINCT CONCAT ('# [[',page_title,']]'),COUNT(pl_from)#,rd_title
FROM pagelinks JOIN page
WHERE page_is_redirect=1
AND page_namespace=0
AND page_id IN (
SELECT rd_from
FROM redirect
WHERE rd_namespace=0
AND rd_title IN (
  SELECT page_title
  FROM page
  WHERE page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation')
  )
  )
  AND pl_from IN (
  SELECT page_id
  FROM page
  WHERE page_is_redirect=0)
  AND pl_title=page_title
  AND pl_namespace = 0
  AND pl_from_namespace=0
  GROUP BY pl_title
  ORDER BY COUNT(pl_from) DESC;

SQL

Checking query status...