diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-08 16:46:52 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-08 16:46:52 +0100 |
| commit | 224f2c6d951f966e10650bdb9a9969b98c608bcb (patch) | |
| tree | bda4d766fedc229f06da708564c89d761a9effe6 /queries/player.sql | |
| parent | da1af2b1c8822023204e8dc005675423464cc969 (diff) | |
| download | shrinker-224f2c6d951f966e10650bdb9a9969b98c608bcb.tar.gz shrinker-224f2c6d951f966e10650bdb9a9969b98c608bcb.zip | |
cache statements, smart spider, refactor upserts
Diffstat (limited to 'queries/player.sql')
| -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 412bf40..eb0d043 100644 --- a/queries/player.sql +++ b/queries/player.sql @@ -26,7 +26,7 @@ players.player->'data'->'attributes'->>'name' AS "name", (players.player->'data'->'attributes'->'stats'->>'played')::int - (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_casual", (players.player->'data'->'attributes'->'stats'->>'wins')::int AS "wins", (players.player->'data'->'attributes'->'stats'->>'lifetimeGold')::float AS "lifetime_gold", -CASE WHEN players.player->'data'->'attributes'->>'name'=$2 THEN matchdate ELSE 'epoch'::timestamp END AS "last_match_created_date", +matchdate AS "last_match_created_date", 0 AS "streak" |