https://bugzilla.wikimedia.org/show_bug.cgi?id=59271

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: AWeenieMan <aweenie...@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;

-- 
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

Reply via email to