SELECT log_timestamp, log_id, actor_name, log_title, user_editcount, comment_text, log_params

FROM logging

LEFT JOIN user ON user_name = REPLACE(log_title, "_", " ")

JOIN actor ON log_actor = actor_id

LEFT JOIN comment ON log_comment_id = comment_id

WHERE log_timestamp >= 20040101000000 AND log_timestamp < 20250101000000

  AND log_type = "block"

  AND log_action = "block"

  AND comment_id IS NULL;