Tewiki:Cricket 2023 project: Pages with red links

SQL

select p1.page_title, count(p1.page_title) redlinks from pagelinks pl,page p1,page p2

where p1.page_id = pl.pl_from	

and p2.page_title=p1.page_title
and p2.page_namespace=1
and p1.page_namespace=0
and pl_namespace  = 0
and not exists (select page_title
                from page
                where page_title = pl.pl_title
                and page_namespace = 0)
and p2.page_id IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = 'క్రికెట్_2023_ప్రాజెక్టులో_భాగంగా_సృష్టించిన_పేజీలు'
)        
group by p1.page_title
order by count(p1.page_title) desc

SQL

Checking query status...