Fetch all category ids and full category paths

category_paths.sql

SELECT
    cce.entity_id AS category_id,
    GROUP_CONCAT(eav.value ORDER BY parent.path ASC SEPARATOR '/') AS category_path
FROM
    catalog_category_entity AS cce
JOIN
    catalog_category_entity AS parent ON cce.path LIKE CONCAT(parent.path, '%')
JOIN
    catalog_category_entity_varchar AS eav ON parent.row_id = eav.row_id
WHERE
    eav.attribute_id = (
        SELECT
            attribute_id
        FROM
            eav_attribute
        WHERE
            attribute_code = 'name' AND entity_type_id = (
                SELECT
                    entity_type_id
                FROM
                    eav_entity_type
                WHERE
                    entity_type_code = 'catalog_category'
            )
    )
GROUP BY
    cce.entity_id
ORDER BY
    cce.path;