blob: b5c4dffad2cdb9f99c6f5af7495ecbdf7cb4bde1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
SELECT
id AS "apiId",
(attributes->'stats'->>'acesEarned')::int AS "acesEarned",
(attributes->'stats'->>'gold')::int AS "gold",
(attributes->'stats'->>'heroKills')::int AS "heroKills",
(attributes->'stats'->>'krakenCaptures')::int AS "krakenCaptures",
attributes->'stats'->>'side' AS "side",
attributes->'stats'->>'side' AS "teamColor",
(attributes->'stats'->>'turretKills')::int AS "turretKills",
(attributes->'stats'->>'turretsRemaining')::int AS "turretsRemaining",
relationships->'participants'->'data'->0->>'id' AS "participant_1",
relationships->'participants'->'data'->1->>'id' AS "participant_2",
relationships->'participants'->'data'->2->>'id' AS "participant_3"
FROM roster
|
