hotfix: filter casual/ranked matches

1 files changed, 1 insertions, 1 deletions

diff --git a/insert.sql b/insert.sql
index df18d80..6ce34a6 100644
--- a/insert.sql
+++ b/insert.sql
@@ -67,7 +67,7 @@ linked_matches AS (
 ),
 -- insert!
 insert_matches AS (
-  INSERT INTO match(id, data) SELECT * FROM linked_matches
+  INSERT INTO match(id, data) SELECT * FROM linked_matches WHERE linked_matches.data->'data'->'attributes'->>'gameMode'='casual' OR linked_matches.data->'data'->'attributes'->>'gameMode'='ranked'
   ON CONFLICT(id) DO NOTHING
   RETURNING id
 )