As you may have noticed, one of the changes in Kentico version 9 is that all page-related views and the View_COM_SKU views were removed from the database with the exception of View_CMS_Tree_Joined, which is used as the base for the querying of page data. This change may have an impact on you if you are using these views in areas such as your custom queries. In this article, we will take a look at how to rewrite such a query to work with version 9.