- "g.id, g.fen, g.fenStart, g.cadence, g.created, " +
- "g.white, g.black, g.randomness, g.score, g.scoreMsg, " +
- "g.chatReadWhite, g.chatReadBlack, g.drawOffer, " +
- // TODO: vid and vname are redundant
- "g.rematchOffer, v.id as vid, v.name AS vname " +
- "FROM Games g " +
- "JOIN Variants v " +
- " ON g.vid = v.id " +
- "WHERE g.id = " + id;
+ "id, vid, fen, fenStart, cadence, created, " +
+ "white, black, options, score, scoreMsg, " +
+ "chatReadWhite, chatReadBlack, drawOffer, rematchOffer " +
+ "FROM Games " +
+ "WHERE id = " + id;