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
<[email protected]>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
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/commons-l
>
>
_______________________________________________
Commons-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/commons-l