select delivery_method_id from notification_delivery_methods select reply_id, type_id from notification_replies order by reply_date delete from notification_email_hold where reply_id = :reply_id