SELECT bl.bt_user_text, bl.bt_address FROM
(SELECT * FROM block
 INNER JOIN block_target ON bl_target = bt_id
 LEFT JOIN ipblocks_restrictions
 ON bl_id = ir_ipb_id) AS bl
LEFT JOIN
(SELECT * FROM ipblocks
 LEFT JOIN ipblocks_restrictions
 ON ipb_id = ir_ipb_id) AS ipb
ON bl.bl_id = ipb.ipb_id
AND (ipb.ipb_address = bl.bt_user_text OR ipb.ipb_address = bl.bt_address)
AND (ipb.ipb_user = bl.bt_user OR ipb.ipb_user = 0)
AND bl.bl_by_actor = ipb.ipb_by_actor AND bl.bl_reason_id = ipb.ipb_reason_id
AND bl.bl_timestamp = ipb.ipb_timestamp AND bl.bl_anon_only = ipb.ipb_anon_only
AND bl.bl_create_account = ipb.ipb_create_account AND bl.bl_sitewide = ipb.ipb_sitewide
AND bl.bl_enable_autoblock = ipb.ipb_enable_autoblock
AND bl.bl_expiry = ipb.ipb_expiry AND bl.bl_deleted = ipb.ipb_deleted
AND bl.bl_block_email = ipb.ipb_block_email AND bl.bl_allow_usertalk = ipb.ipb_allow_usertalk
AND (bl.bl_parent_block_id = ipb.ipb_parent_block_id OR (bl.bl_parent_block_id IS NULL AND (ipb.ipb_parent_block_id IS NULL OR ipb.ipb_parent_block_id = 0)))
AND ((bl.bt_range_start = ipb.ipb_range_start AND bl.bt_range_end = ipb.ipb_range_end) OR (bl.bt_ip_hex = ipb.ipb_range_start) OR (bl.bt_range_start IS NULL AND ipb.ipb_range_start = ""))
AND ((bl.ir_type = ipb.ir_type AND bl.ir_value = ipb.ir_value) OR (bl.ir_type IS NULL AND ipb.ir_type IS NULL AND bl.ir_value IS NULL AND ipb.ir_value IS NULL))
WHERE ipb_id IS NULL;

SELECT ipb_address FROM
(SELECT * FROM ipblocks
 LEFT JOIN ipblocks_restrictions
 ON ipb_id = ir_ipb_id) AS ipb
LEFT JOIN
(SELECT * FROM block
 INNER JOIN block_target ON bl_target = bt_id
 LEFT JOIN ipblocks_restrictions
 ON bl_id = ir_ipb_id) AS bl
ON ipb.ipb_id = bl.bl_id
AND (ipb.ipb_address = bl.bt_user_text OR ipb.ipb_address = bl.bt_address)
AND (ipb.ipb_user = bl.bt_user OR ipb.ipb_user = 0)
AND bl.bl_by_actor = ipb.ipb_by_actor AND bl.bl_reason_id = ipb.ipb_reason_id
AND bl.bl_timestamp = ipb.ipb_timestamp AND bl.bl_anon_only = ipb.ipb_anon_only
AND bl.bl_create_account = ipb.ipb_create_account AND bl.bl_sitewide = ipb.ipb_sitewide
AND bl.bl_enable_autoblock = ipb.ipb_enable_autoblock
AND bl.bl_expiry = ipb.ipb_expiry AND bl.bl_deleted = ipb.ipb_deleted
AND bl.bl_block_email = ipb.ipb_block_email AND bl.bl_allow_usertalk = ipb.ipb_allow_usertalk
AND (bl.bl_parent_block_id = ipb.ipb_parent_block_id OR (bl.bl_parent_block_id IS NULL AND (ipb.ipb_parent_block_id IS NULL OR ipb.ipb_parent_block_id = 0)))
AND ((bl.bt_range_start = ipb.ipb_range_start AND bl.bt_range_end = ipb.ipb_range_end) OR (bl.bt_ip_hex = ipb.ipb_range_start) OR (bl.bt_range_start IS NULL AND ipb.ipb_range_start = ""))
AND ((bl.ir_type = ipb.ir_type AND bl.ir_value = ipb.ir_value) OR (bl.ir_type IS NULL AND ipb.ir_type IS NULL AND bl.ir_value IS NULL AND ipb.ir_value IS NULL))
WHERE bl_id IS NULL;