Page MenuHomePhabricator

DBQ-149 Number if transclusions of templates in [[Commons:Category:Institution template stubs]]
Closed, ResolvedPublic

Description

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.


Version: unspecified
Severity: major

Details

Reference
bz59411

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:29 AM
bzimport set Reference to bz59411.

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