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 Krakens Chivasso 18 14 6 8 853 782 71
6 Padawan 15 14 5 9 743 829 -86
7 AS Intomatici 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
Krakens Chivasso 		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
Padawan 		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
Krakens Chivasso 		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
Padawan 		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
Krakens Chivasso 		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
Padawan 		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
AS Intomatici 		79 32 5 14% 1 10 0 0
28 Davide Locatelli
Hocheti Pokety 		77 28 7 20% 0 4 1 0
29 Luca Torreano
Krakens Chivasso 		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
Krakens Chivasso 		71 31 3 9% 0 9 0 0
32 Jacopo Marchitelli
AS Intomatici 		71 34 1 3% 0 10 0 0
33 Emanuele Filiberto Pellegrin
Krakens Chivasso 		69 33 1 3% 0 10 0 0
34 Marco Gramigna
Padawan 		67 23 7 23% 1 13 0 0
35 Thomas Rovetto
Hocheti Pokety 		60 24 4 14% 1 11 2 0
36 Francesco Croci
AS Intomatici 		48 21 2 9% 1 10 0 0
37 Francesco Ghio
Krakens Chivasso 		47 22 1 4% 1 13 0 0
38 Alessandro Lacqua
Hocheti Pokety 		46 14 6 30% 0 6 0 0
39 Davide Rivetti
AS Intomatici 		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
AS Intomatici 		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
Padawan 		39 18 1 5% 0 8 0 0
44 Pier Paolo Specchiulli
AS Intomatici 		33 15 1 6% 1 7 0 0
45 Alberto Amoruso
AS Intomatici 		27 12 1 8% 3 8 0 0
46 Gabriele Di Stefano
AS Intomatici 		27 12 1 8% 0 8 0 0
47 Simone Basano
AS Intomatici 		26 13 0 0 0 10 0 0
48 Jairo Mattia Agaliati Fadda
AS Intomatici 		24 9 2 18% 3 7 2 0
49 Andrea Rossotto
AS Intomatici 		20 10 0 0 0 8 0 0
50 Edoardo Di Noia
AS Intomatici 		17 7 1 13% 1 8 0 0
51 Samuele Carnelli
AS Intomatici 		13 5 1 17% 1 9 0 0
52 Emanuele Preti
Krakens Chivasso 		9 3 1 25% 0 6 0 0
53 Marco Antonucci
AS Intomatici 		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
Padawan 		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
Padawan 		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
Padawan 		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.58870100975037
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776061551.9485
            [end] => 1776061551.9488
            [time] => 0.00029206275939941
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1776061551.9511
            [end] => 1776061551.9513
            [time] => 0.00022697448730469
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1776061551.9515
            [end] => 1776061551.9518
            [time] => 0.00026392936706543
        )

    [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] => 1776061551.9519
            [end] => 1776061551.9548
            [time] => 0.0028860569000244
        )

    [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] => 1776061551.9551
            [end] => 1776061551.9582
            [time] => 0.0030848979949951
        )

    [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] => 1776061552.0524
            [end] => 1776061552.0657
            [time] => 0.01333212852478
        )

    [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 <= 1776061552 OR start >= 1776061552) AND (end >= 1776061552 OR end = 0) AND (start < 1776061552) ORDER BY name ASC
            [start] => 1776061552.0856
            [end] => 1776061552.0865
            [time] => 0.00095701217651367
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1776061552.0866
            [end] => 1776061552.0868
            [time] => 0.00022792816162109
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1776061552.087
            [end] => 1776061552.0872
            [time] => 0.00023508071899414
        )

    [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] => 1776061552.0873
            [end] => 1776061552.0903
            [time] => 0.0029239654541016
        )

    [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] => 1776061552.0906
            [end] => 1776061552.0938
            [time] => 0.0031170845031738
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1776061552.1874
            [end] => 1776061552.1877
            [time] => 0.00034999847412109
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1776061552.1888
            [end] => 1776061552.1891
            [time] => 0.00034904479980469
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1776061552.1893
            [end] => 1776061552.1895
            [time] => 0.0002439022064209
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1776061552.1895
            [end] => 1776061552.1898
            [time] => 0.00023412704467773
        )

    [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] => 1776061552.1899
            [end] => 1776061552.1912
            [time] => 0.0012869834899902
        )

    [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] => 1776061552.1916
            [end] => 1776061552.2052
            [time] => 0.013659954071045
        )

    [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] => 1776061552.2054
            [end] => 1776061552.4831
            [time] => 0.27768898010254
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1776061552.484
            [end] => 1776061552.4843
            [time] => 0.00033402442932129
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1776061552.4845
            [end] => 1776061552.4848
            [time] => 0.00029206275939941
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1776061552.4848
            [end] => 1776061552.485
            [time] => 0.00021696090698242
        )

    [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] => 1776061552.4851
            [end] => 1776061552.4862
            [time] => 0.0011019706726074
        )

    [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] => 1776061552.4864
            [end] => 1776061552.5002
            [time] => 0.013738870620728
        )

    [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] => 1776061552.5003
            [end] => 1776061552.7457
            [time] => 0.24541401863098
        )

    [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] => 1776061552.746
            [end] => 1776061552.7496
            [time] => 0.0035409927368164
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1776061552.7525
            [end] => 1776061552.7528
            [time] => 0.00030612945556641
        )

    [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 <= 1776061552 OR start >= 1776061552) AND (end >= 1776061552 OR end = 0) AND (start < 1776061552) ORDER BY name ASC
            [start] => 1776061552.7529
            [end] => 1776061552.7537
            [time] => 0.00078392028808594
        )

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

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

)