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