red links, only ns=0 and only in ns=0, hywiki

SQL

With AllMainTitle As (select page_title as title from page where page_namespace = 0),
	AllMathIds AS (SELECT DISTINCT page_id as math_page_id
   		FROM templatelinks
   		JOIN linktarget ON lt_id = tl_target_id
   		JOIN page ON page_id = tl_from
                   WHERE lt_title = "Վիքինախագիծ_Մաթեմատիկա")

select pl_title, count(*) c
from pagelinks 
join page on page_id = pl_from
where pl_namespace = 0 
	and page_namespace = 0
    and pl_title not in (select title from AllMainTitle)
    and page_id in (select math_page_id from AllMathIds)
group by pl_title
order by c desc
limit 10

SQL

Checking query status...