Untitled query #32792

SQL

WITH MathTitle AS
  (SELECT page_title
   FROM page
   JOIN categorylinks ON cl_from = page_id
   WHERE cl_to in ('High-priority_mathematics_articles',
                   'Low-priority_mathematics_articles',
                   'Mid-priority_mathematics_articles',
                   'NA-priority_mathematics_articles',
                   'Top-priority_mathematics_articles',
                   'Unknown-priority_mathematics_articles')
   LIMIT 30000)
SELECT DISTINCT count(*) as c,
                p1.page_title,
                p1.page_len
FROM page p1
JOIN langlinks ON ll_from = p1.page_id
WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND NOT EXISTS
  	(SELECT 1
     FROM langlinks AS ll
     WHERE ll.ll_from = p1.page_id AND ll.ll_lang = 'hy')
  AND EXISTS
    (SELECT 1
     FROM MathTitle
     WHERE p1.page_title = page_title )
GROUP BY p1.page_id
ORDER BY page_len
LIMIT 100
SQL

Checking query status...
