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.