Images of flags uploaded since given date

Fork of Number of DjVus bigger than 1 MiB since given date by Jdx

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

SQL

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>=20170919000000 AND (img_minor_mime='x-flac' OR img_minor_mime='wav'	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;

SQL

Checking query status...