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_address IS NULL
#AND   bl_timestamp < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), '%Y%m%d%H%i%s')
ORDER BY bl_timestamp ASC
SQL

Checking query status...
