Query has repeatedly failed to complete. What I have is here:
Magnus
On Sun, Apr 21, 2013 at 4:07 PM, Tuszynski, Jaroslaw W. <
JAROSLAW.W.TUSZYNSKI(a)saic.com> wrote:
Thanks. I guess queries looking for images NOT having
some template,
category, etc. are usually slower. I was running that query within
individual categories using CatScan2 and most of the time the query timed
out, got disconnected, or did not succeeded for some other reason. ****
** **
Jarek T.****
User:jarekt****
** **
*From:* commons-l-bounces(a)lists.wikimedia.org [mailto:
commons-l-bounces(a)lists.wikimedia.org] *On Behalf Of *Magnus Manske
*Sent:* Saturday, April 20, 2013 1:49 PM
*To:* Wikimedia Commons Discussion List
*Subject:* Re: [Commons-l] Anybody able to help with database query?****
** **
I'm running it on the toolserver now. Very slow going.****
** **
On Fri, Apr 19, 2013 at 3:57 PM, Tuszynski, Jaroslaw W. <
JAROSLAW.W.TUSZYNSKI(a)saic.com> wrote:****
Hello everybody,****
****
For last month I am trying to find someone that can run a database query
for me. I asked about it at
https://jira.toolserver.org/browse/DBQ-201and
https://commons.wikimedia.org/wiki/Commons:Village_pump#Search_for_old_file…
so far there are no responses.
****
****
The purpose of the query would be to find images with no licenses and in
the simplest case the query would be just for images that do not transclude
{{License template tag}}. In practice I would also like to exclude images
already tagged as no license and exclude images that transclude a Layout
template but were not updated correctly by the database. So a better query
would be images without any of the below templates:****
****
License template tag
PD-Layout
GNU-Layout
CC-Layout
no license
Delete
Speedydelete****
****
You can see images that met this query at
http://commons.wikimedia.org/wiki/Category:Media_without_a_license:_needs_h….
Can anybody help me out with this?
****
****
Jarek T.****
User:jarekt****
_______________________________________________
Commons-l mailing list
Commons-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/commons-l****
** **
_______________________________________________
Commons-l mailing list
Commons-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/commons-l