Last modified: 2014-01-03 16:00:37 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-130. Summary: Find files containing string "www.wga.hu" which are not in [[Category:Web Gallery of Art]] Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Jarek Tuszynski <jaroslaw.w.tuszynski@saic.com> Date: Wed, 23 Mar 2011 17:27:14 ------------------------------------------------------------------------------- Find files in Commons containing string "www.wga.hu" which are not in [[Category:Web Gallery of Art]] or its subcategory [[Category:Images from Web Gallery of Art]].
------------------------------------------------------------------------------- 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