Demo, MySQL - rextester

Language: Layout:

drop table if exists player;
drop table if exists player_skills;
drop table if exists skill;

create table player(
  id int primary key
);

create table skill(
  id int primary key,
  title varchar(100)
);

create table player_skills (
  id int primary key,
  player_id int,
  skill_id int,
  value int
);

insert into player values (1), (2);

insert into skill values 
(1, 'one'), (2, 'two'), (3, 'three'), (4,'four'),
(5, 'five'), (6, 'six'), (7, 'seven');

insert into player_skills values 
( 1, 1, 1, 1),
( 2, 1, 2, 2),
( 3, 1, 3, 3),
( 4, 1, 4, 4),
( 5, 1, 5, 5),
( 6, 2, 6, 6),
( 7, 2, 5, 7),
( 8, 2, 3, 8),
( 9, 2, 2, 9),
(10, 2, 7, 9);

select p.id,
	group_concat(s.title separator ', ') as skills
from player p
left join (
	select distinct ps.player_id,
        ps.skill_id,
		@rn := if(@player_id = player_id, @rn+1, if(@player_id := player_id, 1, 1)) as seqnum
	from player_skills ps
	cross join (select @rn := 0, @player_id := null) x
	where ps.value > 2
	order by player_id, value desc
	) ps on p.id = ps.player_id and ps.seqnum <= 3
left join skill s on ps.skill_id = s.id
group by p.id;


absolute service time: 0,53 sec