blob: 1e6d37fa55c88629aabd14653bfb22336ada1730 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SELECT
match.id AS "apiId",
(match.data->'data'->'attributes'->>'createdAt')::timestamp as "createdAt",
(match.data->'data'->'attributes'->>'duration')::int AS "duration",
match.data->'data'->'attributes'->>'gameMode' AS "gameMode",
COALESCE(NULLIF(match.data->'data'->'attributes'->>'patchVersion', ''), '0') AS "patchVersion",
match.data->'data'->'attributes'->>'shardId' AS "shardId",
match.data->'data'->'attributes'->'stats'->>'endGameReason' AS "endGameReason",
match.data->'data'->'attributes'->'stats'->>'queue' AS "queue",
match.data->'relations'->0->'data'->>'id' as "roster_1",
match.data->'relations'->1->'data'->>'id' as "roster_2"
FROM match WHERE id=$1
|
