blob: eaf0ed6621956f20a036e2640ae46a971f62167b (
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"
|
