Untitled query #51435

SQL

#USE commonswiki_p;
#SELECT * FROM actor WHERE actor_name='Jdx'; # actor_id = 5 for actor_name='Jdx'
#SELECT	comment_text AS 'Edit summary' FROM comment
#	WHERE comment_text REGEXP '^[Ss]plit$'
#	LIMIT 20

#SELECT	rev_id, DATE_FORMAT(rev_timestamp, '%Y-%m-%d %T'), comment_text AS 'Edit summary' FROM comment
#		INNER JOIN revision ON rev_comment_id = comment_id
#	WHERE comment_text = 'Split'
#    ORDER BY rev_timestamp DESC LIMIT 20

#SELECT	rev_id, DATE_FORMAT(rev_timestamp, '%Y-%m-%d %T'), comment_text AS 'Edit summary' FROM revision
#		INNER JOIN comment ON comment_id = rev_comment_id
#SELECT	CONCAT('Special:Diff/', rev_id), DATE_FORMAT(rev_timestamp, '%Y-%m-%d %T') FROM revision
#SELECT	rev_id, DATE_FORMAT(rev_timestamp, '%Y-%m-%d %T') FROM revision
#SELECT	rev_id FROM revision
#	WHERE rev_actor = 5 AND rev_comment_id = 2457330 #OR rev_comment_id = 5288392 OR rev_comment_id = 86631483
#   ORDER BY rev_timestamp DESC LIMIT 20

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 comment_text = 'Split'
	ORDER BY rev_timestamp DESC LIMIT 20
SQL

Checking query status...
