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(a)gmail.com>wrote;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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/commons-l