Last modified: 2014-01-03 15:32:27 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-15. Summary: All Wanted Categories in en wiki Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: AWeenieMan <AWeenieMan@gmail.com> ------------------------------------------------------------------------------- From: User:Random832@enwiki <random832@fastmail.us> Date: Tue, 04 Mar 2008 21:13:18 ------------------------------------------------------------------------------- A full list of all category names on the English Wikipedia for which there is no category page, and the number of pages included in each category. The special page for this only goes to the top 1000 by number of pages included, I want the complete list.
------------------------------------------------------------------------------- From: AWeenieMan <AWeenieMan@gmail.com> Date: Wed, 05 Mar 2008 01:15:08 ------------------------------------------------------------------------------- Tab separated file. Column 1: Category title Column 2: Number of members in category Column 3: Should be pastable directly into wiki to get similar format as the special page. Total results: 26,684 Runtime: Approx. 25 minutes Query: SELECT cl_to as title, COUNT(*) as value, CONCAT("[[:Category:", cl_to, "]] (", COUNT(*), " members)") as link FROM categorylinks LEFT JOIN page ON cl_to = page_title AND page_namespace = 14 WHERE page_title IS NULL GROUP BY 1;
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: random832@fastmail.us