Web browser: ---
            Bug ID: 59377
           Summary: DBQ-124 List of template categories
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: Unprioritized
         Component: Database Queries
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from
Summary: List of template categories
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: Hoo man <>

From: WOSlinker <>
Date: Sat, 05 Feb 2011 21:48:25

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

I've got a query although I'm not 100% sure if it is correct:

SELECT page_title  
FROM page AS p  
WHERE page_namespace = 14  
AND page_title like '%template%'  
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')

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to