[Bug 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #11 from Bugzilla Bug Importer (valhallasw) --- 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: cbm.wikipe...@gmail.com, b...@mzmcbride.com, wikimedia-bugzi...@dabpunkt.eu, mi...@misza.net, sxw...@gmail.com -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286
--- Comment #9 from Bugzilla Bug Importer (valhallasw)
---
---
From: CBM
Date: Fri, 15 Aug 2008 22:11:25
---
What went wrong is that the page_namespace in the final subquery was already
limited to equal 2 earlier on, so the subquery can never return any rows.
Here's a query that should generate more useful data:
select concat('[[Template:',t_title,']] ', page_is_redirect)
from (select distinct tl_title as t_title from templatelinks
where tl_namespace = 10) as temp
join page on page_namespace = 10 and page_title = temp.t_title
where not exists
(select 1 from page join templatelinks
on page_id = tl_from and tl_namespace = 10
where tl_title = t_title and page_namespace != 2 );
I put the results at http://toolserver.org/~cbm/data/DBQ-30.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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #8 from Bugzilla Bug Importer (valhallasw) --- --- From: SQL Date: Fri, 15 Aug 2008 19:46:08 --- Interesting, I wonder where I went wrong. -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #10 from Bugzilla Bug Importer (valhallasw) --- --- From: SQL Date: Sat, 16 Aug 2008 04:55:25 --- Appears to have gotten it, thank you CBM ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.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
[Bug 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: Thetrick Date: Mon, 07 Jul 2008 16:45:23 --- Greetings. Is this being worked at all? Thanks. -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #4 from Bugzilla Bug Importer (valhallasw) --- --- From: Thetrick Date: Thu, 10 Jul 2008 21:58:06 --- Hello? -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #5 from Bugzilla Bug Importer (valhallasw) --- --- From: Misza Date: Sun, 13 Jul 2008 11:42:20 --- This strikes me as something that won't work as you expect. For example, most Wikipedia templates are listed (as in, transcluded as an example) somewhere on http://en.wikipedia.org/wiki/Wikipedia:Template_messages - that would be one hell lot of exclusions to hardcode in the query. There can also be other uses - see http://en.wikipedia.org/wiki/Special:WhatLinksHere/Template:Userpage (a typically userspace-only template) and browse through different namespaces to see how often the algorithm fails (there's even one article space use on http://en.wikipedia.org/wiki/Editor:Gangsta36t because someone confused the userspace name). Please confirm that this is indeed what you want (for example, Template:Userpage would **not** be listed in the result). -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: Thetrick Date: Sun, 29 Jun 2008 16:04:50 --- Yes, en.wikipedia.org. Apologies for not being specific. Also, as with DBQ28, how can I get this re-run in a few weeks: ask here, or open a new task? And to further revise and extend, by "user namespace" I mean both the user and user_talk namespaces (2 and 3, I believe). -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #6 from Bugzilla Bug Importer (valhallasw) --- --- From: SQL Date: Wed, 13 Aug 2008 18:00:30 --- Done, see http://toolserver.org/~sql/DBQ/30.txt.gz I agree with the above, however, that you might not find this the most useful thing. Query is at http://toolserver.org/~sql/DBQ/30.sql if anyone needs to rerun it. Takes about half an hour on enwiki_p. -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: DaB. Date: Sun, 29 Jun 2008 15:52:33 --- for enwp? -- 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 59286] DBQ-30 List of templates used only in the user namespace
https://bugzilla.wikimedia.org/show_bug.cgi?id=59286 --- Comment #7 from Bugzilla Bug Importer (valhallasw) --- --- From: MZMcBride Date: Fri, 15 Aug 2008 19:30:17 --- The list generated includes templates like http://en.wikipedia.org/wiki/Template:! and http://en.wikipedia.org/wiki/Template:Ambox Clearly something's borked. -- 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
