ISNULL((SELECT SUM(Attendees) AS Expr1 FROM dbo.vw_Bookings WHERE (bookingID IN (SELECT bookingID FROM dbo.bookingsHeader WHERE (scheduleID = s.scheduleID)))), 0)