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
AخA
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;
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.