UFN_RE7INTEGRATION_GETSOCIALMEDIAACCOUNTURLS

            CREATE function dbo.UFN_RE7INTEGRATION_GETSOCIALMEDIAACCOUNTURLS(@ID uniqueidentifier)
            returns table
            as
                return 
          select
            SMA.ID,
            SMS.NAME as DESCRIPTION,
            SMA.URL as VALUE,
            SMA.DATEADDED
          from 
            dbo.SOCIALMEDIAACCOUNT SMA
          left join 
            dbo.SOCIALMEDIASERVICE SMS on SMA.SOCIALMEDIASERVICEID = SMS.ID
          where 
            SMA.CONSTITUENTID = @ID
            and SMA.CONFIRMED = 1;