spGetShoppingCartPartOnPage

        CREATE procedure dbo.spGetShoppingCartPartOnPage (@SitePagesID int) 
        as

        select top 1 cart.ID CartID, cart.MerchantAccountID
        from PageContent pc
        inner join dbo.SiteContent sc on sc.ID = pc.SiteContentID
        inner join dbo.ShoppingCartPart cart on cart.SiteContentID = sc.ID
        where sc.Deleted = 0 and pc.SitePagesID = @SitePagesID and ContentTypesID = 112
        order by pc.ContentOrder;