[Bug 59483] DBQ-201 Find Wikimedia Commons files without license
https://bugzilla.wikimedia.org/show_bug.cgi?id=59483 --- Comment #3 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Tim.Landscheidt t...@tim-landscheidt.de Date: Wed, 22 May 2013 22:05:45 --- Run on Tools. -- 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 59483] DBQ-201 Find Wikimedia Commons files without license
https://bugzilla.wikimedia.org/show_bug.cgi?id=59483 --- Comment #1 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Jarek Tuszynski jaroslaw.w.tuszyn...@saic.com Date: Tue, 02 Apr 2013 13:17:20 --- In the mean time while waiting for this query I run several smaller queries with CatScan2 within medium size categories. I identify so far ~3.5k files and added them to http://commons.wikimedia.org/wiki/Category:Media_without_a_license:_needs_history_check for processing. So ideally the query would look for all the files missing the above list of templates and which are not in the Category:Media_without_a_license:_needs_history_check. -- 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 59483] DBQ-201 Find Wikimedia Commons files without license
https://bugzilla.wikimedia.org/show_bug.cgi?id=59483 Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #5 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: t...@tim-landscheidt.de CC list: jaroslaw.w.tuszyn...@leidos.com, t...@tim-landscheidt.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 59483] DBQ-201 Find Wikimedia Commons files without license
https://bugzilla.wikimedia.org/show_bug.cgi?id=59483 --- Comment #4 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Jarek Tuszynski jaroslaw.w.tuszyn...@saic.com Date: Thu, 23 May 2013 13:03:24 --- Thanks a lot. Now I just have to process the results ![][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 59483] DBQ-201 Find Wikimedia Commons files without license
https://bugzilla.wikimedia.org/show_bug.cgi?id=59483 --- Comment #2 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Jarek Tuszynski jaroslaw.w.tuszyn...@saic.com Date: Wed, 22 May 2013 19:44:48 --- the query would be select /* SLOW_OK */ page_title from page where page_is_redirect=0 and page_namespace=6 and not exists (select * from templatelinks where tl_from=page_id and tl_namespace=10 and tl_title in (License_template_tag,PD-Layout,GNU-Layout,CC-Layout,No_license,Delete,Speedydelete) limit 1 ) -- 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