SELECT BonusID FROM ut_bonuses where id= 10 

DELIMITER $$
DROP FUNCTION IF EXISTS `nekki-test`.`bonus`$$
CREATE FUNCTION `nekki-test`.`bonus` (IN_PlayerID int) RETURNS tinytext
DETERMINISTIC

BEGIN

DECLARE a1 TINYTEXT  DEFAULT '';
DECLARE v2 INT DEFAULT  0 ;
set @v1= 0 ;

Set v2=(SELECT count(*) FROM ut_bonuses where Playerid=IN_PlayerID);

  WHILE @v1 < v2 DO
    SET a1 = concat(a1,(SELECT `BonusID` FROM `ut_bonuses` where `PlayerID`=IN_PlayerID limit @v1, 1 ));
    SET @v1 = @v1 +  1 ;
  END WHILE;

return a1;
END$$
DELIMITER ;

limit @v1, 1 ));

SET BonusOUT = COALESCE(
(SELECT GROUP_CONCAT(SmallName_rus, if (Level> 1 ,Level,'') SEPARATOR ' ')
FROM ut_bonuses LEFT JOIN ut_bonus_types USING(BonusID)  where PlayerID=IN_PlayerID
GROUP BY PlayerID),
'');

SET CounBonus=(SELECT count(*) FROM `ut_bonuses` where PlayerID=IN_PlayerID);

if CounBonus> 0  then  SET BonusOUT = (SELECT concat(t.SmallName_eng,if (b.Level> 1 ,b.Level,'')) 
FROM `ut_bonuses` b LEFT OUTER JOIN `ut_bonus_types` t ON t.BonusID = b.BonusID  where b.PlayerID=IN_PlayerID limit  0 , 1 ); end if;

if CounBonus> 1  then  SET BonusOUT = (SELECT concat(BonusOUT,' ',t.SmallName_eng,if (b.Level> 1 ,b.Level,'')) 
FROM `ut_bonuses` b LEFT OUTER JOIN `ut_bonus_types` t ON t.BonusID = b.BonusID  where b.PlayerID=IN_PlayerID limit  1 , 1 ); end if;

if CounBonus> 2  then  SET BonusOUT = (SELECT concat(BonusOUT,' ',t.SmallName_eng,if (b.Level> 1 ,b.Level,'')) 
FROM `ut_bonuses` b LEFT OUTER JOIN `ut_bonus_types` t ON t.BonusID = b.BonusID  where b.PlayerID=IN_PlayerID limit  2 , 1 ); end if;

if CounBonus> 3  then  SET BonusOUT = (SELECT concat(BonusOUT,' ',t.SmallName_eng,if (b.Level> 1 ,b.Level,'')) 
FROM `ut_bonuses` b LEFT OUTER JOIN `ut_bonus_types` t ON t.BonusID = b.BonusID  where b.PlayerID=IN_PlayerID limit  3 , 1 ); end if;

if CounBonus> 4  then  SET BonusOUT = (SELECT concat(BonusOUT,' ',t.SmallName_eng,if (b.Level> 1 ,b.Level,'')) 
FROM `ut_bonuses` b LEFT OUTER JOIN `ut_bonus_types` t ON t.BonusID = b.BonusID  where b.PlayerID=IN_PlayerID limit  4 , 1 ); end if;