Matches of Team HelenW RBC Team
game: 2021-09-12 #55699 IOM Isle of Man Congress Sw S100 | |
| Team_A |
Team_B |
Boards |
MP_A |
MP_B |
VP_A |
VP_B |
Butler_NS |
Butler_EW |
| Team HelenW RBC |
|
6 |
22 |
2 |
14.25 |
5.75 |
1.51 |
1.85 |
| Team HelenW RBC |
Team assiac |
6 |
24 |
12 |
12.75 |
7.25 |
-0.3 |
2.45 |
| Team HelenW RBC |
Team craft17 |
6 |
14 |
2 |
12.75 |
7.25 |
1.18 |
0.79 |
| Team HelenW RBC |
Team debbie57 |
6 |
7 |
3 |
10.99 |
9.01 |
-0.89 |
1.76 |
| Team HelenW RBC |
Team fatbunny1 |
6 |
22 |
1 |
14.43 |
5.57 |
2.35 |
1.25 |
| Team HelenW RBC |
Team lizzwizz |
6 |
6 |
14 |
8.1 |
11.9 |
0.21 |
-1.8 |
| Team HelenW RBC |
Team maitennis |
6 |
5 |
15 |
7.67 |
12.33 |
0.18 |
-1.94 |
| Team HelenW RBC |
Team rbgold |
6 |
14 |
3 |
12.54 |
7.46 |
1.81 |
0.17 |
*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='2021-09-12 #55699 IOM Isle of Man Congress Sw S100' and s1.coppia=1 group by s4.TeamName, s2.Avversari