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	CONCAT('File:', REPLACE(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>=TIMESTAMP('2021-12-16 00:00:00') AND (img_minor_mime='png' OR img_minor_mime='svg+xml')
		AND img_name REGEXP '(?:[FfVv]lag|[Bb]and(?:ei?ra|iera)|[Dd]rap(?:o|eau)|[Vv]lajka|[Ee]nsign|[Zz]astava|[Bb]anniel|[Фф]лаг)'
	ORDER BY img_minor_mime DESC, img_timestamp DESC;

SQL

Checking query status...