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 :)
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.comwrote:
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