direct and redirected links to DAB pages in a given article (including links in templates)

SQL

USE fawiki_p;
(
  SELECT pl_title
  FROM pagelinks
  JOIN page ON pl_namespace = page_namespace AND pl_title = page_title
  JOIN redirect ON page_id=rd_from
  WHERE pl_from_namespace=0
  AND pl_namespace=0
  AND page_is_redirect=1
  AND pl_from IN (
    SELECT page_id
    FROM page
    WHERE page_title LIKE "شیراز")
  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_title NOT IN (
    SELECT pl_title 
    FROM pagelinks as pglk
    WHERE pglk.pl_from_namespace=10
#    AND pglk.pl_from=page_id
    AND pglk.pl_namespace=0)
)
UNION
(
  SELECT pl_title
  FROM pagelinks JOIN page ON pl_namespace = page_namespace AND pl_title = page_title
  WHERE pl_from_namespace=0
  AND pl_namespace=0
  AND page_is_redirect=0
  AND pl_from IN (
    SELECT page_id
    FROM page
    WHERE page_title LIKE "شیراز")
  AND page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation')
  AND pl_title NOT IN (
    SELECT pl_title 
    FROM pagelinks as pglk
    WHERE pglk.pl_from_namespace=10
#    AND pglk.pl_from=page_id
    AND pglk.pl_namespace=0)
);
SQL

Checking query status...
