Wikimedia Bugzilla is closed!

-------------------------------------------------------------------------------
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