https://bugzilla.wikimedia.org/show_bug.cgi?id=59353
Web browser: ---
Bug ID: 59353
Summary: DBQ-101 Templates transcluded on the most User pages
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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.wikipe...@gmail.com>
-------------------------------------------------------------------------------
From: Paolo Massa <ma...@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
--
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
