trwiki_p Links to disambiguation pages

SQL

SELECT CONCAT('# [[Özel:SayfayaBağlantılar/',page_title,']]'), COUNT(pl_from) AS 'count'
FROM ((
    # direct links from non-redirects to disambiguation pages 
  	SELECT dp.page_namespace, dp.page_title, pl_from
    FROM page fp, pagelinks, page dp, page_props
    WHERE
  	  fp.page_id=pl_from AND fp.page_is_redirect=0 AND
      pl_namespace=dp.page_namespace AND pl_title=dp.page_title AND
      dp.page_is_redirect=0 AND dp.page_id=pp_page AND pp_propname='disambiguation'
  ) UNION (
    # links from non-redirects to redirects to disambiguation pages
    SELECT dp.page_namespace, dp.page_title, pl_from
    FROM page fp, pagelinks, page rp, redirect, page dp, page_props
    WHERE
  	  fp.page_id=pl_from AND fp.page_is_redirect=0 AND
      pl_namespace=rp.page_namespace AND pl_title=rp.page_title AND
      rp.page_is_redirect=1 AND rp.page_id=rd_from AND
      rd_namespace=dp.page_namespace AND rd_title=dp.page_title AND
      dp.page_is_redirect=0 AND dp.page_id=pp_page AND pp_propname='disambiguation'
  )) t


/* FROM ((
    # direct links from non-redirects to disambiguation pages 
  	SELECT dp.page_namespace, dp.page_title, pl_from
    FROM page fp, pagelinks, page dp, page_props, # page tp, templatelinks,
    WHERE
  	  fp.page_id=pl_from AND fp.page_is_redirect=0 AND
      pl_namespace=dp.page_namespace AND pl_title=dp.page_title AND
      dp.page_is_redirect=0 AND dp.page_id=pp_page AND pp_propname='disambiguation' 
  #	  AND tp.page_id = tl_from AND tl_namespace = 10 AND NOT tl_title LIKE ('Diğer')
  )
  ) UNION (
    # links from non-redirects to redirects to disambiguation pages
    SELECT dp.page_namespace, dp.page_title, pl_from
    FROM page fp, pagelinks, page rp, redirect, page dp, page_props
    WHERE
  	  fp.page_id=pl_from AND fp.page_is_redirect=0 AND
      pl_namespace=rp.page_namespace AND pl_title=rp.page_title AND
      rp.page_is_redirect=1 AND rp.page_id=rd_from AND
      rd_namespace=dp.page_namespace AND rd_title=dp.page_title AND
      dp.page_is_redirect=0 AND dp.page_id=pp_page AND pp_propname='disambiguation'
  )) 
  */
GROUP BY page_namespace, page_title
ORDER BY `count` DESC;
SQL

Checking query status...
