950301 mp1 # of DAB pages with direct link (articles)

SQL

USE fawiki_p;
SELECT pl_title #DISTINCT CONCAT ('# [[',page_title,']]'),COUNT(pl_from)
FROM pagelinks JOIN page ON pl_namespace = page_namespace AND pl_title = page_title
WHERE pl_from_namespace=0
AND pl_namespace=0
AND pl_from IN (
  SELECT page_id
  FROM page
 # page_namespace=0
 # page_is_redirect=0
  WHERE page_title LIKE "عکاسی"
  )
  AND page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation')
  AND page_title IN (
  SELECT tl_title
  FROM templatelinks)
  AND pl_title NOT IN (
    SELECT pl_title
    FROM pagelinks
    WHERE pl_from_namespace=10
  AND pl_namespace=0)
    ;

SQL

Checking query status...