DBQ-15 All Wanted Categories in en wiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:32 PM

Description

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.

Version: unspecified
Severity: trivial

Details

Reference: bz59271

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:19 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59271.

JiraBugConverter created this task.Jan 3 2014, 3:32 PM

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

DBQ-15 All Wanted Categories in en wikiClosed, ResolvedPublicActions