[Bug 59385] DBQ-130 Find files containing string www.wga.hu which are not in [[Category:Web Gallery of Art]]
https://bugzilla.wikimedia.org/show_bug.cgi?id=59385 --- Comment #4 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Hoo man h...@online.de Date: Thu, 24 Mar 2011 13:01:14 --- SQL: SELECT page_title as file FROM image INNER JOIN page ON img_name = page_title WHERE page.page_namespace = 6 AND img_description LIKE '%www.wga.hu%' AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE (categorylinks.cl_to = 'Web_Gallery_of_Art' OR categorylinks.cl_to = 'Images_from_Web_Gallery_of_Art') AND categorylinks.cl_from = page.page_id); Result: http://toolserver.org/~hoo/dbq/dbq-130.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 59385] DBQ-130 Find files containing string www.wga.hu which are not in [[Category:Web Gallery of Art]]
https://bugzilla.wikimedia.org/show_bug.cgi?id=59385 --- Comment #2 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Jarek Tuszynski jaroslaw.w.tuszyn...@saic.com Date: Wed, 23 Mar 2011 20:45:17 --- I meant in the file description not filename. -- 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 59385] DBQ-130 Find files containing string www.wga.hu which are not in [[Category:Web Gallery of Art]]
https://bugzilla.wikimedia.org/show_bug.cgi?id=59385 --- Comment #5 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Jarek Tuszynski jaroslaw.w.tuszyn...@saic.com Date: Thu, 24 Mar 2011 15:57:29 --- Thanks a lot I added them all into [[Category:Web Gallery of Art]] now. -- 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 59385] DBQ-130 Find files containing string www.wga.hu which are not in [[Category:Web Gallery of Art]]
https://bugzilla.wikimedia.org/show_bug.cgi?id=59385 --- Comment #3 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Hoo man h...@online.de Date: Wed, 23 Mar 2011 20:46:24 --- Someone told me, that you may mean the image description and not the file name, so I'm going to search in that now. Thank you for your patience and please excuse my mistake -- 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 59385] DBQ-130 Find files containing string www.wga.hu which are not in [[Category:Web Gallery of Art]]
https://bugzilla.wikimedia.org/show_bug.cgi?id=59385 Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #6 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: h...@online.de CC list: h...@online.de, jaroslaw.w.tuszyn...@leidos.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 59385] DBQ-130 Find files containing string www.wga.hu which are not in [[Category:Web Gallery of Art]]
https://bugzilla.wikimedia.org/show_bug.cgi?id=59385 --- Comment #1 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Hoo man h...@online.de Date: Wed, 23 Mar 2011 20:39:44 --- There is not even a single file on commons which has the string www.wga.hu in it's file name: mysql SELECT * FROM page WHERE page_namespace = 6 AND page_title LIKE %www.wga.hu% LIMIT 1; Empty set (3 min 48.33 sec) Are you sure that this is the right string? If so, there is nothing to do for me here :/ (same with just wga.hu, btw) -- 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
