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

Campionati: Campionato Eccellenza 2025/2026 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
Giornata 15
Giornata 16
Giornata 17
Giornata 18
Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
1 Hitbusters 30 10 10 0 798 583 215
2 Monstars 25 11 8 3 822 708 114
3 Atletico Boomers 18 11 6 5 747 682 65
4 Delirium Consulum 16 9 6 3 570 597 -27
5 Homeless 15 8 5 3 644 517 127
6 Together Hit 9 9 3 6 587 665 -78
7 Jedi Knights 9 9 3 6 512 631 -119
8 Krakens Chivasso 9 9 3 6 538 582 -44
9 Spartak 8 11 3 8 711 861 -150
10 Valhalla 8 11 2 9 640 743 -103
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 Mattia Borca
Monstars 		337 122 31 20% 3 11 0 0
2 Gaetano Rendine
Homeless 		226 68 30 31% 0 8 0 0
3 Lorenzo Lombardo
Monstars 		218 64 30 32% 2 10 0 0
4 Paolo Lamberti
Delirium Consulum 		211 71 23 24% 1 9 0 0
5 Lorenzo Bellino
Spartak 		210 81 16 16% 1 11 0 0
6 Gioele Rossi
Spartak 		205 77 17 18% 2 10 0 0
7 Nicolò Signorini
Krakens Chivasso 		193 83 9 10% 0 10 0 0
8 Andrea Merlo
Homeless 		187 44 33 43% 1 8 0 0
9 Simone Gasbarroni
Hitbusters 		184 65 18 22% 1 11 0 0
10 Daniele Ponte
Valhalla 		171 63 15 19% 0 11 2 0
11 Stefano Incorvaia
Atletico Boomers 		171 66 13 16% 1 11 0 0
12 Luca Maria Mercurio
Hitbusters 		160 65 10 13% 1 11 0 0
13 Dino Pagano
Delirium Consulum 		157 62 11 15% 1 9 0 0
14 Gianluca Sabatino
Together Hit 		154 50 18 26% 2 9 0 0
15 Daniele Nemo Busato
Valhalla 		146 49 16 25% 1 11 0 0
16 Giacomo Guarrato
Atletico Boomers 		141 57 9 14% 0 10 0 0
17 Renato Dalle Mura
Delirium Consulum 		141 63 5 7% 2 9 0 0
18 Francesco Cissello
Together Hit 		135 51 11 18% 0 8 1 0
19 Roberto Pirrotta
Atletico Boomers 		135 54 9 14% 1 11 1 0
20 Daniele Tessarin
Hitbusters 		135 54 9 14% 0 10 0 0
21 Stefano Mazzilli
Together Hit 		121 47 9 16% 0 8 0 0
22 Gioele Alesina
Krakens Chivasso 		118 47 8 15% 0 8 0 0
23 Andrea Vitale
Hitbusters 		117 51 5 9% 0 8 1 0
24 Andrea Brocchetta
Monstars 		116 46 8 15% 0 10 0 0
25 Alessandro Caivano
Hitbusters 		111 48 5 9% 1 11 0 0
26 Lorenzo Lamberti
Atletico Boomers 		105 45 5 10% 2 11 1 0
27 Lorenzo Marchitelli
Valhalla 		104 49 2 4% 1 10 0 0
28 Andrea Crovagna
Together Hit 		102 36 10 22% 1 7 0 0
29 Franco Augustin Signori
Krakens Chivasso 		100 41 6 13% 3 10 1 0
30 Samuele Carnelli
Jedi Knights 		93 36 7 16% 0 9 0 0
31 Federico D'Urzo
Atletico Boomers 		91 35 7 17% 1 11 0 0
32 Gaetano De Vaire
Jedi Knights 		90 27 12 31% 0 9 0 0
33 Vincenzo De Felice
Atletico Boomers 		83 31 7 18% 1 11 2 0
34 Giovanni Aquila
Homeless 		82 35 4 10% 1 8 0 0
35 Davide Costantin Grigoras
Spartak 		80 37 2 5% 0 10 0 0
36 Tommaso Giuliani
Jedi Knights 		77 31 5 14% 1 9 1 0
37 Mattia Valetti
Jedi Knights 		76 32 4 11% 1 9 1 0
38 Marco Bassetti
Valhalla 		75 36 1 3% 1 11 0 0
39 Thomas Gandolfi
Jedi Knights 		72 21 10 32% 1 8 1 0
40 Davide Baldus
Homeless 		69 33 1 3% 0 7 0 0
41 Manuel De Rosa
Spartak 		69 33 1 3% 1 11 0 0
42 Francesco Ghio
Krakens Chivasso 		67 29 3 9% 1 10 0 0
43 Mattia Allemano
Jedi Knights 		64 29 2 6% 0 9 1 0
44 Riccardo Daniele
Spartak 		59 28 1 3% 0 11 0 0
45 Yuki Galano
Valhalla 		58 20 6 23% 0 9 1 0
46 Daniele Cecconata
Monstars 		50 25 0 0 2 11 0 0
47 Fabio Pascoli
Spartak 		48 21 2 9% 2 11 1 0
48 Gianluca Minuto
Delirium Consulum 		44 22 0 0 1 8 2 0
49 Davide Garibaldi
Jedi Knights 		43 14 5 26% 1 9 0 0
50 Mauro Maria Pittavino
Together Hit 		40 17 2 11% 0 8 0 0
51 Tommaso Nardelli
Spartak 		35 16 1 6% 0 11 2 0
52 Mattia Calvio
Krakens Chivasso 		34 14 2 13% 0 10 1 0
53 Marco Antonucci
Valhalla 		33 15 1 6% 0 9 0 0
54 Luca Rivetti
Valhalla 		32 16 0 0 0 11 2 0
55 Pietro Chevallard
Delirium Consulum 		30 12 2 14% 2 7 1 0
56 Pierluigi Marchisio
Homeless 		29 7 5 42% 0 7 0 0
57 Francesco Signorini
Krakens Chivasso 		28 14 0 0 1 10 0 0
58 Riccardo Ajassa
Hitbusters 		25 11 1 8% 0 4 0 0
59 Simone Piccioli
Together Hit 		19 8 1 11% 0 8 1 0
60 Alessio Noto
Valhalla 		18 6 2 25% 0 5 1 0
61 Marco Bruno
Atletico Boomers 		16 8 0 0 0 11 0 0
62 Fabio Zorzan
Homeless 		15 6 1 14% 1 4 0 0
63 Antonio Angelo Mele
Jedi Knights 		9 3 1 25% 0 6 0 0
64 Lorenzo La Iacona
Together Hit 		7 2 1 33% 0 3 0 0
65 Alessandro Castello
Monstars 		6 3 0 0 0 3 0 0
66 Gabriele Argirò
Together Hit 		4 2 0 0 0 1 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 Carlotta Amodeo
Hitbusters 		74 34 2 6% 0 6 0 0
2 Federica Amorelli
Monstars 		60 30 0 0 0 11 2 0
3 Mara Ferraris
Monstars 		28 11 2 15% 0 11 1 0
4 Elena Pasino
Homeless 		28 14 0 0 0 8 0 0
5 Alice La Versa
Delirium Consulum 		20 10 0 0 1 9 1 0
6 Chiara Gilardi
Monstars 		3 0 1 0 0 11 0 0
7 Noemi Castelluccio
Hitbusters 		0 0 0 0 0 1 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.49960780143738
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770965473.9729
            [end] => 1770965473.9732
            [time] => 0.00031089782714844
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1770965473.9755
            [end] => 1770965473.9758
            [time] => 0.00024080276489258
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1770965473.9759
            [end] => 1770965473.9761
            [time] => 0.00028204917907715
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (4319,4315,4316,4318,4317,4322,4323,4321,4320,4324,4326,4329,4327,4325,4328,4334,4331,4332,4333,4330,4335,4339,4338,4337,4336,4340,4342,4344,4341,4343,4346,4345,4347,4348,4349,4352,4351,4350,4354,4353,4356,4355,4358,4357,4359,4364,4361,4360,4362,4363,4365,4368,4369,4366,4367,4372,4374,4370,4373,4371,4376,4377,4375,4378,4379,4384,4380,4383,4381,4382,4386,4389,4388,4385,4387,4394,4392,4391,4390,4393,4398,4397,4395,4399,4396,4402,4401,4400,4404,4403) order by id ASC
            [start] => 1770965473.9798
            [end] => 1770965473.9827
            [time] => 0.0029711723327637
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (4319,4315,4316,4318,4317,4322,4323,4321,4320,4324,4326,4329,4327,4325,4328,4334,4331,4332,4333,4330,4335,4339,4338,4337,4336,4340,4342,4344,4341,4343,4346,4345,4347,4348,4349,4352,4351,4350,4354,4353,4356,4355,4358,4357,4359,4364,4361,4360,4362,4363,4365,4368,4369,4366,4367,4372,4374,4370,4373,4371,4376,4377,4375,4378,4379,4384,4380,4383,4381,4382,4386,4389,4388,4385,4387,4394,4392,4391,4390,4393,4398,4397,4395,4399,4396,4402,4401,4400,4404,4403)
            [start] => 1770965474.0657
            [end] => 1770965474.08
            [time] => 0.014312982559204
        )

    [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 <= 1770965474 OR start >= 1770965474) AND (end >= 1770965474 OR end = 0) AND (start < 1770965474) ORDER BY name ASC
            [start] => 1770965474.1077
            [end] => 1770965474.1086
            [time] => 0.00099301338195801
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1770965474.1087
            [end] => 1770965474.109
            [time] => 0.0002140998840332
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1770965474.1091
            [end] => 1770965474.1093
            [time] => 0.00026822090148926
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (4319,4315,4316,4318,4317,4322,4323,4321,4320,4324,4326,4329,4327,4325,4328,4334,4331,4332,4333,4330,4335,4339,4338,4337,4336,4340,4342,4344,4341,4343,4346,4345,4347,4348,4349,4352,4351,4350,4354,4353,4356,4355,4358,4357,4359,4364,4361,4360,4362,4363,4365,4368,4369,4366,4367,4372,4374,4370,4373,4371,4376,4377,4375,4378,4379,4384,4380,4383,4381,4382,4386,4389,4388,4385,4387,4394,4392,4391,4390,4393,4398,4397,4395,4399,4396,4402,4401,4400,4404,4403) order by id ASC
            [start] => 1770965474.113
            [end] => 1770965474.116
            [time] => 0.0029971599578857
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1770965474.1992
            [end] => 1770965474.1995
            [time] => 0.00027799606323242
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1770965474.2006
            [end] => 1770965474.2008
            [time] => 0.00023198127746582
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1770965474.2009
            [end] => 1770965474.2012
            [time] => 0.00023007392883301
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1770965474.2012
            [end] => 1770965474.2014
            [time] => 0.00020194053649902
        )

    [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 <= 1756215092 OR start >= 1756215092) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (46,49,13,43,54,9,26,60,29,61) ORDER BY lastname,firstname ASC
            [start] => 1770965474.2016
            [end] => 1770965474.2029
            [time] => 0.0013611316680908
        )

    [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 = '43') 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] => 1770965474.2034
            [end] => 1770965474.2167
            [time] => 0.013280868530273
        )

    [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 = '43')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1770965474.2169
            [end] => 1770965474.4379
            [time] => 0.22090697288513
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1770965474.4389
            [end] => 1770965474.4392
            [time] => 0.00029301643371582
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1770965474.4393
            [end] => 1770965474.4395
            [time] => 0.00024008750915527
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1770965474.4395
            [end] => 1770965474.4397
            [time] => 0.00021982192993164
        )

    [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 <= 1756215092 OR start >= 1756215092) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (46,49,13,43,54,9,26,60,29,61) ORDER BY lastname,firstname ASC
            [start] => 1770965474.4398
            [end] => 1770965474.4408
            [time] => 0.0010020732879639
        )

    [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 = '43') 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] => 1770965474.441
            [end] => 1770965474.4542
            [time] => 0.013221979141235
        )

    [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 = '43')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1770965474.4543
            [end] => 1770965474.6672
            [time] => 0.21291494369507
        )

    [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 <= 1756215092 OR start >= 1756215092) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) ORDER BY lastname,firstname ASC
            [start] => 1770965474.6675
            [end] => 1770965474.6719
            [time] => 0.0043830871582031
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1770965474.6755
            [end] => 1770965474.6757
            [time] => 0.00025391578674316
        )

    [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 <= 1770965474 OR start >= 1770965474) AND (end >= 1770965474 OR end = 0) AND (start < 1770965474) ORDER BY name ASC
            [start] => 1770965474.6758
            [end] => 1770965474.6766
            [time] => 0.00077986717224121
        )

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

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

)