I'm guessing the two correlated subqueries are slowing you down.  Each one is executed once for each row in your result set.  Please post your execution plan for help with a performance issue.  If you need assistance in rewriting the query, please post table DDL in the form of CREATE TABLE statements and sample data in the form of INSERT statements.

John