UFN_GETRESEARCHGROUPSFORCONSTITUENT

            CREATE function dbo.UFN_GETRESEARCHGROUPSFORCONSTITUENT
            (
        @ID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier
            )
            returns table
            as
            return
            (
        select top 10 rg.ID, rg.NAME
        from RESEARCHGROUPMEMBER mem
        left join RESEARCHGROUPLASTVISITED lv
            on mem.RESEARCHGROUPID = lv.RESEARCHGROUPID 
            and lv.APPUSERID = @CURRENTAPPUSERID
        left join RESEARCHGROUP rg
            on mem.RESEARCHGROUPID = rg.ID
        where mem.CONSTITUENTID = @ID
          and dbo.UFN_RESEARCHGROUP_USERCANACCESS(rg.ID, @CURRENTAPPUSERID) = 1
          and dbo.UFN_RESEARCHGROUP_USERHASSITEACCESS(rg.ID, @CURRENTAPPUSERID,'c026c5ca-caa5-4c5d-9c26-0f55cae36a3a',10) = 1
        order by lv.dateaccessed desc, 
            mem.DATEADDED desc
            );