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 concat('# [[', page_title, ']]'), count(pl_from), rd_title
from pagelinks 
left join page on pl_namespace = page_namespace and pl_title = page_title
left join redirect on page_id = rd_from
where page_is_redirect = 1 
and page_namespace = 0 
and rd_namespace = 0 
and pl_from_namespace = 0
and exists ( # pl_from in non-redirect ids
    select null 
    from page
    where pl_from = page_id 
    and page_is_redirect=0
)
and exists (
    select null
    from page
    where page_title = rd_title 
    and exists (
        select null
        from page_props
        where page_id = pp_page and pp_propname = 'disambiguation'
    )
)
group by pl_title
order by count(pl_from) desc;

SQL

Checking query status...