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

Campionati: Campionato Eccellenza 2025/2026 A1

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 Red Devils 24 9 8 1 790 635 155
2 Sotomayor 18 7 6 1 502 433 69
3 Lab To Hit 18 8 6 2 641 603 38
4 Sunknights 12 9 4 5 622 652 -30
5 Piccolo Club 12 8 4 4 627 601 26
6 Evolution 12 9 4 5 719 652 67
7 Flamurtari 9 7 3 4 550 579 -29
8 Genova Hit Ball 9 8 3 5 643 682 -39
9 Pazzeschi 0 5 0 5 347 419 -72
10 Skoppiati 0 6 0 6 372 557 -185
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 Pietro Evangelista
Flamurtari
286 5 92 95% 0 7 0 0
2 Luca Fagherazzi
Genova Hit Ball
236 79 26 25% 0 8 0 0
3 Mirko Violetto
Sunknights
229 71 29 29% 2 9 0 0
4 Federico Pistidda
Lab To Hit
203 37 43 54% 0 8 0 0
5 Luca Cardinali
Lab To Hit
198 57 28 33% 0 8 0 0
6 Andrea Belcastro
Red Devils
191 67 19 22% 0 9 0 0
7 Federico Garrone
Red Devils
179 40 33 45% 0 9 0 0
8 Simone Selvaggio
Piccolo Club
174 39 32 45% 1 8 0 0
9 Amedeo Biglino
Evolution
165 42 27 39% 1 7 1 0
10 Davide Giordano
Evolution
141 57 9 14% 1 9 0 0
11 Roberto Coletta
Sotomayor
140 37 22 37% 0 7 0 0
12 Marco De Salvo
Sotomayor
130 50 10 17% 0 7 0 0
13 Raffaele Maurelli
Evolution
129 39 17 30% 0 8 0 0
14 Mattia Rizzon
Lab To Hit
125 25 25 50% 1 8 1 0
15 Giulio Naggi
Evolution
119 40 13 25% 2 9 0 0
16 Donald Basso
Piccolo Club
115 41 11 21% 1 6 0 0
17 Luca Siciliano
Genova Hit Ball
114 48 6 11% 1 7 0 0
18 Daniel Tiago Guzzafame
Sunknights
112 23 22 49% 0 6 0 0
19 Matteo Turigliatto
Flamurtari
111 39 11 22% 1 7 0 0
20 Leonardo Farina
Genova Hit Ball
105 42 7 14% 1 8 0 0
21 Alessio Casali
Sunknights
103 29 15 34% 0 8 1 0
22 Riccardo Francabandiera
Skoppiati
101 37 9 20% 0 6 0 0
23 Michele Messina
Red Devils
100 26 16 38% 0 7 0 0
24 Mattia Vazzoler
Red Devils
98 31 12 28% 0 9 0 0
25 Antonio Mirco Santarsia
Evolution
98 43 4 9% 2 9 0 0
26 Riccardo Marello
Piccolo Club
91 23 15 39% 2 8 0 0
27 Stefano Benedetto
Sunknights
91 35 7 17% 0 7 0 0
28 Gabriel Alessandro Delgrosso
Red Devils
88 29 10 26% 0 9 0 0
29 Ion Soroceanu
Skoppiati
85 29 9 24% 0 6 0 0
30 Filippo Rovai
Sotomayor
85 32 7 18% 0 6 0 0
31 Maurizio Rattalino
Sunknights
84 24 12 33% 0 7 0 0
32 Antonio De Rosa
Pazzeschi
81 30 7 19% 0 5 0 0
33 Gaspare Guarrato
Evolution
80 25 10 29% 1 9 0 0
34 Dario Ravera
Genova Hit Ball
78 24 10 29% 1 5 0 0
35 Riccardo Damiano
Flamurtari
77 25 9 26% 4 7 0 0
36 Leonardo Cicogna
Piccolo Club
76 26 8 24% 2 7 0 0
37 Alessio Petrosino
Sotomayor
75 30 5 14% 1 7 0 0
38 Davide Ciancio
Genova Hit Ball
73 23 9 28% 0 8 0 0
39 Federico D'Oria
Lab To Hit
67 26 5 16% 0 8 0 0
40 Matteo Cipolletta
Piccolo Club
64 23 6 21% 0 8 0 0
41 Riccardo Simini
Red Devils
62 16 10 38% 0 6 0 0
42 Daniele Agnello
Sotomayor
61 20 7 26% 1 6 0 0
43 Davide Brunello
Evolution
60 21 6 22% 0 8 0 0
44 Andrea Rigoni
Pazzeschi
58 17 8 32% 0 5 0 0
45 Andrea Cacioli
Skoppiati
57 21 5 19% 0 6 0 0
46 Giuseppe Mirra
Pazzeschi
57 21 5 19% 1 5 0 0
47 Daniele Botosso
Piccolo Club
56 16 8 33% 0 7 0 0
48 Luca Ambrosino
Pazzeschi
56 19 6 24% 2 5 0 0
49 Luca Cangialosi
Pazzeschi
56 19 6 24% 1 5 0 0
50 Enrico Demonte
Sotomayor
55 26 1 4% 1 6 0 0
51 Stefano Calvo
Lab To Hit
53 19 5 21% 1 7 0 0
52 Davide Salvaggio
Red Devils
50 22 2 8% 1 9 0 0
53 Alessandro Rigardo
Lab To Hit
48 21 2 9% 1 8 0 0
54 Roberto Riccio
Piccolo Club
47 22 1 4% 0 8 0 0
55 Simone Gabellini
Sotomayor
45 15 5 25% 0 4 0 0
56 Giovanni Marsico
Skoppiati
39 9 7 44% 1 5 0 0
57 Enrico Salari
Flamurtari
39 12 5 29% 0 5 0 0
58 Lennin Jarek Garcia
Skoppiati
39 15 3 17% 1 6 0 0
59 Federico Suppo
Skoppiati
35 13 3 19% 1 4 0 0
60 Marco Virgilio
Sunknights
34 14 2 13% 0 6 1 0
61 Filippo Venturini
Lab To Hit
31 11 3 21% 0 7 0 0
62 Marco Zanatta
Flamurtari
24 3 6 67% 0 6 0 0
63 Danilo Sacchetto
Pazzeschi
21 9 1 10% 0 5 0 0
64 Giorgio Recalcati
Genova Hit Ball
20 10 0 0 0 4 0 0
65 Daniele Gennaro
Red Devils
16 5 2 29% 1 3 0 0
66 Giacomo Garzaro
Pazzeschi
15 6 1 14% 0 5 0 0
67 Alessandro Adami
Sunknights
14 7 0 0 0 8 0 0
68 Lorenzo Fontana
Skoppiati
14 7 0 0 0 6 0 0
69 Enrico Spagnolini
Sunknights
13 5 1 17% 0 6 0 0
70 Leonardo Chiarella
Genova Hit Ball
12 6 0 0 0 7 0 0
71 Daniele Managò
Flamurtari
6 0 2 0 0 5 0 0
72 Matteo Clara
Sunknights
4 2 0 0 0 1 0 0
73 Angelo Zito
Flamurtari
0 0 0 0 0 2 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 Federica Funnone
Flamurtari
5 1 1 50% 0 7 0 0
2 Martina Lupo
Sotomayor
0 0 0 0 0 6 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni
                Total Queries: 30
        Total Time: 1.7193741798401
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770959865.4593
            [end] => 1770959865.4599
            [time] => 0.00065898895263672
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '39'
            [start] => 1770959865.4642
            [end] => 1770959865.4659
            [time] => 0.0017011165618896
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '39'
            [start] => 1770959865.466
            [end] => 1770959865.4663
            [time] => 0.00025105476379395
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (3955,3957,3956,3958,3959,3960,3961,3962,3964,3963,3966,3969,3965,3967,3968,3972,3970,3974,3971,3973,3979,3976,3978,3975,3977,3983,3981,3982,3980,3984,3985,3987,3989,3986,3988,3992,3994,3993,3991,3990,3995,3996,3999,3997,3998,4000,4004,4001,4003,4002,4005,4009,4007,4008,4006,4011,4010,4012,4013,4014,4016,4017,4015,4018,4019,4024,4022,4020,4021,4023,4028,4025,4026,4029,4027,4033,4032,4034,4030,4031,4037,4038,4036,4039,4035,4041,4042,4044,4043,4040) order by id ASC
            [start] => 1770959865.4749
            [end] => 1770959865.488
            [time] => 0.013041019439697
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3955,3957,3956,3958,3959,3960,3961,3962,3964,3963,3966,3969,3965,3967,3968,3972,3970,3974,3971,3973,3979,3976,3978,3975,3977,3983,3981,3982,3980,3984,3985,3987,3989,3986,3988,3992,3994,3993,3991,3990,3995,3996,3999,3997,3998,4000,4004,4001,4003,4002,4005,4009,4007,4008,4006,4011,4010,4012,4013,4014,4016,4017,4015,4018,4019,4024,4022,4020,4021,4023,4028,4025,4026,4029,4027,4033,4032,4034,4030,4031,4037,4038,4036,4039,4035,4041,4042,4044,4043,4040)
            [start] => 1770959865.5754
            [end] => 1770959865.6012
            [time] => 0.02587103843689
        )

    [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 <= 1770959865 OR start >= 1770959865) AND (end >= 1770959865 OR end = 0) AND (start < 1770959865) ORDER BY name ASC
            [start] => 1770959865.6356
            [end] => 1770959865.6367
            [time] => 0.0011270046234131
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '39'
            [start] => 1770959865.6369
            [end] => 1770959865.6372
            [time] => 0.00025200843811035
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '39'
            [start] => 1770959865.6373
            [end] => 1770959865.6375
            [time] => 0.00023913383483887
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (3955,3957,3956,3958,3959,3960,3961,3962,3964,3963,3966,3969,3965,3967,3968,3972,3970,3974,3971,3973,3979,3976,3978,3975,3977,3983,3981,3982,3980,3984,3985,3987,3989,3986,3988,3992,3994,3993,3991,3990,3995,3996,3999,3997,3998,4000,4004,4001,4003,4002,4005,4009,4007,4008,4006,4011,4010,4012,4013,4014,4016,4017,4015,4018,4019,4024,4022,4020,4021,4023,4028,4025,4026,4029,4027,4033,4032,4034,4030,4031,4037,4038,4036,4039,4035,4041,4042,4044,4043,4040) order by id ASC
            [start] => 1770959865.6447
            [end] => 1770959865.652
            [time] => 0.0072579383850098
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '39'
            [start] => 1770959865.7341
            [end] => 1770959865.7345
            [time] => 0.00036907196044922
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '39'
            [start] => 1770959865.7356
            [end] => 1770959865.7358
            [time] => 0.00025820732116699
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '39'
            [start] => 1770959865.7359
            [end] => 1770959865.7361
            [time] => 0.00022983551025391
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '39'
            [start] => 1770959865.7362
            [end] => 1770959865.7364
            [time] => 0.00019717216491699
        )

    [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 <= 1756109979 OR start >= 1756109979) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (16,36,38,17,18,19,21,11,1,22) ORDER BY lastname,firstname ASC
            [start] => 1770959865.7365
            [end] => 1770959865.7379
            [time] => 0.0014340877532959
        )

    [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 = '39') 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] => 1770959865.7384
            [end] => 1770959865.7518
            [time] => 0.013427019119263
        )

    [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 = '39')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1770959865.7521
            [end] => 1770959866.8769
            [time] => 1.1248540878296
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '39'
            [start] => 1770959866.8832
            [end] => 1770959866.8899
            [time] => 0.0067100524902344
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '39'
            [start] => 1770959866.89
            [end] => 1770959866.8998
            [time] => 0.0097711086273193
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '39'
            [start] => 1770959866.8998
            [end] => 1770959866.9027
            [time] => 0.0029671192169189
        )

    [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 <= 1756109979 OR start >= 1756109979) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (16,36,38,17,18,19,21,11,1,22) ORDER BY lastname,firstname ASC
            [start] => 1770959866.9028
            [end] => 1770959866.9054
            [time] => 0.0025300979614258
        )

    [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 = '39') 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] => 1770959866.9056
            [end] => 1770959866.962
            [time] => 0.056457996368408
        )

    [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 = '39')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1770959866.9621
            [end] => 1770959867.3848
            [time] => 0.42265701293945
        )

    [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 <= 1756109979 OR start >= 1756109979) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) ORDER BY lastname,firstname ASC
            [start] => 1770959867.385
            [end] => 1770959867.3914
            [time] => 0.0063760280609131
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1770959867.3996
            [end] => 1770959867.4008
            [time] => 0.0011370182037354
        )

    [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 <= 1770959867 OR start >= 1770959867) AND (end >= 1770959867 OR end = 0) AND (start < 1770959867) ORDER BY name ASC
            [start] => 1770959867.4009
            [end] => 1770959867.4018
            [time] => 0.0009009838104248
        )

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

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

)