page links all

SQL

use ukwikiquote_p;

select p.page_id, 0 + case r.rd_from when null then 0 else 1 end + case ppr.pp_page when null then 0 else 2 end as redir, ifnull(pp.page_id,0) as link_id
from page p
left join pagelinks pl on p.page_id = pl.pl_from 
left join page pp on pl.pl_title = pp.page_title and pl.pl_namespace = pp.page_namespace  
left join redirect r on r.rd_from = p.page_id 
left join page_props ppr on p.page_id = ppr.pp_page and ppr.pp_propname = 'disambiguation' 
where p.page_namespace = 0 
		and pl.pl_namespace = 0 
        and pp.page_id is not null
SQL

Checking query status...
