Untitled query #90631

SQL

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
JOIN comment ON log_comment_id = comment_id
WHERE log_timestamp >= 20230630235433 AND log_timestamp < 20230801000000
  AND log_type = "block"
  AND log_action = "block"
  -- AND user_editcount >= 5000

AخA
 
SELECT log_timestamp, log_id, actor_name, log_title, user_editcount, comment_text, log_paramsFROM loggingLEFT JOIN user ON user_name = REPLACE(log_title, "_", " ")JOIN actor ON log_actor = actor_idJOIN comment ON log_comment_id = comment_idWHERE log_timestamp >= 20230630235433 AND log_timestamp < 20230801000000  AND log_type = "block"  AND log_action = "block"  -- AND user_editcount >= 5000

SQL

This query has never yet been executed