Delete list member permanently

Permanently removes a list member. Pass ListId and Id (subscriber hash or email) in the WITH clause. Use this when you need to allow resubscription after an archive.

select * from delete_list_member_permanent 
WITH (ListId='a4d24015f8' , Id='170a0722daae03855d6434eb3a5959fb' )