Last modified: 2014-01-03 16:04:23 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-149. Summary: Number if transclusions of templates in [[Commons:Category:Institution template stubs]] Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com> Date: Mon, 08 Aug 2011 13:15:36 ------------------------------------------------------------------------------- [[Commons:Category:Institution template stubs]] contains bot created stubs of institution templates (kept in custom namespace "Institution:" `ns:106` ). I would like to know number of transclusions of each of those templates. Should be very similar to https://jira.toolserver.org/browse/DBQ-78 DBQ-78.
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Wed, 17 Aug 2011 16:18:46 ------------------------------------------------------------------------------- SQL: SELECT templatelinks.tl_title as title, COUNT(*) as transclusion_count FROM categorylinks INNER JOIN page ON categorylinks.cl_from = page.page_id INNER JOIN templatelinks ON templatelinks.tl_title = page.page_title AND page.page_namespace = templatelinks.tl_namespace WHERE cl_to = 'Institution_template_stubs' GROUP BY templatelinks.tl_title; Result: http://toolserver.org/~hoo/dbq/dbq-149.txt (plain text)
------------------------------------------------------------------------------- From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com> Date: Mon, 29 Aug 2011 17:31: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, jaroslaw.w.tuszynski@leidos.com