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

SQL

USE fawiki_p;
(
  SELECT pl_title
  FROM pagelinks pl1
  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 pl2.pl_title
    FROM pagelinks AS pl2
    WHERE pl2.pl_from IN (
        SELECT p2.page_id
        FROM page AS p2 JOIN templatelinks ON page_namespace=tl_namespace AND page_title=tl_title
        WHERE tl_from = pl1.pl_from
    )
)
)
UNION
(
  SELECT pl_title
  FROM pagelinks pl1 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 pl2.pl_title
    FROM pagelinks AS pl2
    WHERE pl2.pl_from IN (
        SELECT p2.page_id
        FROM page AS p2 JOIN templatelinks ON page_namespace=tl_namespace AND page_title=tl_title
        WHERE tl_from = pl1.pl_from
    )
)
);
SQL

Checking query status...
