authorized_destroy_service.rb

MySQL builds on EE were failing due to MySQL not liking the complex
subqueries. Simplify the deletion to use a subquery that works.