[Bug 59291] DBQ-35 Pages that transclude [[w:Template:Talkheader]] with 3 or fewer revisions

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59291

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Daniel Kinzler dan...@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

-- 
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


[Bug 59291] DBQ-35 Pages that transclude [[w:Template:Talkheader]] with 3 or fewer revisions

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59291

Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---

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.kinz...@wikimedia.de

-- 
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


[Bug 59291] DBQ-35 Pages that transclude [[w:Template:Talkheader]] with 3 or fewer revisions

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59291

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Daniel Kinzler dan...@brightbyte.de
Date: Fri, 01 Aug 2008 09:57:21
---

Results are at http://toolserver.org/~daniel/misc/enwiki_talkheader_usage.txt

-- 
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


[Bug 59291] DBQ-35 Pages that transclude [[w:Template:Talkheader]] with 3 or fewer revisions

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59291

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Daniel Kinzler dan...@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.

-- 
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