https://bugzilla.wikimedia.org/show_bug.cgi?id=59385

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Thu, 24 Mar 2011 13:01:14
-------------------------------------------------------------------------------

SQL:

    SELECT page_title as file FROM image INNER JOIN page ON img_name =
page_title WHERE page.page_namespace = 6 AND img_description LIKE
'%www.wga.hu%' AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE
(categorylinks.cl_to = 'Web_Gallery_of_Art' OR categorylinks.cl_to =
'Images_from_Web_Gallery_of_Art') AND categorylinks.cl_from = page.page_id);

Result:  
http://toolserver.org/~hoo/dbq/dbq-130.txt

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to