950701 mp1 # of DAB pages with redirected link (pages)

SQL

USE fawiki_p;
SELECT DISTINCT CONCAT ('# [[',page_title,']]'),COUNT(pl_from)
FROM pagelinks JOIN page ON pl_title=page_title
WHERE page_is_redirect=0
AND page_title LIKE "آمریکایی"
AND page_namespace=0
AND page_title NOT LIKE "%(ابهام‌زدایی)%"
AND 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_from_namespace=4

  )
AND pl_namespace=0
#AND (
#    pl_from_namespace=0
#    OR pl_from_namespace=100
#    OR pl_from_namespace=828
#     (
#      pl_from_namespace=0
#      AND page_title LIKE "%یادبودهای برگزیده%"
#      )
#    )
GROUP BY pl_title
ORDER BY COUNT(pl_from) DESC;

SQL

Checking query status...