SELECT current_title.path, CONCAT(parent_title.path, '/', pages.current_id) AS new_path, pages.current_id
FROM cms_title AS parent_title
JOIN (
        SELECT parent_page.id AS parent_id, current_page.id AS current_id
        FROM cms_page AS parent_page
        JOIN cms_page AS current_page ON parent_page.lft < current_page.lft AND parent_page.rght > current_page.rght AND parent_page.level = 1
) AS pages ON parent_title.page_id = pages.parent_id
JOIN cms_title AS current_title ON pages.current_id = current_title.page_id
ORDER BY pages.current_id;