USP_DATALIST_CONSTITUENTPROFILESOCIALMEDIAACCOUNTS

CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILESOCIALMEDIAACCOUNTS
(
    @CONSTITUENTID uniqueidentifier,
    @ISVISIBLE bit = 1
)
as
    set nocount on;

    if @ISVISIBLE = 1
    begin

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

        order by
            SOCIALMEDIAACCOUNT.SEQUENCE;

    end