From: Hoo man <hoo@online.de>

Date: Wed, 23 Mar 2011 20:39:44

There is not even a single file on commons which has the string www.wga.hu in it's file name:

mysql> SELECT * FROM page WHERE page_namespace = 6 AND page_title LIKE "%www.wga.hu%" LIMIT 1;
Empty set (3 min 48.33 sec)

Are you sure that this is the right string? If so, there is nothing to do for me here :/

(same with just wga.hu, btw)

From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com>

Date: Wed, 23 Mar 2011 20:45:17

I meant in the file description not filename.

From: Hoo man <hoo@online.de>

Date: Wed, 23 Mar 2011 20:46:24

Someone told me, that you may mean the image description and not the file name, so I'm going to search in that now.

Thank you for your patience and please excuse my mistake

From: Hoo man <hoo@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

From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com>

Date: Thu, 24 Mar 2011 15:57:29

Thanks a lot I added them all into [[Category:Web Gallery of Art]] now.

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: hoo@online.de, jaroslaw.w.tuszynski@leidos.com