USP_DATALIST_SOCIALMEDIAACCOUNT

CREATE procedure dbo.USP_DATALIST_SOCIALMEDIAACCOUNT
(
    @CONSTITUENTID uniqueidentifier
)
as
    set nocount on;

    select 
        SOCIALMEDIAACCOUNT.ID,
        SOCIALMEDIAACCOUNT.USERID as CONTACTINFO,
        SOCIALMEDIASERVICE.NAME,
        SOCIALMEDIAACCOUNTTYPECODE.DESCRIPTION,
        case SOCIALMEDIAACCOUNT.DONOTCONTACT when 1 then 'Do not contact' end as DONOTCONTACT,
        SOCIALMEDIAACCOUNT.URL as MEDIAURL,
        case
            when SOCIALMEDIAACCOUNT.DONOTCONTACT = 1
                then 'RES:warning'
            else
                'RES:lv_spacer'
        end as IMAGEKEY
    from 
        dbo.SOCIALMEDIAACCOUNT
        inner join dbo.SOCIALMEDIASERVICE on SOCIALMEDIAACCOUNT.SOCIALMEDIASERVICEID = SOCIALMEDIASERVICE.ID
        left join dbo.SOCIALMEDIAACCOUNTTYPECODE on SOCIALMEDIAACCOUNT.SOCIALMEDIAACCOUNTTYPECODEID = SOCIALMEDIAACCOUNTTYPECODE.ID
    where 
        CONSTITUENTID = @CONSTITUENTID and
        (WPMATCHCODE = '' or CONFIRMED = 1) --Only display if confirmed, or it was manually added by a user

    order by
        CONTACTINFO;