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
	WHERE 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

#	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...
