3cb-data

commit da59a3988c9e299ff99079d21c583eb70bc54c25
parent 6374a1e991758c802ea4e8e0c155787474c6403d
Author: alex wennerberg <alex@alexwennerberg.com>
Date:   Thu, 22 Feb 2024 10:06:12 -0500

improve slightly

Diffstat:
M
getdata.py
 | 
1
+
M
sql/export.sql
 | 
2
+-

2 files changed, 2 insertions(+), 1 deletion(-)
diff --git a/getdata.py b/getdata.py
@@ -149,6 +149,7 @@ def best_guess(card):
 
 def replacement(card):
     m = {
+            "Forest!!!!!!": "Forest",
             "Bottomless Depths": "Bottomless Vault",
             "Gargadon (Neither Greater Nor lesser": "Gargadon",
             "Tabernacle at Penrall Vale": "The Tabernacle at Pendrell Value",
diff --git a/sql/export.sql b/sql/export.sql
@@ -45,4 +45,4 @@ on deck.round = ts3.round
 and deck.card3 = ts3.card
 group by 1,2 order by 1 desc, prelim_group,2)
 
-select * from summary;
+select * from summary order by round desc,final_score desc,prelim_score desc,prelim_group,player;