Untitled query #89191

SQL

SELECT
	bt_user_text AS `Target`,
    ug_group AS `Group`,
    actor_block.actor_name AS `Blocking admin`,
    DATE_FORMAT(bl_timestamp, '%Y-%m-%d %H:%i') AS `Blocked at`,
    CASE WHEN bl_expiry = "infinity"
    	 THEN "never"
         ELSE DATE_FORMAT(bl_expiry, '%Y-%m-%d %H:%i')
    END 		 AS `Block expires`,
    comment_text AS `Reason`
FROM block
INNER JOIN block_target ON bl_target = bt_id
INNER JOIN comment_block ON bl_reason_id = comment_id
INNER JOIN actor_block ON bl_by_actor = actor_id
INNER JOIN user_groups ON bt_user = ug_user
WHERE bt_auto = 0
AND   bt_address IS NULL
WHERE (NOW() - bl_timestamp) > INTERVAL 1 YEAR
ORDER BY block_time ASC
SQL

Checking query status...
