You are browsing a read-only backup copy of Wikitech. The live site can be found at

Obsolete:Tool:Query service/10

From Wikitech-static
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
Approximate run time several hours (because there is no index in img_media_type)


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