USP_DATALIST_SPONSORSHIPFORMMERCHANTACCOUNTDATALIST

create procedure dbo.USP_DATALIST_SPONSORSHIPFORMMERCHANTACCOUNTDATALIST
(
    @CONTEXTID int
)
as
    set nocount on;

    select top 1 MA.ID, MA.BBPSID 
        from PageContent pc
            inner join dbo.SiteContent sc on sc.ID = pc.SiteContentID
            inner join dbo.SHOPPINGCARTSETTINGS scs on sc.Guid = scs.id
            left join dbo.ClientMerchantAccounts ma on scs.MERCHANTACCOUNTID = ma.BBPSID
        where sc.Deleted = 0 and pc.SitePagesID = @CONTEXTID and sc.ContentTypesID = 9102 -- restrict to payment 2.0 part

        order by pc.ContentOrder