USP_EMAILLIST_GETSELECTIONS

create procedure dbo.USP_EMAILLIST_GETSELECTIONS
(
    @EMAILLISTS xml
)
as
begin

    declare @EMAILLISTIDS table (ID int)    
    insert into @EMAILLISTIDS
    select Ints.i.value('.', 'int')
    from @EMAILLISTS.nodes('ArrayOfInt/int') Ints(i)    

    select IDSR.DBOBJECTNAME, IDSR.OBJECTTYPE
    from(
            select distinct ELQ.QueryID as ID
            from dbo.EmailList_Query ELQ
            inner join @EMAILLISTIDS EL on EL.ID = ELQ.EmailListID
        )Q
    inner join dbo.BBNCIDSETIDMAP BIDSR on Q.ID = BIDSR.ID
    inner join dbo.IDSETREGISTER IDSR on IDSR.ID = BIDSR.IDSETREGISTERID

end