Untitled query #78305

SQL

WITH RECURSIVE stubclass AS (
  SELECT cl.cl_from
  FROM categorylinks cl
  WHERE cl.cl_to = 'Stub-Class_articles'
  UNION
  SELECT cl.cl_from
  FROM categorylinks cl
  INNER JOIN page p ON cl.cl_to = p.page_title AND p.page_namespace = 14
  INNER JOIN stubclass sc ON sc.cl_from = p.page_id
)
-- Non-stub articles with at least one stub-class on talk page
SELECT COUNT(p.page_id)
FROM page p
INNER JOIN page p_talk ON p.page_title = p_talk.page_title AND p_talk.page_namespace = 1
WHERE p.page_namespace = 0
AND p.page_id NOT IN (SELECT cl.cl_from FROM categorylinks cl WHERE cl.cl_to = 'All_stub_articles')
AND p_talk.page_id IN (SELECT sc.cl_from FROM stubclass sc)
LIMIT 1000;

WITH RECURSIVE stubclass AS (
  SELECT cl.cl_from
  FROM categorylinks cl
  WHERE cl.cl_to = 'Stub-Class_articles'
  UNION
  SELECT cl.cl_from
  FROM categorylinks cl
  INNER JOIN page p ON cl.cl_to = p.page_title AND p.page_namespace = 14
  INNER JOIN stubclass sc ON sc.cl_from = p.page_id
)
-- Stub articles with no stub-class on talk page
SELECT COUNT(p.page_id)
FROM page p
INNER JOIN page p_talk ON p.page_title = p_talk.page_title AND p_talk.page_namespace = 1
WHERE p.page_namespace = 0
AND p.page_id IN (SELECT cl.cl_from FROM categorylinks cl WHERE cl.cl_to = 'All_stub_articles')
AND p_talk.page_id NOT IN (SELECT sc.cl_from FROM stubclass sc)
LIMIT 1000;
SQL

Checking query status...
