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: 0.4240608215332
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034118.2202
            [end] => 1766034118.2205
            [time] => 0.00026106834411621
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1766034118.2226
            [end] => 1766034118.2228
            [time] => 0.00024604797363281
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1766034118.223
            [end] => 1766034118.2232
            [time] => 0.00023293495178223
        )

    [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] => 1766034118.2234
            [end] => 1766034118.226
            [time] => 0.0026578903198242
        )

    [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] => 1766034118.2264
            [end] => 1766034118.2292
            [time] => 0.0027589797973633
        )

    [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] => 1766034118.3139
            [end] => 1766034118.3266
            [time] => 0.012731790542603
        )

    [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 <= 1766034118 OR start >= 1766034118) AND (end >= 1766034118 OR end = 0) AND (start < 1766034118) ORDER BY name ASC
            [start] => 1766034118.3424
            [end] => 1766034118.3434
            [time] => 0.00095605850219727
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1766034118.3435
            [end] => 1766034118.3437
            [time] => 0.00019001960754395
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1766034118.3438
            [end] => 1766034118.3441
            [time] => 0.00022482872009277
        )

    [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] => 1766034118.3442
            [end] => 1766034118.3468
            [time] => 0.0026421546936035
        )

    [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] => 1766034118.3472
            [end] => 1766034118.35
            [time] => 0.002777099609375
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1766034118.4344
            [end] => 1766034118.4348
            [time] => 0.00040888786315918
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1766034118.4358
            [end] => 1766034118.4361
            [time] => 0.00022506713867188
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1766034118.4362
            [end] => 1766034118.4364
            [time] => 0.00022196769714355
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1766034118.4365
            [end] => 1766034118.4367
            [time] => 0.00020694732666016
        )

    [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] => 1766034118.4368
            [end] => 1766034118.4381
            [time] => 0.0012640953063965
        )

    [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] => 1766034118.4384
            [end] => 1766034118.4504
            [time] => 0.011970996856689
        )

    [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] => 1766034118.4506
            [end] => 1766034118.6489
            [time] => 0.19829607009888
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1766034118.6498
            [end] => 1766034118.6501
            [time] => 0.00029683113098145
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1766034118.6502
            [end] => 1766034118.6505
            [time] => 0.00026202201843262
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1766034118.6505
            [end] => 1766034118.6507
            [time] => 0.00021791458129883
        )

    [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] => 1766034118.6508
            [end] => 1766034118.6518
            [time] => 0.00096607208251953
        )

    [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] => 1766034118.652
            [end] => 1766034118.6638
            [time] => 0.011806964874268
        )

    [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] => 1766034118.6639
            [end] => 1766034118.8302
            [time] => 0.16629815101624
        )

    [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] => 1766034118.8305
            [end] => 1766034118.8338
            [time] => 0.0033290386199951
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034118.8368
            [end] => 1766034118.8371
            [time] => 0.00027203559875488
        )

    [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 <= 1766034118 OR start >= 1766034118) AND (end >= 1766034118 OR end = 0) AND (start < 1766034118) ORDER BY name ASC
            [start] => 1766034118.8371
            [end] => 1766034118.8379
            [time] => 0.00078892707824707
        )

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

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

)