SELECT sp_getcategorypath(categoryid) AS pagepath FROM category WHERE sp_getoldcategorypath(categoryid) = 'region/auckland/manukau-city/entertainment/restaurants-and-bars'