USP_DATALIST_BBNC_DONATIONFORM_BYSITEPAGEID

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

          select top 1 part.ID, part.ContentID, coalesce(ma.ID, 0), ma.BBPSID, coalesce(part.ShoppingCartPageID, 0) 
        from PageContent pc
            inner join dbo.SiteContent sc on sc.ID = pc.SiteContentID
            inner join dbo.ClientDonations part on part.ContentID = sc.ID
            left join dbo.ClientMerchantAccounts ma on part.MerchantAccount = ma.ID
        where sc.Deleted = 0 and pc.SitePagesID = @CONTEXTID and sc.ContentTypesID = 45
        order by pc.ContentOrder;