SELECT SQL_NO_CACHE g.id, g.nameid, g.name, g.unhacked, guh.unhacked AS guhj, GROUP_CONCAT( m.username
SEPARATOR ', ' ) AS authornames
FROM `games` AS g
LEFT JOIN `game_hacker` AS gh ON g.id = gh.gameid
LEFT JOIN `members` AS m ON gh.userid = m.id
LEFT JOIN `games` AS guh ON guh.nameid = g.nameid
WHERE g.`active` = 'Yes'
AND g.unhacked = '0'
GROUP BY g.`order`
ORDER BY g.`order`