blob: add926a3704706d09cd07d1631f23d6deeba0848 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SELECT
id AS "apiId",
attributes->>'name' AS "name",
(attributes->'stats'->>'level')::int AS "level",
(attributes->'stats'->>'xp')::int AS "xp",
(attributes->'stats'->>'played')::int AS "played",
(attributes->'stats'->>'played_ranked')::int AS "playedRanked",
(attributes->'stats'->>'played')::int - (attributes->'stats'->>'played_ranked')::int AS "playedCasual",
(attributes->'stats'->>'wins')::int AS "wins",
(attributes->'stats'->>'lifetimeGold')::float AS "lifetimeGold",
0 AS "streak"
FROM player
|
