direct and redirected links to DAB pages in a given article (not 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 REPLACE(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 page_title<>'زبان فرانسوی'
)
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 REPLACE(page_title,'_',' ') LIKE "قانون رائول")
  AND page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation')
);

SQL

Checking query status...