I have the following query that is a bit slow, as you can see there are a couple of nested queries in the where clause, can anyone come up with a better solution?

```
SELECT m.briefmedialist, 
       Count(DISTINCT s.value) AS selected, 
       m.briefmedialistid 
FROM   vwmedialistmediachannels m 
       LEFT JOIN sessionfilters s 
              ON s.field = 'Media' 
                 AND m.briefmedialistid = s.value 
                 AND s.sessionid = @SessionID 
WHERE  m.id = (SELECT d.briefid 
               FROM   dashboards d 
               WHERE  d.dashboardguid IN (SELECT value 
                                          FROM   sessionfilters s 
                                          WHERE  s.sessionid = @SessionID 
                                                 AND s.field = 'DashboardID')) 
GROUP  BY m.briefmedialist, 
          m.briefmedialistid 
ORDER  BY m.briefmedialist 

```