950701 mp1 # of redirected links to DAB pages (pages)

SQL

USE fawiki_p;
SELECT COUNT(page_id)
FROM pagelinks JOIN page
WHERE page_is_redirect=1
AND (
  page_title LIKE "تیم_ملی_(ابهام‌زدایی)"
  OR page_title LIKE "بهینه‌سازی_(ابهام‌زدایی)"
  )
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;

SQL

Checking query status...