SELECT sp_getcategorypath(categoryid) AS pagepath FROM category WHERE sp_getoldcategorypath(categoryid) = 'region/hawkes-bay/napier/entertainment/restaurants-and-bars'