Untitled query #89191

SQL

SELECT
	bt_user_text AS block_target,
    ug_group AS `group`,
    actor_block.actor_name AS blocking_admin,
    DATE_FORMAT(bl_timestamp, '%Y-%m-%d %H:%i') AS block_time,
    CASE WHEN bl_expiry = "infinity"
    	 THEN "infinity"
         ELSE DATE_FORMAT(bl_expiry, '%Y-%m-%d %H:%i')
    END 		 AS block_expiry,
    comment_text AS block_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 bl_timestamp - INTERVAL 2 YEAR
ORDER BY block_time ASC
SQL

Checking query status...
