نوشتارهای غیرابهام‌زدایی با ردهٔ ابهام‌زدایی

SQL

use fawiki_p;
select distinct concat ('# [[', page_title, ']]'), ll_lang
from page
left join categorylinks on cl_from = page_id
left join langlinks on page_id = ll_from
where page_namespace = 0
and page_is_redirect = 0
and cl_to like '%ابهام%'
and exists ( /* The selected page has an unhidden dab category. */
  select null from page as cat
  where catpage.page_title = cat_to
  and catpage.page_namespace = 14
  and not exists (
    select null
    from page_props as catprops
    where catprops.pp_page == catpage.page_id
    and catprops.pp_propname == 'disambiguation'
  )
)
and not exists ( /* The selected page is not a dab page. */
  select null from page_props
  where pp_page = page_id
  and pp_propname = 'disambiguation'
)
and ( /* Does not have equivalent enpage or the enpage is a dab page. */
  (
    ll_lang = 'en'
    and exists (
      select null
      from enwiki_p.page as ep
      left join enwiki_p.page_props as epp  on epp.pp_page = ep.page_id
      where ep.page_title = ll_title
      and epp.pp_propname = 'disambiguation'
    )
  ) or not exists (
  	select null from langlinks
    where ll_from = page_id and ll_lang = 'en'
  )
)
group by page_title
order by page_title;
SQL

Checking query status...
