daily pastebin goal
17%
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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top