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

Campionati: Campionato Eccellenza 2021/2022 B2

  1. Home
  2. Campionati
  3. Campionati

Sabato 06-11-2021

Mercoledì 10-11-2021

Giovedì 11-11-2021

Venerdì 12-11-2021

Martedì 16-11-2021

Venerdì 19-11-2021

Sabato 20-11-2021

Martedì 23-11-2021

Sabato 27-11-2021

Martedì 30-11-2021

Mercoledì 01-12-2021

Sabato 11-12-2021

Domenica 12-12-2021

Martedì 21-12-2021

Mercoledì 22-12-2021

Martedì 15-02-2022

Mercoledì 16-02-2022

Sabato 19-02-2022

Giovedì 24-02-2022

Venerdì 25-02-2022

Sabato 12-03-2022

Domenica 13-03-2022

Martedì 15-03-2022

Giovedì 17-03-2022

Sabato 26-03-2022

Domenica 27-03-2022

Martedì 29-03-2022

Mercoledì 30-03-2022

Sabato 09-04-2022

Sabato 23-04-2022

Domenica 24-04-2022

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.52556586265564
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781154483.7992
            [end] => 1781154483.7995
            [time] => 0.00029993057250977
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1781154483.8019
            [end] => 1781154483.8021
            [time] => 0.00021910667419434
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1781154483.8022
            [end] => 1781154483.8025
            [time] => 0.00026082992553711
        )

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

    [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] => 1781154483.806
            [end] => 1781154483.8094
            [time] => 0.003385066986084
        )

    [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] => 1781154483.9196
            [end] => 1781154483.9338
            [time] => 0.014203071594238
        )

    [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 <= 1781154483 OR start >= 1781154483) AND (end >= 1781154483 OR end = 0) AND (start < 1781154483) ORDER BY name ASC
            [start] => 1781154483.9546
            [end] => 1781154483.9558
            [time] => 0.0011742115020752
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1781154483.9559
            [end] => 1781154483.9561
            [time] => 0.00022697448730469
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1781154483.9562
            [end] => 1781154483.9565
            [time] => 0.0002439022064209
        )

    [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] => 1781154483.9566
            [end] => 1781154483.9594
            [time] => 0.0028040409088135
        )

    [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] => 1781154483.9598
            [end] => 1781154483.9632
            [time] => 0.0033841133117676
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1781154484.0731
            [end] => 1781154484.0735
            [time] => 0.0004279613494873
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1781154484.0745
            [end] => 1781154484.0747
            [time] => 0.00021219253540039
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1781154484.0749
            [end] => 1781154484.0751
            [time] => 0.00023984909057617
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1781154484.0751
            [end] => 1781154484.0753
            [time] => 0.00020098686218262
        )

    [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] => 1781154484.0754
            [end] => 1781154484.0771
            [time] => 0.001633882522583
        )

    [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] => 1781154484.0774
            [end] => 1781154484.0954
            [time] => 0.018001079559326
        )

    [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] => 1781154484.0957
            [end] => 1781154484.3416
            [time] => 0.24592018127441
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '3'
            [start] => 1781154484.3424
            [end] => 1781154484.3428
            [time] => 0.00031495094299316
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1781154484.3429
            [end] => 1781154484.3432
            [time] => 0.00024986267089844
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '3'
            [start] => 1781154484.3432
            [end] => 1781154484.3434
            [time] => 0.0002129077911377
        )

    [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] => 1781154484.3435
            [end] => 1781154484.3446
            [time] => 0.001140832901001
        )

    [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] => 1781154484.3448
            [end] => 1781154484.36
            [time] => 0.015184879302979
        )

    [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] => 1781154484.3601
            [end] => 1781154484.5669
            [time] => 0.20677304267883
        )

    [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] => 1781154484.5672
            [end] => 1781154484.5705
            [time] => 0.0033180713653564
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781154484.5733
            [end] => 1781154484.5736
            [time] => 0.00025200843811035
        )

    [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 <= 1781154484 OR start >= 1781154484) AND (end >= 1781154484 OR end = 0) AND (start < 1781154484) ORDER BY name ASC
            [start] => 1781154484.5736
            [end] => 1781154484.5746
            [time] => 0.00094294548034668
        )

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

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

)