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@lists.wikimedia.org [mailto:commons-l-bounces@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@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-201 and https://commons.wikimedia.org/wiki/Commons:Village_pump#Search_for_old_files_with_no_licenses but 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_history_check . Can anybody help me out with this?

Jarek T.

User:jarekt

_______________________________________________
Commons-l mailing list
Commons-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/commons-l