BEGIN
    DECLARE break BOOL;
    DECLARE pid INT;
    DECLARE res CHAR(50);
    SET break = FALSE;
    SET res = '';

    WHILE break = FALSE DO
        SELECT
            parent_id INTO pid
        FROM
            gallery_sections
        WHERE
            id = item_id
        LIMIT 1;

        SET break = TRUE;

        IF pid > 0 THEN
            IF res != '' THEN SET res = CONCAT( res, ',' ); END IF;
            SET res = CONCAT( res, pid );
            SET break = FALSE;
            SET item_id = pid;
        END IF;

    END WHILE;

    RETURN res;

END