Page MenuHomePhabricator

DBQ-35 Pages that transclude [[w:Template:Talkheader]] with 3 or fewer revisions
Closed, ResolvedPublic

Description

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!


Version: unspecified
Severity: minor

Details

Reference
bz59291

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:21 AM
bzimport set Reference to bz59291.

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