From 224f2c6d951f966e10650bdb9a9969b98c608bcb Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Wed, 8 Mar 2017 16:46:52 +0100
Subject: cache statements, smart spider, refactor upserts

---
 queries/player.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'queries/player.sql')

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"
 
-- 
cgit v1.3.1

