mp1.3 DAB pages with redirected links

Fork of mp1.3 DAB pages with redirected links (old version) by Saeidpourbabak

This query is marked as a draft This query has been published by Dalba.

SQL

use fawiki_p;
select distinct concat('# [[', page_title, ']]'), count(pl_from), rd_title
from pagelinks join page right join redirect on page_title = rd_title
where page_is_redirect=1
and page_namespace=0
and page_id in ( # redirects to disambs
  select rd_from
  from redirect
  where rd_namespace=0
  and rd_title in ( # disamb titles
    select page_title
    from page
    where page_id in ( # dismab ids
      select pp_page
      from page_props
      where pp_propname = 'disambiguation'
    )
  )
)
and pl_from in ( # redirect ids
  select page_id
  from page
  where page_is_redirect=0
)
and pl_title=page_title
and pl_namespace = 0
and pl_from_namespace=0
group by pl_title
order by count(pl_from) desc
limit 100;

SQL

Checking query status...