Matches of Team gazzor Team
game: 2020-12-06 #51350 SBU Winter Weekend Congress S116
 
Team_A Team_B Boards MP_A MP_B VP_A VP_B Butler_NS Butler_EW
Team gazzor   7 22 8 13.15 6.85 -0.69 3.19
Team gazzor Team ahduncan 7 27 14 12.95 7.05 -4.41 6.29
Team gazzor Team DBCEarl 7 20 16 10.99 9.01 -0.13 1.22
Team gazzor Team drroy48 7 2 25 5.24 14.76 -0.15 -2.76
Team gazzor Team hboti 7 13 12 10.25 9.75 0.93 -0.74
Team gazzor Team marmotar 7 57 10 17.89 2.11 2.14 3.84
Team gazzor Team puncher 7 12 14 9.5 10.5 -1.86 1.29
Team gazzor Team vbridger14 7 12 35 5.24 14.76 -2.89 -0.52

*errore=-2147217900 [MySQL][ODBC 5.2(a) Driver][mysqld-5.6.51-91.0-log]Unknown column 's3.teamName' in 'field list' sql=select s3.teamName Team_A, s4.teamName Team_B, s2.Avversari as nodisplay_1, COUNT(*) as Boards, SUM( if(s1.MatchPoints>0,s1.MatchPoints,0)) as MP_A , SUM( if(s1.MatchPoints<0,(0-s1.MatchPoints) ,0)) as MP_B, ' ' as VP_A, ' ' as VP_B, round(avg(s1.Butler),2) Butler_NS, round(avg(s2.Butler),2) Butler_EW from Scores s1 inner join Scores s2 on s1.Torneo = s2.Torneo and s1.Board = s2.Board and s1.Coppia = s2.Coppia and s1.Avversari = s2.Avversari and s1.NS=1 and s2.NS=0 where s1.Torneo='2020-12-06 #51350 SBU Winter Weekend Congress S116' and s1.coppia=15 group by s4.TeamName, s2.Avversari