Last modified: 2014-01-03 16:09:01 UTC
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
------------------------------------------------------------------------------- From: madman <madman@ferretproductions.com> Date: Fri, 09 Mar 2012 05:04:03 ------------------------------------------------------------------------------- https://toolserver.org/~madman/dbq-results/dbq-177a.html https://toolserver.org/~madman/dbq-results/dbq-177b.html
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: madman.enwiki@gmail.com CC list: madman.enwiki@gmail.com