1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
|
SELECT
hlstats_PlayerNames.playerId as player_id,
hlstats_PlayerNames.name,
hlstats_Players.flag,
hlstats_Players.country,
hlstats_Games.name AS gamename
FROM
hlstats_PlayerNames
LEFT JOIN hlstats_Players ON hlstats_Players.playerId = hlstats_PlayerNames.playerId
LEFT JOIN hlstats_Games ON hlstats_Games.code = hlstats_Players.game
WHERE
hlstats_Games.hidden='0' AND
hlstats_PlayerNames.name LIKE '%iPeon%'
ORDER BY
name asc,
player_id asc
LIMIT 0,50 |