Club:Fairplay/statisches/test: Unterschied zwischen den Versionen

Version vom 21. Juni 2013, 21:25 Uhr

{{#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;}

}}

select gegner, 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

@@ Zeile 1: / Zeile 1: @@
-{| class="wikitable sortable"
+{{#CSS:
-!| gegner || anzg || pts || quoti
+thead tr {background-color: ActiveCaption; color: CaptionText;}
-|-
+      th, td {vertical-align: top; font-family: "Tahoma", Arial, Helvetica, sans-serif; font-size: 8pt; padding: 3px; }
-|| zifnab || 34 || 26.5 || 77.9
+      table, td {border: 1px solid silver;}
-|-
+      table {border-collapse: collapse;}
-|| h2m2 || 36 || 26.5 || 73.6
+      thead .col0 {width: 116px;}
-|-
+      thead .col1 {width: 51px;}
-|| alms || 34 || 23.5 || 69.1
+      .col1 {text-align: right;}
-|-
+      thead .col2 {width: 58px;}
-|| Priwet || 8 || 5.5 || 68.8
+      .col2 {text-align: right;}
-|-
+      thead .col3 {width: 85px;}
-|| Chessking22 || 6 || 4.0 || 66.7
+      .col3 {text-align: right;}
-|-
+      thead .col4 {width: 58px;}
-|| nathanDERweise || 26 || 17.0 || 65.4
+      .col4 {text-align: right;}
-|-
+}}
-|| Boeschinski || 4 || 2.5 || 62.5
-|-
-|| Diebfaenger || 18 || 10.5 || 58.3
-|-
-|| petraK || 40 || 22.0 || 55.0
-|-
-|| bumm || 26 || 14.0 || 53.8
-|-
-|| Lanja || 8 || 4.0 || 50.0 ||
-|| Noel.S || 4 || 2.0 || 50.0 ||
-|| mira2407 || 40 || 19.0 || 47.5 ||
-|| Quarkbeutel || 26 || 12.0 || 46.2 ||
-|| Etez || 26 || 12.0 || 46.2 ||
-|| SG1951SON || 20 || 9.0 || 45.0 ||
-|| DJ_Baheiz || 16 || 7.0 || 43.8 ||
-|| Klaus1998 || 6 || 2.0 || 33.3 ||
-|| kani || 12 || 3.5 || 29.2 ||
-|| Lukas93 || 3 || 0.0 || 0.0 ||
-|| pyroman97 || 2 || 0.0 || 0.0 ||
-|}
 ----
 <p style="font-family: monospace; white-space: pre;">select gegner,

Club:Fairplay/statisches/test: Unterschied zwischen den Versionen

Version vom 21. Juni 2013, 21:25 Uhr

Navigationsmenü

Suche