Tewiki: All Templates with Red links

SQL

select concat("[[",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 = 10
        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) > 99
order by count(pl_title) desc
#and catl.cl_type = "page"
#group by p.page_id
#order by pl_title
SQL

Checking query status...
