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

Campionati: Campionato Eccellenza 2021/2022 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 Hocheti Pokety 39 14 13 1 1232 676 556
2 Rising Titans 39 14 13 1 1117 582 535
3 Iron Lion Tyson 30 14 10 4 837 644 193
4 Meatballs 21 14 7 7 715 656 59
5 Monstars 18 14 6 8 853 782 71
6 Jedi Knights 15 14 5 9 743 829 -86
7 Trefferspan 6 14 2 12 482 867 -385
8 Vinsero Battaglie Chivasso -1 14 0 14 303 1246 -943
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 Simone De Meo
Hocheti Pokety 		336 135 22 14% 5 13 0 0
2 Andrea Vecchiattini
Rising Titans 		296 100 32 24% 1 13 1 0
3 Andrea Merlo
Monstars 		258 87 28 24% 1 14 0 0
4 Ivan Biletta
Rising Titans 		252 102 16 14% 1 14 0 0
5 Paolo Guerra
Meatballs 		225 111 1 1% 1 13 0 0
6 Ramon Rutigliano
Hocheti Pokety 		217 95 9 9% 2 13 0 0
7 Patrick Marzano
Jedi Knights 		199 62 25 29% 0 14 0 0
8 Federico Perno
Iron Lion Tyson 		194 76 14 16% 1 13 2 0
9 Davide Martini
Monstars 		193 74 15 17% 2 13 0 0
10 Edoardo Francesco Stefanelli
Hocheti Pokety 		184 74 12 14% 1 13 0 0
11 Alberto Racco
Hocheti Pokety 		173 67 13 16% 1 10 0 0
12 Giovanni Aquila
Jedi Knights 		169 44 27 38% 1 14 0 0
13 Vincenzo De Felice
Rising Titans 		166 77 4 5% 1 13 0 0
14 Matteo Paccagnini
Rising Titans 		156 48 20 29% 0 12 0 0
15 Paul Mihei
Iron Lion Tyson 		140 64 4 6% 1 14 0 0
16 Emiliano Travaglini
Iron Lion Tyson 		138 57 8 12% 0 11 1 0
17 Alessio Argano
Monstars 		127 53 7 12% 0 14 2 0
18 Simone Poser
Hocheti Pokety 		123 42 13 24% 3 14 0 0
19 Sonnj Dall'ara
Rising Titans 		117 36 15 29% 1 9 0 0
20 Andrea Giannitti
Rising Titans 		116 55 2 4% 2 13 0 0
21 Simone Casale
Jedi Knights 		108 42 8 16% 2 13 0 0
22 Gabriele Bonaldo
Meatballs 		108 48 4 8% 1 13 0 0
23 Federico Listello
Meatballs 		99 45 3 6% 1 12 2 0
24 Roberto Amin Abdou Awad
Iron Lion Tyson 		94 41 4 9% 0 14 2 0
25 Mauro Mola
Meatballs 		83 40 1 2% 0 13 0 0
26 Francesco Rigoni
Iron Lion Tyson 		83 40 1 2% 1 14 0 0
27 Giulio Cocirio
Trefferspan 		79 32 5 14% 1 10 0 0
28 Davide Locatelli
Hocheti Pokety 		77 28 7 20% 0 4 1 0
29 Luca Torreano
Monstars 		76 26 8 24% 0 10 0 0
30 Simone Garino
Iron Lion Tyson 		75 36 1 3% 2 12 0 0
31 Gianluca Parisi
Monstars 		71 31 3 9% 0 9 0 0
32 Jacopo Marchitelli
Trefferspan 		71 34 1 3% 0 10 0 0
33 Emanuele Filiberto Pellegrin
Monstars 		69 33 1 3% 0 10 0 0
34 Marco Gramigna
Jedi Knights 		67 23 7 23% 1 13 0 0
35 Thomas Rovetto
Hocheti Pokety 		60 24 4 14% 1 11 2 0
36 Francesco Croci
Trefferspan 		48 21 2 9% 1 10 0 0
37 Francesco Ghio
Monstars 		47 22 1 4% 1 13 0 0
38 Alessandro Lacqua
Hocheti Pokety 		46 14 6 30% 0 6 0 0
39 Davide Rivetti
Trefferspan 		46 23 0 0 2 10 0 0
40 Alberico Franzin
Iron Lion Tyson 		45 21 1 5% 1 11 3 0
41 Justin Ossai
Trefferspan 		42 18 2 10% 1 9 1 0
42 Mario Franchi
Iron Lion Tyson 		40 20 0 0 2 13 0 0
43 Marco Misilmeri
Jedi Knights 		39 18 1 5% 0 8 0 0
44 Pier Paolo Specchiulli
Trefferspan 		33 15 1 6% 1 7 0 0
45 Alberto Amoruso
Trefferspan 		27 12 1 8% 3 8 0 0
46 Gabriele Di Stefano
Trefferspan 		27 12 1 8% 0 8 0 0
47 Simone Basano
Trefferspan 		26 13 0 0 0 10 0 0
48 Jairo Mattia Agaliati Fadda
Trefferspan 		24 9 2 18% 3 7 2 0
49 Andrea Rossotto
Trefferspan 		20 10 0 0 0 8 0 0
50 Edoardo Di Noia
Trefferspan 		17 7 1 13% 1 8 0 0
51 Samuele Carnelli
Trefferspan 		13 5 1 17% 1 9 0 0
52 Emanuele Preti
Monstars 		9 3 1 25% 0 6 0 0
53 Marco Antonucci
Trefferspan 		4 2 0 0 0 6 1 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 Elena Pasino
Vinsero Battaglie Chivasso 		170 73 8 10% 1 13 0 0
2 Arianna Vismara
Meatballs 		122 61 0 0 1 14 0 0
3 Roberta Binello
Jedi Knights 		76 29 6 17% 1 9 0 0
4 Rossella De Blasio
Meatballs 		50 25 0 0 0 14 0 0
5 Claudia Militello
Vinsero Battaglie Chivasso 		43 20 1 5% 2 13 0 0
6 Francesca Bargelli
Vinsero Battaglie Chivasso 		40 17 2 11% 4 12 0 0
7 Elisa Genovese
Jedi Knights 		20 10 0 0 1 8 0 0
8 Simona Isnardi
Vinsero Battaglie Chivasso 		20 10 0 0 1 11 0 0
9 Sara Sottolano
Meatballs 		18 9 0 0 0 7 0 0
10 SIlvia Petiti
Iron Lion Tyson 		17 7 1 13% 0 13 1 0
11 Sara Panebianco
Vinsero Battaglie Chivasso 		16 8 0 0 2 6 0 0
12 Chiara D'Alessandra
Vinsero Battaglie Chivasso 		8 4 0 0 5 8 0 0
13 Sara Marino
Vinsero Battaglie Chivasso 		0 0 0 0 0 0 0 0
14 Laura Mongi
Jedi Knights 		0 0 0 0 0 5 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 1.5606429576874
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770959779.9866
            [end] => 1770959779.9907
            [time] => 0.0041248798370361
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1770959779.9972
            [end] => 1770959779.9975
            [time] => 0.00031399726867676
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1770959779.9977
            [end] => 1770959779.9979
            [time] => 0.00025796890258789
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2024,2012,1977,1975,1983,2020,1976,1985,1981,2016,2022,2023,2019,2014,2026,2025,1990,2002,1979,2010,2001,2021,1987,1972,1999,1989,2008,2006,2005,1984,2003,1996,2011,1992,2004,2013,2009,1988,1994,1995,1997,1998,1991,1986,2007,1982,1974,2018,2015,1973,1993,2000,2017,1971,1980,1978) order by id ASC
            [start] => 1770959780.0064
            [end] => 1770959780.0134
            [time] => 0.0070910453796387
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2024,2012,1977,1975,1983,2020,1976,1985,1981,2016,2022,2023,2019,2014,2026,2025,1990,2002,1979,2010,2001,2021,1987,1972,1999,1989,2008,2006,2005,1984,2003,1996,2011,1992,2004,2013,2009,1988,1994,1995,1997,1998,1991,1986,2007,1982,1974,2018,2015,1973,1993,2000,2017,1971,1980,1978)
            [start] => 1770959780.4346
            [end] => 1770959780.4947
            [time] => 0.060187101364136
        )

    [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 <= 1770959780 OR start >= 1770959780) AND (end >= 1770959780 OR end = 0) AND (start < 1770959780) ORDER BY name ASC
            [start] => 1770959780.546
            [end] => 1770959780.557
            [time] => 0.010962009429932
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1770959780.557
            [end] => 1770959780.5648
            [time] => 0.0077028274536133
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1770959780.5649
            [end] => 1770959780.5738
            [time] => 0.0088319778442383
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2024,2012,1977,1975,1983,2020,1976,1985,1981,2016,2022,2023,2019,2014,2026,2025,1990,2002,1979,2010,2001,2021,1987,1972,1999,1989,2008,2006,2005,1984,2003,1996,2011,1992,2004,2013,2009,1988,1994,1995,1997,1998,1991,1986,2007,1982,1974,2018,2015,1973,1993,2000,2017,1971,1980,1978) order by id ASC
            [start] => 1770959780.5873
            [end] => 1770959780.605
            [time] => 0.017667055130005
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1770959781.0914
            [end] => 1770959781.0919
            [time] => 0.00043296813964844
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1770959781.0968
            [end] => 1770959781.0987
            [time] => 0.0019040107727051
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1770959781.0989
            [end] => 1770959781.0992
            [time] => 0.00025701522827148
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1770959781.0992
            [end] => 1770959781.0994
            [time] => 0.00020503997802734
        )

    [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 <= 1631885056 OR start >= 1631885056) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (27,6,25,9,24,26,3,10) ORDER BY lastname,firstname ASC
            [start] => 1770959781.0995
            [end] => 1770959781.1008
            [time] => 0.0012588500976562
        )

    [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 = '3') 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] => 1770959781.1012
            [end] => 1770959781.1268
            [time] => 0.025668144226074
        )

    [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 = '3')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1770959781.1271
            [end] => 1770959781.7932
            [time] => 0.6661639213562
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1770959781.794
            [end] => 1770959781.7979
            [time] => 0.0038859844207764
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1770959781.7981
            [end] => 1770959781.7983
            [time] => 0.00023603439331055
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1770959781.7984
            [end] => 1770959781.7985
            [time] => 0.00019383430480957
        )

    [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 <= 1631885056 OR start >= 1631885056) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (27,6,25,9,24,26,3,10) ORDER BY lastname,firstname ASC
            [start] => 1770959781.7986
            [end] => 1770959781.8008
            [time] => 0.0021421909332275
        )

    [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 = '3') 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] => 1770959781.801
            [end] => 1770959781.8412
            [time] => 0.0401771068573
        )

    [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 = '3')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1770959781.8413
            [end] => 1770959782.5054
            [time] => 0.66412687301636
        )

    [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 <= 1631885056 OR start >= 1631885056) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) ORDER BY lastname,firstname ASC
            [start] => 1770959782.5058
            [end] => 1770959782.5147
            [time] => 0.0089771747589111
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1770959782.52
            [end] => 1770959782.5218
            [time] => 0.0018160343170166
        )

    [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 deleted = '0' AND (start = 0 OR start <= 1770959782 OR start >= 1770959782) AND (end >= 1770959782 OR end = 0) AND (start < 1770959782) ORDER BY name ASC
            [start] => 1770959782.5219
            [end] => 1770959782.5246
            [time] => 0.0027120113372803
        )

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

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

)