Club:Fairplay/statisches/test
Aus chessmail Wiki
{{#CSS: thead tr {background-color: ActiveCaption; color: CaptionText;}
th, td {vertical-align: top; font-family: "Tahoma", Arial, Helvetica, sans-serif; font-size: 8pt; padding: 3px; } table, td {border: 1px solid silver;} table {border-collapse: collapse;} thead .col0 {width: 116px;} thead .col1 {width: 51px;} .col1 {text-align: right;} thead .col2 {width: 58px;} .col2 {text-align: right;} thead .col3 {width: 85px;} .col3 {text-align: right;} thead .col4 {width: 58px;} .col4 {text-align: right;}
}}
count(gegner) as anzg, round(sum(ergebnisS)/2,1) as pts, round(count(TurnierNr)/2,1) as anzTurniere, round(100*round(sum(ergebnisS)/2/count(gegner),3),1) as quoti from partien group by gegner order by quoti desc, anzg desc, pts desc;
gegner | anzg | pts | anzTurniere | quoti |
---|---|---|---|---|
zifnab | 34 | 26,5 | 17,0 | 77,9 |
h2m2 | 36 | 26,5 | 18,0 | 73,6 |
alms | 34 | 23,5 | 17,0 | 69,1 |
Priwet | 8 | 5,5 | 4,0 | 68,8 |
Chessking22 | 6 | 4,0 | 3,0 | 66,7 |
nathanDERweise | 26 | 17,0 | 13,0 | 65,4 |
Boeschinski | 4 | 2,5 | 2,0 | 62,5 |
Diebfaenger | 18 | 10,5 | 9,0 | 58,3 |
petraK | 40 | 22,0 | 20,0 | 55,0 |
bumm | 26 | 14,0 | 13,0 | 53,8 |
Lanja | 8 | 4,0 | 4,0 | 50,0 |
Noel.S | 4 | 2,0 | 2,0 | 50,0 |
mira2407 | 40 | 19,0 | 20,0 | 47,5 |
Quarkbeutel | 26 | 12,0 | 13,0 | 46,2 |
Etez | 26 | 12,0 | 13,0 | 46,2 |
SG1951SON | 20 | 9,0 | 10,0 | 45,0 |
DJ_Baheiz | 16 | 7,0 | 8,0 | 43,8 |
Klaus1998 | 6 | 2,0 | 3,0 | 33,3 |
kani | 12 | 3,5 | 6,0 | 29,2 |
Lukas93 | 3 | 0,0 | 1,5 | 0,0 |
pyroman97 | 2 | 0,0 | 1,0 | 0,0 |