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:', actor_name) AS 'Uploader\'s name' FROM image
INNER JOIN actor
ON img_actor = actor_id
WHERE img_timestamp>=20200117000000 AND (img_minor_mime='png' OR img_minor_mime='svg+xml')
AND img_name REGEXP '([FfVv]lag|[Bb]andei?ra|[Dd]rapeau|[Vv]lajka|[Ee]nsign|[Zz]astava|[Фф]лаг)'
ORDER BY img_minor_mime DESC, 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.