Untitled query #63864

SQL

SELECT block.log_timestamp, user_name, comment_text
FROM logging block
INNER JOIN user ON user_name = REPLACE(block.log_title, "_", " ")
LEFT JOIN comment ON comment_id = block.log_comment_id
LEFT JOIN logging unblock ON unblock.log_title = block.log_title
                             AND unblock.log_action = block.log_action
                             AND unblock.log_type = block.log_type
	                         AND unblock.log_timestamp - block.log_timestamp < INTERVAL 1 MONTH
WHERE block.log_type = 'block'
	AND block.log_action = 'block'
	AND user_editcount > 10000
	AND block.log_params LIKE '%"infinity"%'
	AND block.log_params NOT LIKE '%::restrictions"%'
    AND unblock.log_id IS NOT NULL
ORDER BY 1 DESC
LIMIT 10
SQL

Checking query status...
