Untitled query #78164

SQL

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

where p1.page_id = pl_from	
		and p2.page_title=p1.page_title
and p2.page_namespace=1
and p1.page_namespace=0
        and pl_namespace  = 0
        and p1.page_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...
