This issue was converted from https://jira.toolserver.org/browse/DBQ-124.
Summary: List of template categories
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: Hoo man <hoo@online.de>
From: WOSlinker <c1541@hotmail.com>
Date: Sat, 05 Feb 2011 21:48:25
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 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')
Version: unspecified
Severity: minor