From: mauro742 <mauro742@gmail.com>

Date: Sat, 07 Nov 2009 14:30:55

Result: 105312

Query:

select count(*)
from page join categorylinks on page_id = cl_from
join templatelinks on page_title = tl_title and page_namespace = tl_namespace
where cl_to='Creator_templates';

From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com>

Date: Mon, 09 Nov 2009 03:34:45

Thank you for running the query. What I meant is (I think):

select page_title, count![][1]
from page join categorylinks on page_id = cl_from
join templatelinks on page_title = tl_title and page_namespace = tl_namespace
where cl_to='Creator_templates'
group by page_title;

As far as I understand this DB schema the above query would give me number of transclusions for each creator page. I am mainly interested in creator templates with large number of transclusions (lets say above 100) and very few transclusions (~ 0, 1). There are about 4k creator templates and I was hoping to get a list of all 4k with number of transclusions for each.

Thanks again

Jarek

[1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif

From: mauro742 <mauro742@gmail.com>

Date: Tue, 10 Nov 2009 19:39:21

I didn't understand your request. Here the result:

http://toolserver.org/~mauro742/DBQ/DBQ-78.txt

Query:

select concat("Creator:",page_title), count(*) as tot
from page join categorylinks on page_id = cl_from
join templatelinks on page_title = tl_title and page_namespace = tl_namespace
where cl_to='Creator_templates'
and tl_namespace = 100
group by page_id
order by tot desc, page_title;

From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com>

Date: Mon, 03 May 2010 03:09:11

I would like to request a rerun of the final query in order to capture the current status.
Thank you.

From: MZMcBride <mzmcbride@gmail.com>

Date: Mon, 03 May 2010 03:15:11

http://toolserver.org/~mzmcbride/dbq/dbq-78.txt

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: (none)
CC list: b@mzmcbride.com, jaroslaw.w.tuszynski@leidos.com