Obsolete:Tool:Query service/10

From Wikitech
Jump to navigation Jump to search

Long audio files on Commons

Description list of all audio files larger than 1MB on Commons.
Assignee Duesentrieb
JIRA bug DBQ-10
Source Query service/long audio files#Query
Results http://tools.wikimedia.de/~daniel/misc/commonswiki-long-audio.txt
Approximate run time several hours (because there is no index in img_media_type)
Interval


Query

select img_name, img_size, img_major_mime, img_minor_mime 
from image 
where img_media_type = "AUDIO" 
and img_size > 1024*1024


This page was moved from toolserver:en:Query service/10. It's edit history can be viewed at Nova Resource:Tools/Tools/Query service/10/edithistory