SHARE
TWEET

Untitled

a guest Jul 17th, 2017 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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"),
RAW Paste Data
Top