https://bugzilla.wikimedia.org/show_bug.cgi?id=59332

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Jarek Tuszynski <jaroslaw.w.tuszyn...@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

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to