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