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

       Web browser: ---
            Bug ID: 59434
           Summary: DBQ-166 List of the template categories on en.wiki
                    that do not transclude the Template category template
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: Unprioritized
         Component: Database Queries
          Assignee: wmf.bugconver...@gmail.com
          Reporter: wmf.bugconver...@gmail.com
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from https://jira.toolserver.org/browse/DBQ-166.
Summary: List of the template categories on en.wiki that do not transclude the
Template category template
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: Hoo man <h...@online.de>

-------------------------------------------------------------------------------
From: WOSlinker <c1...@hotmail.com>
Date: Sat, 05 Nov 2011 11:28:45
-------------------------------------------------------------------------------

I'm after a list of the template categories on en.wiki that do not transclude
the Template category template.

I've got a query to run as below.

Thanks.

SELECT page_title  
FROM page AS p  
WHERE page_namespace = 14  
AND (page_title like '%templates%'  
OR page_title like '%navigational_boxes%')  
AND NOT EXISTS (SELECT 1 FROM templatelinks AS tl  
WHERE tl.tl_from = p.page_id  
AND tl.tl_namespace = 10  
AND tl.tl_title = 'Template_category')  
AND NOT EXISTS (SELECT 1 FROM templatelinks AS tl  
WHERE tl.tl_from = p.page_id  
AND tl.tl_namespace = 10  
AND tl.tl_title = 'Category_redirect')

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