USP_DATALIST_CLIENTSBYEVENTID

      CREATE procedure dbo.USP_DATALIST_CLIENTSBYEVENTID(@EVENTID uniqueidentifier)
      as
          set nocount on;

          select C.ID, C.NAME
        from dbo.EVENTEXTENSION EE
        INNER JOIN dbo.CLIENTSITES CS On EE.CLIENTSITESID = CS.ID
        INNER JOIN dbo.CLIENTS C On CS.CLIENTSID = C.ID
        WHERE EE.EVENTID = @EVENTID