Untitled query #51435

SQL

USE commonswiki_p;
#SELECT * FROM actor WHERE actor_name='Jdx'; # actor_id = 5 for actor_name='Jdx'
SELECT	CONCAT('File:', page_title)  AS 'File name', DATE_FORMAT(rev_timestamp, '%Y-%m-%d %T') AS 'Date',
        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_actor = 5 AND rev_timestamp>=TIMESTAMP('2020-01-01 00:00:00') AND comment_text REGEXP '[Ss]plit'
	WHERE rev_actor = 5 AND rev_timestamp>=TIMESTAMP('2020-01-01 00:00:00') AND comment_text LIKE 'Split'
	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...
