Untitled query #29721

SQL

SELECT CONCAT('[https://en.wikipedia.org/w/index.php?diff=', rev_id, ']') AS `diff`,
	CONCAT('[[', page_title, ']]') AS `pagename`,
	DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS `timestamp`,
	comment_text AS `comment`
FROM revision_userindex
JOIN page ON page_id = rev_page
JOIN comment ON comment_id = rev_comment_id
WHERE rev_timestamp >= '201902112206'
	AND rev_user_text = 'Sam_Sailor'
	AND page_namespace = 1 -- main space
	AND page_title LIKE '%%'
	AND comment_text RLIKE "cite"
ORDER BY rev_timestamp ASC;
SQL

Checking query status...
