This issue was converted from https://jira.toolserver.org/browse/DBQ-177.
Summary: Items with OTRS permission confirmed on enwiki_p
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: madman <madman@ferretproductions.com>

From: madman <madman@ferretproductions.com>

Date: Fri, 09 Mar 2012 03:43:06

Per http://en.wikipedia.org/w/index.php?title=Wikipedia:OTRS_noticeboard&oldid=480896140#Toolserver_runs:

All files in both Category:Items with OTRS permission confirmed and Category:All non-free media

SELECT page_title
FROM categorylinks
RIGHT JOIN page on cl_from = page_id
WHERE page_namespace = 6
AND cl_to = 'Items_with_OTRS_permission_confirmed'
AND EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to = 'All_non-free_media');

All files that are in Category:Items with OTRS permission confirmed where there is not a Commons file by the same name

Version: unspecified
Severity: minor