This query is marked as a draft This query has been published by Uhai.

SQL

x
 
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...