SQL
AخA
USE commonswiki_p;
#SELECT img_name, img_timestamp, img_size FROM image WHERE img_timestamp>=20170901000000 AND img_minor_mime='x-flac' AND img_size>1*1024*1024 ORDER BY img_timestamp DESC;
SELECT CONCAT('File:', img_name) AS 'File name', DATE_FORMAT(img_timestamp, '%Y-%m-%d %T') AS 'Date', img_size AS 'Size' FROM image
WHERE img_timestamp>=20180102000000 AND (img_minor_mime='x-flac' OR img_minor_mime='wav' OR img_minor_mime='mpeg'
OR (img_media_type="AUDIO" AND img_minor_mime="ogg"))
# WHERE img_timestamp>=20170913000000 AND (img_minor_mime='x-flac' OR img_minor_mime='wav')
ORDER BY img_timestamp DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.