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 tl_title
  FROM templatelinks)
)
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 tl_title
  FROM templatelinks)
);

SQL

Checking query status...