MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION()


VERSION()


10.3.36-MariaDB-1:10.3.36+maria~deb10-log


create table player(
  id int primary key
);
insert into player values 
(1),
(2),
(3);

Records: 3  Duplicates: 0  Warnings: 0


create table skill(
  id int primary key,
  title varchar(100)
);
insert into skill  values
(1, 'one'),
(2, 'two'),
(3, 'three'),
(4, 'four'),
(5, 'five');

Records: 5  Duplicates: 0  Warnings: 0


create table player_skills (
  id int primary key,
  player_id int,
  skill_id int,
  value int
);
insert into player_skills  values 
(1, 1, 1, 4), 
(2, 2, 1, 4),
(3, 2, 2, 2),
(4, 3, 1, 2),
(5, 3, 2, 4),
(6, 3, 3, 4),
(7, 3, 4, 4),
(8, 3, 5, 4);

Records: 8  Duplicates: 0  Warnings: 0


SELECT p.id,  
group_concat(s.title ORDER BY title  SEPARATOR ', ' LIMIT 3) as skills
FROM player p
LEFT JOIN player_skills ps ON ps.player_id = p.id
LEFT JOIN skill s ON s.id = ps.skill_id
WHERE ps.value > 2
group by p.id 
order by s.id


id
skills


1
one

2
one

3
five, four, three