Elo BIS 5. pokus - kontroly

mysql> CALL phrac2(24);
+-----------+
| cislo_ela |
+-----------+
|        93 |
+-----------+
1 row in set (0.09 sec)

+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
| ihrace | leg | prijmeni | jmeno | trida | poradi | Elo    | Elo10  | Elomat | vaha  |
+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
|   1829 |  24 | Sajal    | Pavel |     7 |     75 | 548.62 | 548.62 | 550.52 | 78.48 |
+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
1 row in set (0.16 sec)

+-----+---------------------------------------------+------+------+------+----------+-----------------+
| Nr  | nazev                                       | vaha | od   | do   | vysledek | vazena_odchylka |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
| 642 | Mistrovství ČR seniorů                      |  1.8 |    4 |    4 |    58.87 |           40.79 |
| 655 | Švýcarská skupinovka - podzim 2007          | 4.32 |    4 |    4 |    270.5 |          208.02 |
| 658 | Skupinovka Praha A - podzim 2007            |  4.8 |   25 |   26 |       77 |           66.88 |
| 685 | Pražská liga                                | 8.64 |   15 |   15 |        0 |         -200.35 |
| 690 | Švýcarská skupinovka - jaro 2008            | 4.32 |    1 |    1 |    295.5 |          222.54 |
| 687 | Skupinovka Praha A - jaro 2008              |  4.8 |   33 |   34 |       88 |          -54.91 |
| 727 | VC Praha                                    |    2 |    5 |    5 |     57.6 |           93.80 |
| 739 | Mistrovsví ČR seniorů                       |    3 |    8 |    8 |    55.47 |          -15.26 |
| 756 | Skupinovka A BK Praha - podzim 2008         |    8 |   23 |   24 |       76 |          136.74 |
| 757 | Švýcarská skupinovka BK Praha - podzim 2008 |  7.2 |   22 |   22 |      249 |         -186.66 |
| 783 | Pražská liga                                | 14.4 |   13 |   13 |        0 |         -140.18 |
| 784 | Švýcarská skupinovka BK Praha - jaro 2009   |  7.2 |   21 |   21 |    249.5 |          -38.25 |
| 788 | Skupinovka A BK Praha - jaro 2009           |    8 |   33 |   34 |       83 |          -94.92 |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
13 rows in set (0.19 sec)

Query OK, 0 rows affected (0.27 sec)

mysql> CALL phrac2(20);
+-----------+
| cislo_ela |
+-----------+
|        93 |
+-----------+
1 row in set (0.20 sec)

+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
| ihrace | leg | prijmeni | jmeno | trida | poradi | Elo    | Elo10  | Elomat | vaha  |
+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
|     17 |  20 | Peka     | Jan   |     5 |     71 | 551.35 | 551.35 | 553.17 | 71.28 |
+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
1 row in set (0.27 sec)

+-----+---------------------------------------------+------+------+------+----------+-----------------+
| Nr  | nazev                                       | vaha | od   | do   | vysledek | vazena_odchylka |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
| 642 | Mistrovství ČR seniorů                      |  1.8 |    4 |    4 |    58.87 |           39.86 |
| 655 | Švýcarská skupinovka - podzim 2007          | 4.32 |    4 |    4 |    270.5 |          205.79 |
| 658 | Skupinovka Praha A - podzim 2007            |  4.8 |   25 |   26 |       77 |           64.40 |
| 685 | Pražská liga                                | 8.64 |   15 |   15 |        0 |         -204.82 |
| 690 | Švýcarská skupinovka - jaro 2008            | 4.32 |    1 |    1 |    295.5 |          220.30 |
| 687 | Skupinovka Praha A - jaro 2008              |  4.8 |   33 |   34 |       88 |          -57.39 |
| 727 | VC Praha                                    |    2 |    5 |    5 |     57.6 |           92.76 |
| 739 | Mistrovsví ČR seniorů                       |    3 |    8 |    8 |    55.47 |          -16.81 |
| 756 | Skupinovka A BK Praha - podzim 2008         |    8 |   23 |   24 |       76 |          132.60 |
| 757 | Švýcarská skupinovka BK Praha - podzim 2008 |  7.2 |   22 |   22 |      249 |         -190.39 |
| 783 | Pražská liga                                | 14.4 |   13 |   13 |        0 |         -147.63 |
| 788 | Skupinovka A BK Praha - jaro 2009           |    8 |   33 |   34 |       83 |          -99.06 |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
12 rows in set (0.28 sec)

Query OK, 0 rows affected (0.34 sec)

mysql> CALL phrac2(314);
+-----------+
| cislo_ela |
+-----------+
|        93 |
+-----------+
1 row in set (0.13 sec)

+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
| ihrace | leg | prijmeni | jmeno | trida | poradi | Elo    | Elo10  | Elomat | vaha  |
+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
|    242 | 314 | Kurka    | Josef |     7 |      1 | 637.84 | 637.84 | 637.92 | 78.64 |
+--------+-----+----------+-------+-------+--------+--------+--------+--------+-------+
1 row in set (0.16 sec)

+-----+-------------------------------------+------+------+------+----------+-----------------+
| Nr  | nazev                               | vaha | od   | do   | vysledek | vazena_odchylka |
+-----+-------------------------------------+------+------+------+----------+-----------------+
| 629 | VC Praha                            |  1.2 |   12 |   12 |    53.77 |          -81.63 |
| 658 | Skupinovka Praha A - podzim 2007    |  4.8 |    3 |    3 |       79 |           82.70 |
| 667 | Celostátní liga                     | 10.8 |    1 |    1 |        0 |          100.05 |
| 685 | Pražská liga                        | 8.64 |    8 |    8 |        0 |         -340.99 |
| 687 | Skupinovka Praha A - jaro 2008      |  4.8 |    2 |    2 |       93 |           91.83 |
| 756 | Skupinovka A BK Praha - podzim 2008 |    8 |    3 |    3 |       73 |          114.63 |
| 778 | Celostátní liga                     |   18 |    4 |    4 |        0 |         -204.73 |
| 783 | Pražská liga                        | 14.4 |    1 |    1 |        0 |          204.91 |
| 788 | Skupinovka A BK Praha - jaro 2009   |    8 |    4 |    4 |       68 |          101.16 |
+-----+-------------------------------------+------+------+------+----------+-----------------+
9 rows in set (0.30 sec)

Query OK, 0 rows affected (0.36 sec)

mysql> CALL phrac2(341);
+-----------+
| cislo_ela |
+-----------+
|        93 |
+-----------+
1 row in set (0.09 sec)

+--------+-----+----------+--------+-------+--------+--------+--------+--------+--------+
| ihrace | leg | prijmeni | jmeno  | trida | poradi | Elo    | Elo10  | Elomat | vaha   |
+--------+-----+----------+--------+-------+--------+--------+--------+--------+--------+
|    263 | 341 | Svoboda  | Otakar |     7 |     18 | 592.49 | 592.49 | 588.42 | 155.44 |
+--------+-----+----------+--------+-------+--------+--------+--------+--------+--------+
1 row in set (0.13 sec)

+-----+---------------------------------------------+------+------+------+----------+-----------------+
| Nr  | nazev                                       | vaha | od   | do   | vysledek | vazena_odchylka |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
| 620 | VC České Budějovice                         |  1.2 |   19 |   19 |    48.76 |          -61.06 |
| 623 | Tref IMP                                    | 0.48 |   20 |   20 |    -0.31 |          -43.28 |
| 624 | VC Perníkový tref                           |  1.2 |   15 |   15 |     53.7 |          -33.60 |
| 626 | Perník družstva                             | 0.96 |    2 |    2 |      161 |           17.08 |
| 654 | Topové mistrovství ČR Open                  |  3.6 |    8 |    8 |    54.06 |          -63.90 |
| 655 | Švýcarská skupinovka - podzim 2007          | 4.32 |    2 |    2 |    282.5 |           90.42 |
| 658 | Skupinovka Praha A - podzim 2007            |  4.8 |    4 |    4 |       70 |          252.23 |
| 665 | Mistrovství ČR mixů                         |  1.8 |    6 |    6 |    53.94 |          -16.45 |
| 676 | Velká cena Sněžka                           |  1.2 |    2 |    2 |    60.17 |           44.19 |
| 678 | Pohár města Slavonice                       | 1.92 |    4 |    4 |      102 |          -26.43 |
| 667 | Celostátní liga                             | 10.8 |    1 |    1 |        0 |          206.26 |
| 683 | Velká cena Metuje                           |  1.2 |    9 |    9 |    55.33 |            9.64 |
| 685 | Pražská liga                                | 8.64 |    8 |    8 |        0 |         -256.02 |
| 687 | Skupinovka Praha A - jaro 2008              |  4.8 |    5 |    5 |       57 |          191.89 |
| 690 | Švýcarská skupinovka - jaro 2008            | 4.32 |   16 |   16 |    258.5 |         -130.28 |
| 699 | VC Czech Open                               |  1.2 |   19 |   19 |    53.71 |          -34.81 |
| 722 | VC Znojmo                                   |    2 |    4 |    4 |     55.8 |          -41.42 |
| 724 | VC Perníkový tref                           |    2 |    9 |    9 |    55.31 |          -45.62 |
| 727 | VC Praha                                    |    2 |    1 |    1 |    64.86 |          146.40 |
| 737 | VC Kralupy                                  |    2 |   17 |   18 |       50 |          -82.58 |
| 752 | Skupinovka B+C BK Praha - podzim 2008       |    8 |   21 |   21 |      171 |         -700.51 |
| 754 | TOPové mistrovství ČR párů                  |    6 |    4 |    4 |    55.79 |           56.94 |
| 756 | Skupinovka A BK Praha - podzim 2008         |    8 |    1 |    2 |       92 |          313.53 |
| 757 | Švýcarská skupinovka BK Praha - podzim 2008 |  7.2 |    1 |    1 |    305.5 |          109.47 |
| 761 | IMP mistrovství ČR                          |    6 |   18 |   18 |    -0.52 |         -530.39 |
| 771 | Velká cena Sněžka                           |    2 |    5 |    5 |    55.36 |          -12.28 |
| 773 | Mixové mistrvství ČR párů                   |    3 |    5 |    5 |     55.7 |          -38.92 |
| 775 | O pohár města Slavonice                     |  3.2 |    6 |    6 |      133 |          -50.57 |
| 778 | Celostátní liga                             |   18 |    4 |    4 |        0 |          -27.72 |
| 783 | Pražská liga                                | 14.4 |    1 |    1 |        0 |          346.52 |
| 784 | Švýcarská skupinovka BK Praha - jaro 2009   |  7.2 |    2 |    2 |      283 |          100.35 |
| 787 | Velká cena Metuje                           |    2 |    4 |    4 |    55.19 |           33.11 |
| 788 | Skupinovka A BK Praha - jaro 2009           |    8 |    2 |    2 |       87 |          312.17 |
| 801 | VC Czech Open                               |    2 |    1 |    1 |       59 |           47.83 |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
34 rows in set (0.34 sec)

Query OK, 0 rows affected (0.50 sec)

mysql> CALL phrac2(196);
+-----------+
| cislo_ela |
+-----------+
|        93 |
+-----------+
1 row in set (0.06 sec)

+--------+-----+------------+--------+-------+--------+--------+--------+--------+--------+
| ihrace | leg | prijmeni   | jmeno  | trida | poradi | Elo    | Elo10  | Elomat | vaha   |
+--------+-----+------------+--------+-------+--------+--------+--------+--------+--------+
|    147 | 196 | Laštovička | Zdeněk |     6 |     83 | 542.49 | 542.49 | 541.69 | 158.84 |
+--------+-----+------------+--------+-------+--------+--------+--------+--------+--------+
1 row in set (0.14 sec)

+-----+---------------------------------------------+------+------+------+----------+-----------------+
| Nr  | nazev                                       | vaha | od   | do   | vysledek | vazena_odchylka |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
| 620 | VC České Budějovice                         |  1.2 |    4 |    5 |    56.25 |           22.97 |
| 624 | VC Perníkový tref                           |  1.2 |   31 |   31 |    49.41 |          -27.29 |
| 629 | VC Praha                                    |  1.2 |   11 |   11 |    53.92 |           52.23 |
| 630 | kvalifikace IMP                             |  1.8 |   16 |   16 |   -0.667 |         -154.58 |
| 636 | Velká cena Ostrava                          |  1.2 |    4 |    4 |    57.07 |           43.93 |
| 637 | VC Ostrava - družstva                       | 0.96 |    9 |    9 |      129 |          -79.28 |
| 654 | Topové mistrovství ČR Open                  |  3.6 |   12 |   12 |    53.58 |           93.46 |
| 655 | Švýcarská skupinovka - podzim 2007          | 4.32 |   28 |   28 |      243 |          -48.48 |
| 658 | Skupinovka Praha A - podzim 2007            |  4.8 |   33 |   34 |       87 |           33.79 |
| 660 | Mariánkův memoriál                          | 0.48 |   11 |   11 |    53.27 |          -13.55 |
| 665 | Mistrovství ČR mixů                         |  1.8 |   17 |   17 |     46.4 |          -29.74 |
| 667 | Celostátní liga                             | 10.8 |   22 |   22 |        0 |         -475.84 |
| 676 | Velká cena Sněžka                           |  1.2 |   25 |   25 |    48.48 |          -39.97 |
| 678 | Pohár města Slavonice                       | 1.92 |   10 |   10 |      142 |          -26.12 |
| 683 | Velká cena Metuje                           |  1.2 |   22 |   22 |       50 |            3.33 |
| 685 | Pražská liga                                | 8.64 |   14 |   14 |        0 |           58.73 |
| 687 | Skupinovka Praha A - jaro 2008              |  4.8 |   29 |   30 |       57 |           86.55 |
| 690 | Švýcarská skupinovka - jaro 2008            | 4.32 |   28 |   28 |    242.5 |          -96.04 |
| 699 | VC Czech Open                               |  1.2 |   16 |   16 |    54.73 |           56.71 |
| 717 | VC Českých Budějovic                        |    2 |   14 |   14 |    49.22 |          -97.87 |
| 722 | VC Znojmo                                   |    2 |   15 |   15 |    51.65 |           19.56 |
| 724 | VC Perníkový tref                           |    2 |    4 |    4 |     56.1 |          118.45 |
| 727 | VC Praha                                    |    2 |   17 |   17 |    51.73 |           -7.91 |
| 735 | VC Ostrava                                  |    2 |    3 |    3 |    57.44 |           73.56 |
| 737 | VC Kralupy                                  |    2 |    1 |    1 |    59.55 |          181.17 |
| 754 | TOPové mistrovství ČR párů                  |    6 |   28 |   28 |    43.76 |         -169.67 |
| 756 | Skupinovka A BK Praha - podzim 2008         |    8 |   35 |   36 |       73 |          -15.37 |
| 757 | Švýcarská skupinovka BK Praha - podzim 2008 |  7.2 |   21 |   21 |    252.5 |           21.72 |
| 759 | Memoriál Aloise Mariánka                    |  0.8 |   12 |   12 |    51.23 |          -19.30 |
| 761 | IMP mistrovství ČR                          |    6 |   12 |   12 |     0.15 |          -82.94 |
| 771 | Velká cena Sněžka                           |    2 |    1 |    1 |    62.61 |          178.12 |
| 773 | Mixové mistrvství ČR párů                   |    3 |   20 |   20 |       46 |         -130.63 |
| 775 | O pohár města Slavonice                     |  3.2 |   14 |   14 |    168.5 |         -147.54 |
| 778 | Celostátní liga                             |   18 |   11 |   11 |        0 |          307.09 |
| 781 | Olomócký turnaj                             |  1.6 |    3 |    3 |    59.49 |           35.09 |
| 783 | Pražská liga                                | 14.4 |   17 |   17 |        0 |         -149.72 |
| 784 | Švýcarská skupinovka BK Praha - jaro 2009   |  7.2 |    7 |    7 |      260 |          323.63 |
| 787 | Velká cena Metuje                           |    2 |   31 |   31 |    43.65 |          -97.13 |
| 788 | Skupinovka A BK Praha - jaro 2009           |    8 |   25 |   26 |       72 |          237.82 |
| 793 | Malá cena Uherského Hradiště                |  0.8 |    4 |    4 |     55.4 |           -2.66 |
| 801 | VC Czech Open                               |    2 |    8 |    8 |    55.82 |           79.05 |
+-----+---------------------------------------------+------+------+------+----------+-----------------+
41 rows in set (0.27 sec)

Query OK, 0 rows affected (0.42 sec)

mysql> \t


Návrat na hlavní stránku
Návrat na aktuální stránku