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
HAVING c > 4
ORDER BY c DESC

SQL

Checking query status...