diff options
| -rw-r--r-- | queries/player.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/queries/player.sql b/queries/player.sql index eb0d043..209aabb 100644 --- a/queries/player.sql +++ b/queries/player.sql @@ -20,7 +20,7 @@ players.player->'data'->>'id' AS "api_id", shardid AS "shard_id", players.player->'data'->'attributes'->>'name' AS "name", (players.player->'data'->'attributes'->'stats'->>'level')::int AS "level", -(players.player->'data'->'attributes'->'stats'->>'xp')::int AS "xp", +(players.player->'data'->'attributes'->'stats'->>'xp')::float::int AS "xp", (players.player->'data'->'attributes'->'stats'->>'played')::int AS "played", (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_ranked", (players.player->'data'->'attributes'->'stats'->>'played')::int - (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_casual", |