[Bug 59377] DBQ-124 List of template categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=59377 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: WOSlinker Date: Sat, 05 Feb 2011 22:36:01 --- Thanks for running it. Unfortunatly, it didn't quite return the results I was after as it listed all categories with template in the name. The exists part didn't work properly. I think I should have put in an underscore rather than a space. SELECT page_title FROM page AS p WHERE page_namespace = 14 AND page_title like '%template%' AND NOT EXISTS (SELECT 1 FROM templatelinks AS tl WHERE tl.tl_from = p.page_id AND tl.tl_namespace = 10 AND tl.tl_title = 'Template_category') Could you run it again? -- 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 59377] DBQ-124 List of template categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=59377 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man Date: Sat, 05 Feb 2011 22:10:25 --- Your query was fine and I could execute it without any changes ![][1] Results: http://toolserver.org/~hoo/dbq/dbq-124.txt [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 59377] DBQ-124 List of template categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=59377 --- Comment #4 from Bugzilla Bug Importer (valhallasw) --- --- From: WOSlinker Date: Sun, 06 Feb 2011 09:04:38 --- thanks. it was perfect this time. -- 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 59377] DBQ-124 List of template categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=59377 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #5 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: h...@online.de CC list: h...@online.de, c1...@hotmail.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 59377] DBQ-124 List of template categories
https://bugzilla.wikimedia.org/show_bug.cgi?id=59377 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man Date: Sun, 06 Feb 2011 00:28:57 --- I didn't notice that either... mediawiki always converts spaces to underscores in page_titles ![][1] Results: http://toolserver.org/~hoo/dbq/dbq-124.txt [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