YUFPADNOF6YVVG7HWMHSAZOQGQJKNWIACI3AS3756MKGZT3P75EQC
4WG6UYDEWOHKZQ6F7EDBWCPEEUDQ4PSYZ74GEJTU5HPFX53FI2TAC
JM67I53CEHEKTEATC2ZQY22YFQEAEPN4R7RUDBQNG66LFQGRFJSAC
7QCJHYB6KSRBFEXLQ7E4ZSBNEZC35FZNLO3FX4IBXO66UJT7GVTAC
6NYILMKIHYQMGMCRZANU2FDO66DGINOMCX2J4JFTUI6VL3HZ6D5QC
BVCWJKEXMTMFIK3UUR6GRQYIYJK25V5IX4HWFFDRXCJMDTRAWY6QC
H7NQUYI6KVTFBUHE5MPM6JF6RF4NKYNIYS3AEIT4M2AO7ESSUPNAC
6BDGQ4VMUAGK5BTJAJVQOGTRHSUOQ5GRRUCZ3M6AVLWKCJNY52HAC
6TPV5GQ3CW6NKF25D6WT2Q2IIRI5N2VMLWUAO2ZMTKIQVUTKYBBAC
5RQCVFRHI353OFKZPVCNJLJLQPEKJVNEDCTM2224U4WABT2YLMQQC
A2LJT7TTVA6XDEQ6N27T7KKFGBH6AMF6KQI6J7AOVUZDLIN6HCMAC
LPK5YJ2DOL4MM4HW4WJHBR57K3DVFHZIOOTBXIHTEDYDPCQCTJTQC
SBYGGRXY42JTOHAXRJMJR5HFAF5EYMI7TISBPDWOVPALW46UCQEAC
YDWTHWAI7RPLW3KGM32J2JVUOSFTW4WOV3XPUMNTU3MDNGMQIOZAC
AEWYJHUD6R45HG4BJSZGH32VJ25H6GU74CL5ZBKI647AKF22HY6QC
B7PYGLH3IXJXPUF7XUBMESMSEH26MEINQJIVMBDDOY4RLT356K4AC
G3VK7RIBLFFCW2DHQEQW3NPTTW6LSBHQ6I7GHDL7IZ2BV5OBTEMAC
C6F7SJZICBIAYP4TXDLS57M6NCB75CYYQ3HVVJG574UPF5JONECQC
GUAEZDLE6V2K4YCXZ333BJ66MESMYSI2Y5HARQLFTISLZUWE2PPQC
TEB4R7OU65GZAGPNINWHOR4Q23OJYVUQK5RT75SV26W7JJEVT5DQC
MCF5COULF5S6UFLIN2LN652D2ROAJGEBZN4Y3TYAQDV4OI26Y7FQC
FUCFD4UVRUXDHG24MYEHF2E5E23BIFVKTRGLNBPBVKFLONVSMHTAC
6CFNBL5LBZNP7CHANCXUZY5RQYREPSR6SQIKIWFLFXS4JU26KIWAC
EVP2FSBHQUCAXQ6IIMBD6IS24ODKHP6HFWYCHIMYG6KOFRQG3RVQC
let stmt = match dbclient.prepare("select g.status::text, g.notes_html, g.fo_forum_url, (select count(*) from games.players p where p.game_uid = g.game_uid and p.client_type = 'p'), MIN(t.turn_ts), MAX(t.turn_ts), COUNT(t.turn) from games.games g left join games.turns t on t.game_uid = g.game_uid where g.game_uid = $1 group by g.game_uid;").await {
let stmt = match dbclient.prepare("select g.status::text, g.notes_html, g.fo_forum_url, g.is_teamed, (select count(*) from games.players p where p.game_uid = g.game_uid and p.client_type = 'p'), MIN(t.turn_ts), MAX(t.turn_ts), COUNT(t.turn) from games.games g left join games.turns t on t.game_uid = g.game_uid where g.game_uid = $1 group by g.game_uid;").await {
let stmt = match dbclient.prepare("select p.player_name, p.delegate_name, p.player_name = $2, p.delegate_name = $2 from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {
let stmt = match dbclient.prepare("select p.player_name, p.team_id, p.create_ts, p.delegate_name, p.player_name = $2, p.delegate_name = $2 from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {
let delegate_name = row.get::<_, Option<String>>(1);
let player_itself = row.get::<_, bool>(2);
let delegate_itself = row.get::<_, Option<bool>>(3).unwrap_or(false);
let team_id = row.get::<_, i32>(1);
let create_ts = row
.get::<_, Option<chrono::NaiveDateTime>>(2)
.map(naive_to_text);
let delegate_name = row.get::<_, Option<String>>(3);
let player_itself = row.get::<_, bool>(4);
let delegate_itself = row.get::<_, Option<bool>>(5).unwrap_or(false);
let stmt = match dbclient.prepare("select p.player_name from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {
let stmt = match dbclient.prepare("select p.player_name, p.team_id from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {