Found the answer.
Post this into the SQL functions area.
The XXX is the product ID for the item you want to remove the listing for.

delete from back_in_stock_notification_subscriptions where product_id = XXX;