Untitled query #51435

SQL

USE commonswiki_p;
#SELECT actor_name FROM actor WHERE actor_name='Jdx';
SELECT	CONCAT('File:', page_title)  AS 'File name', DATE_FORMAT(rev_timestamp, '%Y-%m-%d %T') AS 'Date',
        CONCAT('User:', actor_name) AS 'User name', comment_text AS 'Edit summary' FROM revision
        INNER JOIN actor ON rev_actor = actor_id
        INNER JOIN comment ON rev_comment_id = comment_id
        INNER JOIN page ON rev_page = page_id
	WHERE rev_timestamp>=TIMESTAMP('2020-01-01 00:00:00') AND actor_name = 'Jdx'
	ORDER BY rev_timestamp DESC LIMIT 20
#	WHERE comment_text REGEXP '[Ss]plit' AND actor_name = 'Jdx'
#	WHERE actor_name='Jdx'
#	ORDER BY img_minor_mime DESC, img_timestamp DESC;
SQL

Checking query status...
