SELECT

    block_target.bt_address AS "IP",

    actor.actor_name AS "Tài khoản cấm",

    block.bl_timestamp AS "Bắt đầu",

    block.bl_expiry AS "Kết thúc",

    comment.comment_text AS "Lý do"

FROM

    block

INNER JOIN block_target ON

    block.bl_target = block_target.bt_id

INNER JOIN actor ON

    block.bl_by_actor = actor.actor_id

INNER JOIN comment ON

    block.bl_reason_id = comment.comment_id

WHERE

    CURRENT_TIMESTAMP() <= bl_expiry AND

    block_target.bt_address IS NOT NULL

ORDER BY

    actor.actor_name