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

Campionati: Campionato Eccellenza 2025/2026 B2

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
        )

)