Error in MYSQL query

Question

I have the following query

select DISTINCT(p.id),g.id, p.slug, p.nome
from game g
join game_plataforma gp on g.id=gp.id_game
join plataformas p on gp.id_plataforma=p.id
group by g.id,p.id,p.slug, p.nome
order by g.id DESC
limit 5;

She returns it here

I’ve tried many ways but I can’t find the mistake.

I want to list the platforms in descending order by the posting date of the games. Already almost does it but I want to group or in case show different, so my list should be

xbox
play4
nintendo3ds

and only show these 3

---

I switched to

    select DISTINCT(p.id), p.slug, p.nome
from game g
join game_plataforma gp on g.id=gp.id_game
join plataformas p on gp.id_plataforma=p.id
group by p.nome
order by g.id DESC
limit 5

and made this mistake

#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'desapego.p.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

http://sqlfiddle.com/#! 9/e6520/4/0 no fidle works