spUserPagesDeleteForRealmContext

  CREATE procedure [dbo].[spUserPagesDeleteForRealmContext]
  (
    @RealmTypeId int,
    @RealmContextId int,
    @CurrentUsersID int = 1
  )
  as

  declare @UserPageID int

  select @UserPageID = up.ID FROM UserPages up
  inner join UserPageManagerPageTemplates upt on up.UserPageTemplateId=upt.ID
  where up.RealmContextId = @RealmContextId and upt.RealmType = @RealmTypeId

  exec dbo.spDelete_UserPages @UserPageID, @CurrentUsersID