Actually, it failed after some hours (twice!) with a strange "server not found" error or some such, not a timeout (as would be traditional for the toolserver;-)

Query:

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 )

Magnus

On Mon, Apr 22, 2013 at 5:46 PM, Jean-Frédéric <jeanfrederic.wiki@gmail.com> wrote:

BTW, out of curiosity can you send me SQL for the query. 
Yes, I’d be interested in it as well

(I tried my hand at Jareky request, but not sure if my query failed “as expected” or because it was badly constructed :)
--
Jean-Frédéric
_______________________________________________
Commons-l mailing list
Commons-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/commons-l