UFN_CONSTITUENT_GETSOCIALMEDIAACCOUNTS

CREATE function dbo.UFN_CONSTITUENT_GETSOCIALMEDIAACCOUNTS(@CONSTITUENTID uniqueidentifier)
returns table
as return
    select
        SOCIALMEDIAACCOUNT.ID,
        SOCIALMEDIAACCOUNT.SOCIALMEDIASERVICEID,
        SOCIALMEDIASERVICE.NAME as SOCIALMEDIASERVICENAME,
        SOCIALMEDIAACCOUNT.USERID,
        SOCIALMEDIAACCOUNT.URL,
        SOCIALMEDIAACCOUNT.SOCIALMEDIAACCOUNTTYPECODEID,
        SOCIALMEDIAACCOUNTTYPECODE.DESCRIPTION as SOCIALMEDIAACCOUNTTYPE,
        SOCIALMEDIAACCOUNT.INFOSOURCECODEID,
        INFOSOURCECODE.DESCRIPTION as INFOSOURCE,
        SOCIALMEDIAACCOUNT.DONOTCONTACT,
        SOCIALMEDIAACCOUNT.SEQUENCE
    from
        dbo.SOCIALMEDIAACCOUNT
        inner join dbo.SOCIALMEDIASERVICE on SOCIALMEDIASERVICE.ID = SOCIALMEDIAACCOUNT.SOCIALMEDIASERVICEID
        left join dbo.SOCIALMEDIAACCOUNTTYPECODE on SOCIALMEDIAACCOUNTTYPECODE.ID = SOCIALMEDIAACCOUNT.SOCIALMEDIAACCOUNTTYPECODEID
        left join dbo.INFOSOURCECODE on INFOSOURCECODE.ID = SOCIALMEDIAACCOUNT.INFOSOURCECODEID
    where
        SOCIALMEDIAACCOUNT.CONSTITUENTID=@CONSTITUENTID and
        (WPMATCHCODE = '' or CONFIRMED = 1); --Only display if confirmed, or it was manually added by a user