Advertisement
Guest User

Untitled

a guest
Jul 17th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. SELECT_USERS_WITH_STATISTIC(
  2. "SELECT a.userID, a.locked, a.isAdmin, a.nickname, a.email, a.firstname, a.surname, b.wins, b.playedRounds, b.abortedRounds, b.points,"
  3. + " 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,"
  4. + " 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 ,"
  5. + " 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 ,"
  6. + " (SELECT name FROM game_rank WHERE b.points>=pointsFrom AND b.points<=pointTo) AS rankname"
  7. + " FROM game_user AS a NATURAL JOIN game_statistic AS b NATURAL JOIN game_statistic_lastrounds AS c"
  8. + " ORDER BY b.points DESC"),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement