Login
Login

User:Topbanana/Monthly cleanup talk pages

Overview

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

Regenerating this report

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;