Query has repeatedly failed to complete. What I have is here: http://pastebin.com/eZDDVHca
Magnus On Sun, Apr 21, 2013 at 4:07 PM, Tuszynski, Jaroslaw W. < jaroslaw.w.tuszyn...@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-boun...@lists.wikimedia.org [mailto: > commons-l-boun...@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.tuszyn...@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_files_with_no_licensesbut > 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**** > > ** ** > > _______________________________________________ > Commons-l mailing list > Commons-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/commons-l > >
_______________________________________________ Commons-l mailing list Commons-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/commons-l