This issue was converted from https://jira.toolserver.org/browse/DBQ-101.
Summary: Templates transcluded on the most User pages
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: EdoDodo <dodo.wikipedia@gmail.com>
From: Paolo Massa <massa@fbk.eu>
Date: Thu, 09 Sep 2010 12:31:26
I've seen the list of Templates with the most transclusions at http://en.wikipedia.org/wiki/Wikipedia:Database_reports/Templates_transcluded_on_the_most_pages
Very interesting!
The SQL query is at http://en.wikipedia.org/wiki/Wikipedia:Database_reports/Templates_transcluded_on_the_most_pages/Configuration
and I copy and paste it here:
SELECT
tl_title,
COUNT![][1]
FROM templatelinks
WHERE tl_namespace = 10
GROUP BY tl_title
ORDER BY COUNT![][1] DESC
LIMIT 1000;
I would like to see the results of a very similar query, for getting Templates with the most transclusions on pages in namespace User: , and in namespace User_talk: (separately), i.e. two separate lists.
I modify a bit the SQL for the previous query, basically just by changing tl=namespace = 2 (and 3). I don't know if this is correct so I ask you to check .
Query for User:
SELECT
tl_title,
COUNT![][1]
FROM templatelinks
WHERE tl_namespace = 2
GROUP BY tl_title
ORDER BY COUNT![][1] DESC
LIMIT 1000;
Query for User_talk:
SELECT
tl_title,
COUNT![][1]
FROM templatelinks
WHERE tl_namespace = 3
GROUP BY tl_title
ORDER BY COUNT![][1] DESC
LIMIT 1000;
The format can be the same as the original query or a CVS file, it is the same.
[1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif
Version: unspecified
Severity: minor