BEGIN
Declare ut varchar(2000);
Set @ut = '';
SELECT group_concat(m.name order by m.depth SEPARATOR '.') FROM mastergroups m where FIND_IN_SET(m.groupid,(SELECT CONCAT(Parents,GroupID) from MasterGroups where GroupID=GID)) into @ut;
return ifnull(@ut,'');
END