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),
	AllMathTitles AS (SELECT DISTINCT page_title as math_page_title
                   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_title in (select math_page_title from AllMathTitles)
group by pl_title
order by c desc
limit 10;

SQL

Checking query status...