User:Topbanana/Monthly cleanup talk pages

From Wikipedia, the free encyclopedia

Overview[edit]

This report lists talk pages of (direct) subcategories of Category:Monthly clean up category_counter. It wat generated on Tool Labs by TB (talk) 09:59, 21 February 2017 (UTC).

Report[edit]

Regenerating this report[edit]

CREATE TABLE catset ( cs_title varbinary(255) NOT NULL );

INSERT INTO catset VALUES (  'Monthly_clean_up_category_counter' );

REPLACE INTO catset
SELECT page_title
FROM enwiki_p.page
INNER JOIN enwiki_p.categorylinks ON page_id = cl_from
INNER JOIN catset ON cl_to = cs_title
WHERE page_namespace = 14;

SELECT concat( '*[[:Category talk:', page_title, ']]' )
FROM enwiki_p.page
INNER JOIN catset ON page_namespace = 15 and page_title = cs_title;
Retrieved from "https://en.wikipedia.org/w/index.php?title=User:Topbanana/Monthly_cleanup_talk_pages&oldid=1086844781"