Indefinitely blocked users with over 5000 edits (last 30 days)

SQL

SELECT 
    a.actor_name AS user_name,
    u.user_editcount,
    b.bl_timestamp,
    bt.bt_user_text AS block_target_text,
    l.log_action,
    l.log_timestamp AS log_timestamp,
    c.comment_text AS block_comment_text
FROM 
    block b
JOIN 
    actor a
ON 
    b.bl_target = a.actor_id
JOIN 
    user u
ON 
    a.actor_user = u.user_id
LEFT JOIN 
    block
ON 
    b.bl_target = bt.bt_user
LEFT JOIN 
    log l
ON 
    b.bl_id = l.log_page
LEFT JOIN 
    comment c
ON 
    l.log_comment_id = c.comment_id  -- Assuming the comment is linked via log_comment_id
WHERE 
    u.user_editcount >= 10000
    AND b.bl_timestamp >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i%s')
    AND l.log_type = 'block'
    AND l.log_deleted = 0;

SQL

Checking query status...