Jump to content

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;