Small audio and video files uploaded since given date

Fork of Images of flags uploaded since given date by Jdx

This query is marked as a draft This query has been published by Jdx.

SQL

USE commonswiki_p;
SELECT	CONCAT('File:', img_name) AS 'File name', DATE_FORMAT(img_timestamp, '%Y-%m-%d %T') AS 'Date', img_size AS 'Size',
		CONCAT('User:', img_user_text) AS 'Uploader\'s name' FROM image
	WHERE img_timestamp>=20180413000000 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')) AND img_size<=384*1000)
                                             OR ((img_media_type='VIDEO' OR img_media_type='MULTIMEDIA') AND img_size<=960*1000))
	ORDER BY img_timestamp DESC;

SQL

Checking query status...