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 Monstars 3 1 1 0 91 69 22
2 Homeless 3 1 1 0 112 60 52
3 Krakens Chivasso 3 1 1 0 58 46 12
4 Spartak 2 1 1 0 68 65 3
5 Valhalla 1 2 0 2 111 126 -15
6 Jedi Knights 0 1 0 1 60 112 -52
7 Delirium Consulum 0 0 0 0 0 0 0
8 Hitbusters 0 0 0 0 0 0 0
9 Together Hit 0 0 0 0 0 0 0
10 Atletico Boomers 0 1 0 1 69 91 -22
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 		40 11 6 35% 0 1 0 0
2 Lorenzo Lombardo
Monstars 		36 6 8 57% 0 1 0 0
3 Gaetano Rendine
Homeless 		35 10 5 33% 0 1 0 0
4 Andrea Merlo
Homeless 		32 4 8 67% 0 1 0 0
5 Gaetano De Vaire
Jedi Knights 		28 8 4 33% 0 2 0 0
6 Lorenzo Bellino
Spartak 		26 7 4 36% 0 1 0 0
7 Lorenzo Marchitelli
Valhalla 		25 11 1 8% 0 2 0 0
8 Dino Pagano
Delirium Consulum 		23 4 5 56% 0 1 0 0
9 Daniele Ponte
Valhalla 		22 11 0 0 0 2 0 0
10 Stefano Incorvaia
Atletico Boomers 		21 6 3 33% 0 1 0 0
11 Giovanni Aquila
Homeless 		21 9 1 10% 1 1 0 0
12 Giacomo Guarrato
Atletico Boomers 		21 9 1 10% 0 1 0 0
13 Mattia Valetti
Jedi Knights 		20 7 2 22% 1 2 0 0
14 Marco Bassetti
Valhalla 		20 10 0 0 0 2 0 0
15 Gioele Rossi
Spartak 		19 8 1 11% 0 1 0 0
16 Daniele Nemo Busato
Valhalla 		15 6 1 14% 0 2 0 0
17 Tommaso Giuliani
Jedi Knights 		15 6 1 14% 0 2 0 0
18 Franco Augustin Signori
Krakens Chivasso 		15 6 1 14% 0 1 1 0
19 Gioele Alesina
Krakens Chivasso 		14 7 0 0 0 1 0 0
20 Nicolò Signorini
Krakens Chivasso 		14 7 0 0 0 1 0 0
21 Thomas Gandolfi
Jedi Knights 		12 3 2 40% 0 2 0 0
22 Davide Garibaldi
Jedi Knights 		12 3 2 40% 0 2 0 0
23 Marco Antonucci
Valhalla 		12 6 0 0 0 2 0 0
24 Federico D'Urzo
Atletico Boomers 		12 6 0 0 0 1 0 0
25 Pierluigi Marchisio
Homeless 		11 1 3 75% 0 1 0 0
26 Davide Baldus
Homeless 		10 5 0 0 0 1 0 0
27 Andrea Brocchetta
Monstars 		9 3 1 25% 0 1 0 0
28 Tommaso Nardelli
Spartak 		9 3 1 25% 0 1 0 0
29 Roberto Pirrotta
Atletico Boomers 		9 3 1 25% 0 1 0 0
30 Yuki Galano
Valhalla 		7 2 1 33% 0 1 0 0
31 Francesco Ghio
Krakens Chivasso 		7 2 1 33% 0 1 0 0
32 Gianluca Minuto
Delirium Consulum 		7 2 1 33% 0 1 0 0
33 Alessio Noto
Valhalla 		7 2 1 33% 0 2 1 0
34 Lorenzo Lamberti
Atletico Boomers 		6 3 0 0 0 1 0 0
35 Fabio Pascoli
Spartak 		6 3 0 0 1 1 1 0
36 Samuele Carnelli
Jedi Knights 		5 1 1 50% 0 2 0 0
37 Mattia Calvio
Krakens Chivasso 		4 2 0 0 0 1 0 0
38 Alessandro Castello
Monstars 		4 2 0 0 0 1 0 0
39 Davide Costantin Grigoras
Spartak 		4 2 0 0 0 1 0 0
40 Francesco Signorini
Krakens Chivasso 		4 2 0 0 0 1 0 0
41 Daniele Cecconata
Monstars 		2 1 0 0 0 1 0 0
42 Riccardo Daniele
Spartak 		2 1 0 0 0 1 0 0
43 Manuel De Rosa
Spartak 		2 1 0 0 0 1 0 0
44 Antonio Angelo Mele
Jedi Knights 		2 1 0 0 0 1 0 0
45 Luca Rivetti
Valhalla 		2 1 0 0 0 2 2 0
46 Riccardo Ajassa
Hitbusters 		0 0 0 0 0 0 0 0
47 Mattia Allemano
Jedi Knights 		0 0 0 0 0 1 0 0
48 Gabriele Argirò
Together Hit 		0 0 0 0 0 0 0 0
49 Marco Bruno
Atletico Boomers 		0 0 0 0 0 1 0 0
50 Alessandro Caivano
Hitbusters 		0 0 0 0 0 0 0 0
51 Pietro Chevallard
Delirium Consulum 		0 0 0 0 0 1 0 0
52 Francesco Cissello
Together Hit 		0 0 0 0 0 0 0 0
53 Andrea Crovagna
Together Hit 		0 0 0 0 0 0 0 0
54 Renato Dalle Mura
Delirium Consulum 		0 0 0 0 0 1 0 0
55 Vincenzo De Felice
Atletico Boomers 		0 0 0 0 0 1 1 0
56 Simone Gasbarroni
Hitbusters 		0 0 0 0 0 0 0 0
57 Lorenzo La Iacona
Together Hit 		0 0 0 0 0 0 0 0
58 Paolo Lamberti
Delirium Consulum 		0 0 0 0 0 1 0 0
59 Stefano Mazzilli
Together Hit 		0 0 0 0 0 0 0 0
60 Luca Maria Mercurio
Hitbusters 		0 0 0 0 0 0 0 0
61 Simone Piccioli
Together Hit 		0 0 0 0 0 0 0 0
62 Mauro Maria Pittavino
Together Hit 		0 0 0 0 0 0 0 0
63 Gianluca Sabatino
Together Hit 		0 0 0 0 0 0 0 0
64 Daniele Tessarin
Hitbusters 		0 0 0 0 0 0 0 0
65 Andrea Vitale
Hitbusters 		0 0 0 0 0 0 0 0
66 Fabio Zorzan
Homeless 		0 0 0 0 0 0 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 Elena Pasino
Homeless 		2 1 0 0 0 1 0 0
2 Federica Amorelli
Monstars 		0 0 0 0 0 1 1 0
3 Noemi Castelluccio
Hitbusters 		0 0 0 0 0 0 0 0
4 Mara Ferraris
Monstars 		0 0 0 0 0 1 0 0
5 Chiara Gilardi
Monstars 		0 0 0 0 0 1 0 0
6 Alice La Versa
Delirium Consulum 		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.41694259643555
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034111.946
            [end] => 1766034111.9463
            [time] => 0.0003199577331543
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1766034111.9484
            [end] => 1766034111.9487
            [time] => 0.00032496452331543
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1766034111.9489
            [end] => 1766034111.9491
            [time] => 0.00026488304138184
        )

    [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] => 1766034111.9492
            [end] => 1766034111.9521
            [time] => 0.0028090476989746
        )

    [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] => 1766034111.9526
            [end] => 1766034111.9552
            [time] => 0.0025179386138916
        )

    [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] => 1766034111.9632
            [end] => 1766034111.9762
            [time] => 0.012998104095459
        )

    [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 <= 1766034112 OR start >= 1766034112) AND (end >= 1766034112 OR end = 0) AND (start < 1766034112) ORDER BY name ASC
            [start] => 1766034112.0037
            [end] => 1766034112.0047
            [time] => 0.0010049343109131
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1766034112.0048
            [end] => 1766034112.005
            [time] => 0.00020194053649902
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1766034112.0051
            [end] => 1766034112.0053
            [time] => 0.00024318695068359
        )

    [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] => 1766034112.0055
            [end] => 1766034112.0083
            [time] => 0.0027840137481689
        )

    [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] => 1766034112.0089
            [end] => 1766034112.0115
            [time] => 0.0025899410247803
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1766034112.0193
            [end] => 1766034112.0196
            [time] => 0.0003049373626709
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1766034112.0202
            [end] => 1766034112.0204
            [time] => 0.00020790100097656
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1766034112.0205
            [end] => 1766034112.0207
            [time] => 0.00023317337036133
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1766034112.0207
            [end] => 1766034112.0209
            [time] => 0.00021505355834961
        )

    [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] => 1766034112.021
            [end] => 1766034112.0223
            [time] => 0.0012710094451904
        )

    [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] => 1766034112.0228
            [end] => 1766034112.0345
            [time] => 0.011737823486328
        )

    [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] => 1766034112.0348
            [end] => 1766034112.2262
            [time] => 0.19146394729614
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '43'
            [start] => 1766034112.2271
            [end] => 1766034112.2274
            [time] => 0.0003058910369873
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1766034112.2275
            [end] => 1766034112.2278
            [time] => 0.00026488304138184
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '43'
            [start] => 1766034112.2278
            [end] => 1766034112.228
            [time] => 0.0002131462097168
        )

    [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] => 1766034112.2281
            [end] => 1766034112.229
            [time] => 0.00094079971313477
        )

    [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] => 1766034112.2292
            [end] => 1766034112.2407
            [time] => 0.011582136154175
        )

    [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] => 1766034112.2408
            [end] => 1766034112.4069
            [time] => 0.16612696647644
        )

    [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] => 1766034112.4072
            [end] => 1766034112.4108
            [time] => 0.0036559104919434
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034112.414
            [end] => 1766034112.4143
            [time] => 0.0002739429473877
        )

    [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 <= 1766034112 OR start >= 1766034112) AND (end >= 1766034112 OR end = 0) AND (start < 1766034112) ORDER BY name ASC
            [start] => 1766034112.4144
            [end] => 1766034112.4151
            [time] => 0.00075697898864746
        )

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

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

)