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')

;