Matches of Team rednaxela 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 rednaxela |
|
7 |
25 |
16 |
12.12 |
7.88 |
1.53 |
-1.16 |
| Team rednaxela |
Team ahduncan |
7 |
12 |
26 |
6.85 |
13.15 |
-0.74 |
-0.96 |
| Team rednaxela |
Team DBCEarl |
7 |
10 |
19 |
7.88 |
12.12 |
-1.07 |
-0.34 |
| Team rednaxela |
Team dunalister |
7 |
7 |
13 |
8.54 |
11.46 |
1.13 |
-1.83 |
| Team rednaxela |
Team johnny42 |
7 |
17 |
21 |
9.01 |
10.99 |
-0.29 |
-0.42 |
| Team rednaxela |
Team Kernow 147 |
7 |
41 |
22 |
14.08 |
5.92 |
2.5 |
0.92 |
| Team rednaxela |
Team lark20 |
7 |
29 |
18 |
12.54 |
7.46 |
-0.14 |
2.51 |
| Team rednaxela |
Team marmotar |
7 |
28 |
0 |
15.54 |
4.46 |
2.42 |
1.3 |
*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=10 group by s4.TeamName, s2.Avversari