DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG

Campionati: Campionato Eccellenza 2022/2023 B2

  1. Home
  2. Campionati
  3. Campionati
Giornata 1
Giornata 2
Giornata 3
Giornata 4
Giornata 5
Giornata 6
Giornata 7
Giornata 8
Giornata 9
Giornata 10
Giornata 11
Giornata 12
Giornata 13
Giornata 14
Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
1 Black Knights 39 14 13 1 1338 880 458
2 Iron Lion Tyson 33 14 11 3 1066 832 234
3 Trefferspan 30 14 10 4 1174 909 265
4 Meatballs 23 14 8 6 818 819 -1
5 Krakens Chivasso 20 14 7 7 1081 1032 49
6 Explichit 13 14 4 10 1052 1145 -93
7 Padawan 9 14 3 11 818 1071 -253
8 Legio X 0 14 0 14 574 1233 -659
Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni
1 Daniele Carbone
Black Knights 		420 150 40 21% 1 13 0 0
2 Jacopo Marchitelli
Trefferspan 		372 171 10 6% 1 14 0 0
3 Giulio Cocirio
Trefferspan 		322 149 8 5% 1 14 0 0
4 Alessio Argano
Krakens Chivasso 		312 135 14 9% 2 14 0 0
5 Luigi Ghirardi
Explichit 		300 117 22 16% 0 14 0 0
6 Davide Martini
Krakens Chivasso 		282 93 32 26% 1 13 0 0
7 Patrick Marzano
Black Knights 		268 86 32 27% 0 14 1 0
8 Paul Mihei
Iron Lion Tyson 		268 104 20 16% 3 13 1 0
9 Emiliano Travaglini
Iron Lion Tyson 		265 101 21 17% 0 12 1 0
10 Paolo Guerra
Meatballs 		256 95 22 19% 1 13 0 0
11 Samuel Romanazzi
Explichit 		226 83 20 19% 2 14 1 0
12 Giovanni Aquila
Padawan 		224 52 40 43% 0 14 0 0
13 Paolo Gazzola
Black Knights 		181 74 11 13% 3 13 0 0
14 Mauro Mola
Meatballs 		179 58 21 27% 0 13 0 0
15 Fabio Bragagnolo
Black Knights 		179 64 17 21% 0 14 2 0
16 Francesco Croci
Trefferspan 		176 64 16 20% 2 13 1 0
17 Andrea Lovera
Padawan 		148 56 12 18% 0 7 0 0
18 Federico Listello
Meatballs 		136 50 12 19% 0 10 0 0
19 Paolo Capomolla
Krakens Chivasso 		131 55 7 11% 3 13 0 0
20 Francesco Luigi Scarfò
Padawan 		127 47 11 19% 2 8 0 0
21 Mattia Allemano
Explichit 		125 40 15 27% 0 13 2 0
22 Mattia Valetti
Black Knights 		113 46 7 13% 1 14 1 0
23 Francesco Rigoni
Iron Lion Tyson 		113 49 5 9% 0 11 0 0
24 Pier Paolo Specchiulli
Legio X 		111 45 7 13% 1 14 0 0
25 Cherif Balde
Iron Lion Tyson 		110 49 4 8% 0 10 0 0
26 Adriano Paribello Grasso
Krakens Chivasso 		109 53 1 2% 0 14 0 0
27 Davide Rivetti
Trefferspan 		107 43 7 14% 3 11 0 0
28 Gabriele Bonaldo
Meatballs 		106 44 6 12% 0 12 3 0
29 Claudio Bonocore
Explichit 		100 29 14 33% 1 12 0 0
30 Simone Basano
Legio X 		100 35 10 22% 0 12 0 0
31 Justin Ossai
Legio X 		99 39 7 15% 0 13 0 0
32 Simone Garino
Iron Lion Tyson 		97 41 5 11% 0 11 0 0
33 Francesco Ghio
Krakens Chivasso 		89 43 1 2% 1 14 0 0
34 Emanuele Filiberto Pellegrin
Krakens Chivasso 		88 44 0 0 0 10 0 0
35 Mattia Gizzi
Explichit 		82 32 6 16% 0 10 1 0
36 Gabriele Di Stefano
Trefferspan 		74 34 2 6% 1 10 0 0
37 Leonardo Specchiulli
Legio X 		72 24 8 25% 1 13 0 0
38 Gaetano De Vaire
Black Knights 		69 24 7 23% 0 13 1 0
39 Roberto Amin Abdou Awad
Iron Lion Tyson 		69 30 3 9% 2 13 0 0
40 Valerio Brocci
Black Knights 		64 23 6 21% 3 11 2 0
41 Emanuele Nigro
Trefferspan 		62 28 2 7% 0 13 0 0
42 Emanuele Preti
Krakens Chivasso 		61 29 1 3% 1 11 0 0
43 Leonardo Morrone
Explichit 		60 21 6 22% 2 12 1 0
44 Alberico Franzin
Iron Lion Tyson 		60 27 2 7% 3 11 1 0
45 Alessio Noto
Legio X 		54 24 2 8% 1 12 1 0
46 Roberto Perrini
Padawan 		53 22 3 12% 1 10 0 0
47 Samuele Carnelli
Legio X 		43 17 3 15% 0 11 0 0
48 Simone Casale
Padawan 		40 14 4 22% 0 7 0 0
49 Edoardo Di Noia
Trefferspan 		39 18 1 5% 2 11 1 0
50 Stefano Zorzan
Explichit 		37 8 7 47% 0 9 0 0
51 Marco Gramigna
Padawan 		36 15 2 12% 0 8 0 0
52 Alberto Amoruso
Trefferspan 		32 13 2 13% 2 4 0 0
53 Lorenzo Marchitelli
Legio X 		25 11 1 8% 3 14 0 0
54 Jairo Mattia Agaliati Fadda
Trefferspan 		24 12 0 0 1 8 0 0
55 Giacomo Pezzuto
Explichit 		20 4 4 50% 1 8 5 0
56 Andrea Rossotto
Legio X 		12 6 0 0 1 7 1 0
57 Marco Antonucci
Legio X 		8 4 0 0 0 4 0 0
58 Valerio Ianniello
Legio X 		6 3 0 0 0 4 0 0
59 Mario Franchi
Iron Lion Tyson 		0 0 0 0 0 3 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni
1 Roberta Binello
Padawan 		147 48 17 26% 1 12 0 0
2 Arianna Vismara
Meatballs 		110 40 10 20% 1 12 0 0
3 Lisa Portarulo
Explichit 		98 43 4 9% 3 14 1 0
4 Mara Ferraris
Black Knights 		34 14 2 13% 0 12 1 0
5 Elisa Genovese
Padawan 		19 8 1 11% 0 13 0 0
6 SIlvia Petiti
Iron Lion Tyson 		19 8 1 11% 1 13 0 0
7 Sara Sottolano
Meatballs 		17 7 1 13% 0 7 0 0
8 Laura Mongi
Padawan 		12 6 0 0 1 11 0 0
9 Rossella De Blasio
Meatballs 		3 0 1 0 0 9 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 2.8599574565887
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776056280.2579
            [end] => 1776056280.2582
            [time] => 0.00032401084899902
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1776056280.2624
            [end] => 1776056280.2626
            [time] => 0.00024914741516113
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1776056280.2628
            [end] => 1776056280.2631
            [time] => 0.00025677680969238
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '12' ORDER BY 
        case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end, 
        round_id+0,
        date+0,
        match_id 
        ASC
            [start] => 1776056280.2632
            [end] => 1776056280.268
            [time] => 0.004849910736084
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2620,2618,2621,2619,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2645,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673) order by id ASC
            [start] => 1776056280.2684
            [end] => 1776056280.2723
            [time] => 0.0039081573486328
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2620,2618,2621,2619,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2645,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673)
            [start] => 1776056280.4717
            [end] => 1776056280.5103
            [time] => 0.038532972335815
        )

    [6] => Array
        (
            [query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
        left join team_to_club on (team.team_id = team_to_club.team_id) where deleted = '0' AND (start = 0 OR start <= 1776056280 OR start >= 1776056280) AND (end >= 1776056280 OR end = 0) AND (start < 1776056280) ORDER BY name ASC
            [start] => 1776056280.6006
            [end] => 1776056280.61
            [time] => 0.0093309879302979
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1776056280.6101
            [end] => 1776056280.6103
            [time] => 0.00027585029602051
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1776056280.6104
            [end] => 1776056280.6107
            [time] => 0.00028300285339355
        )

    [9] => Array
        (
            [query] => select * from matches where championship_id = '12' ORDER BY 
        case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end, 
        round_id+0,
        date+0,
        match_id 
        ASC
            [start] => 1776056280.6109
            [end] => 1776056280.6221
            [time] => 0.011238098144531
        )

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2620,2618,2621,2619,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2645,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673) order by id ASC
            [start] => 1776056280.6225
            [end] => 1776056280.6341
            [time] => 0.011583089828491
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1776056281.3045
            [end] => 1776056281.3158
            [time] => 0.011324882507324
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1776056281.3167
            [end] => 1776056281.3228
            [time] => 0.0060520172119141
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1776056281.3229
            [end] => 1776056281.3328
            [time] => 0.0098819732666016
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1776056281.3328
            [end] => 1776056281.3398
            [time] => 0.0069851875305176
        )

    [15] => Array
        (
            [query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
        left join player_to_team on (player.player_id = player_to_team.player_id) where player.gender = 'male' AND deleted = '0' AND (start = 0 OR start <= 1663340180 OR start >= 1663340180) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (23,43,25,9,40,24,26,27) ORDER BY lastname,firstname ASC
            [start] => 1776056281.3399
            [end] => 1776056281.3461
            [time] => 0.006134033203125
        )

    [16] => Array
        (
            [query] => SELECT player_id, COUNT(player_id) as attendance FROM match_roster  where match_id IN (select match_id from matches where championship_id = '12') AND match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id
            [start] => 1776056281.3465
            [end] => 1776056281.4008
            [time] => 0.054308891296387
        )

    [17] => Array
        (
            [query] => SELECT 
        player_id,
        SUM(
            CASE 
              WHEN point != 'A' THEN point  
            END 
        ) as total,
        
        SUM(
            CASE 
              WHEN point = 'A' THEN 1 
              WHEN point != 'A' THEN 0 
            END 
        ) as autohit,
    
        SUM(
            CASE 
              WHEN point = '3' THEN 1
              WHEN point != '3' THEN 0  
            END 
        ) as defense,
    
        SUM(
            CASE 
              WHEN point = '2' THEN 1 
              WHEN point != '2' THEN 0 
            END 
        ) as attack,
            
        SUM(
            CASE 
              WHEN point = 'P' THEN 1 
              WHEN point != 'P' THEN 0 
            END 
        ) as admonitions,
        
        SUM(
            CASE 
              WHEN point = 'E' THEN 1 
              WHEN point != 'E' THEN 0 
            END 
        ) as expulsions
                
        FROM point WHERE match_id IN (select match_id from matches where championship_id = '12')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1776056281.4011
            [end] => 1776056282.7871
            [time] => 1.3859939575195
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1776056282.7881
            [end] => 1776056282.7885
            [time] => 0.00031900405883789
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1776056282.7886
            [end] => 1776056282.7889
            [time] => 0.00028681755065918
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1776056282.7889
            [end] => 1776056282.7891
            [time] => 0.00021505355834961
        )

    [21] => Array
        (
            [query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
        left join player_to_team on (player.player_id = player_to_team.player_id) where player.gender = 'female' AND deleted = '0' AND (start = 0 OR start <= 1663340180 OR start >= 1663340180) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (23,43,25,9,40,24,26,27) ORDER BY lastname,firstname ASC
            [start] => 1776056282.7892
            [end] => 1776056282.7928
            [time] => 0.0035910606384277
        )

    [22] => Array
        (
            [query] => SELECT player_id, COUNT(player_id) as attendance FROM match_roster  where match_id IN (select match_id from matches where championship_id = '12') AND match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id
            [start] => 1776056282.793
            [end] => 1776056282.86
            [time] => 0.067023038864136
        )

    [23] => Array
        (
            [query] => SELECT 
        player_id,
        SUM(
            CASE 
              WHEN point != 'A' THEN point  
            END 
        ) as total,
        
        SUM(
            CASE 
              WHEN point = 'A' THEN 1 
              WHEN point != 'A' THEN 0 
            END 
        ) as autohit,
    
        SUM(
            CASE 
              WHEN point = '3' THEN 1
              WHEN point != '3' THEN 0  
            END 
        ) as defense,
    
        SUM(
            CASE 
              WHEN point = '2' THEN 1 
              WHEN point != '2' THEN 0 
            END 
        ) as attack,
            
        SUM(
            CASE 
              WHEN point = 'P' THEN 1 
              WHEN point != 'P' THEN 0 
            END 
        ) as admonitions,
        
        SUM(
            CASE 
              WHEN point = 'E' THEN 1 
              WHEN point != 'E' THEN 0 
            END 
        ) as expulsions
                
        FROM point WHERE match_id IN (select match_id from matches where championship_id = '12')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1776056282.8601
            [end] => 1776056284.0603
            [time] => 1.20015001297
        )

    [24] => Array
        (
            [query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
        left join player_to_team on (player.player_id = player_to_team.player_id) where (start = 0 OR start <= 1663340180 OR start >= 1663340180) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) ORDER BY lastname,firstname ASC
            [start] => 1776056284.0605
            [end] => 1776056284.0779
            [time] => 0.017346858978271
        )

    [25] => Array
        (
            [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
            [start] => 1776056284.0798
            [end] => 1776056284.0835
            [time] => 0.0037069320678711
        )

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1776056284.0841
            [end] => 1776056284.0843
            [time] => 0.0002739429473877
        )

    [27] => Array
        (
            [query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
        left join team_to_club on (team.team_id = team_to_club.team_id) where (start = 0 OR start <= 1776056284 OR start >= 1776056284) AND (end >= 1776056284 OR end = 0) AND (start < 1776056284) ORDER BY name ASC
            [start] => 1776056284.0844
            [end] => 1776056284.0853
            [time] => 0.00084686279296875
        )

    [28] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1776056284.0883
            [end] => 1776056284.0921
            [time] => 0.0038399696350098
        )

    [29] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1776056284.0929
            [end] => 1776056284.0937
            [time] => 0.00084495544433594
        )

)