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
left join page on page_id = pl_from
where page_is_redirect = 1 
and page_namespace = 0 
and exists (
  select null
  from page  left join redirect on page_id = rd_from left join page_props on pp_page = page_id
  where rd_namespace = 0
  and page_title = rd_title
  and pp_propname = 'disambiguation'
) 
and exists (
  select null
  from page
  where page_id = pl_from  
  and 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;

SQL

Checking query status...