https://bugzilla.wikimedia.org/show_bug.cgi?id=59353
--- Comment #1 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: EdoDodo <dodo.wikipe...@gmail.com> Date: Sun, 12 Sep 2010 16:54:56 ------------------------------------------------------------------------------- Hmm... Actually, I think that wouldn't work. That is changing the query to look for transcluded user pages, instead of transcluded templates. I think this query should work: SELECT tl_title, COUNT![][1] FROM templatelinks LEFT JOIN page ON tl_from = page_id WHERE tl_namespace = 10 AND page_namespace = 2 GROUP BY tl_title ORDER BY COUNT![][1] DESC LIMIT 1000; Running it now (along with a slightly modified one for user talk), will post results in a CSV file when it is done. [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