[Bug 59271] DBQ-15 All Wanted Categories in en wiki
https://bugzilla.wikimedia.org/show_bug.cgi?id=59271 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- 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: random...@fastmail.us -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59271] DBQ-15 All Wanted Categories in en wiki
https://bugzilla.wikimedia.org/show_bug.cgi?id=59271
--- Comment #1 from Bugzilla Bug Importer (valhallasw)
---
---
From: AWeenieMan
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;
--
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
