Tewiki: Disambig pages with red links

SQL

select page_title,count(page_title) redlinksCount from pagelinks pl,page
#join page on page_id=pl_from
where page_id = pl_from	
		and page_id in (select pp_page from page_props where pp_propname ="disambiguation")
        and pl_namespace  = 0
        and page_namespace = 0
        and not exists (select page_title
                from page 
                where page_title = pl.pl_title
                and page_namespace = 0)
 group by page_title
-- having count(page_title) < 20
order by count(pl_title) desc
#and catl.cl_type = "page"
#group by p.page_id
#order by pl_title

SQL

Checking query status...