Last modified: 2014-01-03 15:36:46 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-35. Summary: Pages that transclude [[w:Template:Talkheader]] with 3 or fewer revisions Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Fri, 01 Aug 2008 06:44:45 ------------------------------------------------------------------------------- If possible, it would be great to get a list of all pages on en.wiki that transclude http://en.wikipedia.org/wiki/Template:Talkheader that have 3 or fewer revisions. If it's too database intensive to generate the list, a list of all pages that simply transclude Template:Talkheader will suffice. Thanks!
------------------------------------------------------------------------------- From: Daniel Kinzler <daniel@brightbyte.de> Date: Fri, 01 Aug 2008 08:57:57 ------------------------------------------------------------------------------- The database only tracks links and transclusion for the current revisions. Transclusions for old revisions could only be determined by parsing plain text, which is prohibitively expensive. The only sane way to do somethign like that would be to process a full all-revision xml dump. That would mean writing a specialized tool, and it would still take quite a while to run it (days, i guess) while hogging 100% cpu.
------------------------------------------------------------------------------- From: Daniel Kinzler <daniel@brightbyte.de> Date: Fri, 01 Aug 2008 09:57:21 ------------------------------------------------------------------------------- Results are at http://toolserver.org/~daniel/misc/enwiki_talkheader_usage.txt
------------------------------------------------------------------------------- From: Daniel Kinzler <daniel@brightbyte.de> Date: Fri, 01 Aug 2008 09:58:58 ------------------------------------------------------------------------------- For future reference, the query was: select ns_name, page_title, count(rev_id) as r from page join toolserver.namespace on dbname = "enwiki_p" and ns_id = page_namespace join templatelinks on tl_from = page_id and tl_namespace = 10 and tl_title = "Talkheader" join revision on rev_page = page_id group by page_id having r <= 3
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: b@mzmcbride.com, daniel.kinzler@wikimedia.de