Last modified: 2014-01-03 16:07:13 UTC
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 <hoo@online.de> ------------------------------------------------------------------------------- From: WOSlinker <c1541@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')
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sun, 06 Nov 2011 18:44:21 ------------------------------------------------------------------------------- Result (using the query exactly as given): http://toolserver.org/~hoo/dbq/dbq-166.txt (plain text)
------------------------------------------------------------------------------- From: WOSlinker <c1541@hotmail.com> Date: Sun, 06 Nov 2011 23:40:31 ------------------------------------------------------------------------------- Thanks.
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: hoo@online.de CC list: hoo@online.de, c1541@hotmail.com