Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT_USERS_WITH_STATISTIC(
- "SELECT a.userID, a.locked, a.isAdmin, a.nickname, a.email, a.firstname, a.surname, b.wins, b.playedRounds, b.abortedRounds, b.points,"
- + " SELECT f.name AS roundName1 FROM game_round d , game_statistic_lastrounds e, game_playingboard f WHERE e.round1 = d.roundID AND d.playingboardID = f.playingBoardID GROUP BY a.userID,"
- + " SELECT f.name AS roundName2 FROM game_round d , game_statistic_lastrounds e, game_playingboard f WHERE e.round2 = d.roundID AND d.playingboardID = f.playingBoardID ,"
- + " SELECT f.name AS roundName3 FROM game_round d , game_statistic_lastrounds e, game_playingboard f WHERE e.round3 = d.roundID AND d.playingboardID = f.playingBoardID ,"
- + " (SELECT name FROM game_rank WHERE b.points>=pointsFrom AND b.points<=pointTo) AS rankname"
- + " FROM game_user AS a NATURAL JOIN game_statistic AS b NATURAL JOIN game_statistic_lastrounds AS c"
- + " ORDER BY b.points DESC"),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement