BEGIN

DECLARE _tempPageId INT DEFAULT 0;
DECLARE _path TEXT DEFAULT '';
DECLARE _name TEXT DEFAULT '';

x: LOOP

	IF ISNULL(pageId) THEN
		LEAVE x;
	END IF;
	
	SELECT parent_id, name FROM pages WHERE id = pageId INTO _tempPageId, _name;
	SET pageId = _tempPageId;
	
	SET _path = CONCAT(_name, "/", _path);

END LOOP x;

SELECT _path;

END