"SELECT m.id, m.text AS medal, m.type, m.img, s.gid
FROM profile_medals_sub AS s
INNER JOIN profile_medals AS m ON ( s.mid = m.id )
"SELECT m.id, m.text AS medal, m.type, m.img, s.gid
FROM profile_medals_sub AS s
INNER JOIN profile_medals AS m ON ( s.mid = m.id )