spLoadRecord_UserPages

  CREATE PROCEDURE [dbo].[spLoadRecord_UserPages]
  (
  @PKID int
  )
  AS

  SELECT
  up.ID ,
  up.UserPageTemplateId,
  up.ClientUserId,
  up.RealmContextId,
  up.DisplayName UsersPageName,
  up.IsPublished,
  pt.DisplayName TemplatePageName,
  pt.SitePageID,
  pt.RealmType,
  pt.UserPageManagerID
  FROM UserPages up inner join UserPageManagerPageTemplates pt
  on up.UserPageTemplateId = pt.ID
  WHERE up.Id = @PKID