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

Campionati: Campionato Eccellenza 2024/2025 B1

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 Trefferspan 54 18 18 0 1667 1172 495
2 Hocheti Pokety 41 18 14 4 1790 1377 413
3 Bioghettyson 38 18 12 6 1460 1306 154
4 Skunk Milano 35 18 12 6 1588 1299 289
5 Hammers 26 18 9 9 1523 1456 67
6 Decepticon 25 18 8 10 1255 1428 -173
7 Dracarys Chivasso 24 18 8 10 1506 1529 -23
8 Sporting Team Next Gen 12 18 4 14 1330 1571 -241
9 Nomadi Venaria 8 18 3 15 1196 1871 -675
10 Hitbusters 6 18 2 16 1375 1681 -306
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 Jacopo Marchitelli
Trefferspan
486 165 52 24% 3 17 0 0
2 Giuseppe Armanno
Decepticon
431 124 61 33% 0 15 1 0
3 Emiliano Travaglini
Bioghettyson
421 143 45 24% 2 18 0 0
4 Giulio Cocirio
Trefferspan
393 111 57 34% 1 16 0 0
5 Gabriele Salerno
Trefferspan
388 146 32 18% 2 17 0 0
6 Luigi Ghirardi
Hocheti Pokety
368 118 44 27% 1 17 0 0
7 Ramon Rutigliano
Hocheti Pokety
360 132 32 20% 1 18 1 0
8 Giovanni Marino
Hammers
350 157 12 7% 0 18 1 0
9 Antonio Marincola
Sporting Team Next Gen
313 107 33 24% 1 14 0 0
10 Davide Centin
Hammers
311 118 25 17% 0 17 2 0
11 Simone De Meo
Hocheti Pokety
307 101 35 26% 0 16 0 0
12 Federico Zoccarato
Nomadi Venaria
301 101 33 25% 2 17 0 0
13 Tommaso Tomasina
Skunk Milano
289 101 29 22% 0 14 3 0
14 Simone Gasbarroni
Hitbusters
281 94 31 25% 0 17 3 0
15 Gabriele Di Stefano
Trefferspan
271 110 17 13% 2 16 0 0
16 Edoardo Gladiali
Skunk Milano
256 101 18 15% 0 16 0 0
17 Marco Barrasso
Bioghettyson
251 91 23 20% 2 18 0 0
18 Luca Maria Mercurio
Hitbusters
228 75 26 26% 1 17 0 0
19 Riccardo Toppan
Decepticon
227 85 19 18% 1 18 0 0
20 Davide Martini
Dracarys Chivasso
222 87 16 16% 0 17 0 0
21 Ivan Russo
Hammers
215 97 7 7% 1 17 0 0
22 Alessandro Perrone
Skunk Milano
214 77 20 21% 1 13 1 0
23 Daniele Tessarin
Hitbusters
207 75 19 20% 2 18 0 0
24 Francesco Colombo
Skunk Milano
204 78 16 17% 0 15 1 0
25 Stefano Braschi
Skunk Milano
204 81 14 15% 0 14 0 0
26 Carlo Del console
Sporting Team Next Gen
176 73 10 12% 1 17 0 0
27 Luca Cavaglià
Decepticon
173 76 7 8% 1 17 0 0
28 Matteo Folladori
Skunk Milano
172 65 14 18% 3 13 0 0
29 Alessandro Caivano
Hitbusters
172 68 12 15% 3 16 0 0
30 Simone Guglielmetto
Decepticon
172 80 4 5% 2 17 0 0
31 Massimo Sbano
Hammers
168 72 8 10% 1 16 0 0
32 Alberto Racco
Hocheti Pokety
154 56 14 20% 0 10 1 0
33 Riccardo Ajassa
Hitbusters
136 53 10 16% 2 14 0 0
34 Tommaso Baudi Di Vesme Gabutti
Bioghettyson
132 60 4 6% 3 17 0 0
35 Davide Rivetti
Trefferspan
128 52 8 13% 2 17 0 0
36 Francesco Croci
Trefferspan
116 49 6 11% 2 13 0 0
37 Simone Basano
Trefferspan
101 40 7 15% 2 17 0 0
38 Daniele Barbato
Decepticon
93 45 1 2% 1 17 0 0
39 Christian Alescio
Nomadi Venaria
90 36 6 14% 2 14 0 0
40 Francesco Rigoni
Bioghettyson
90 39 4 9% 0 16 0 0
41 Samuel Maselli
Hocheti Pokety
83 37 3 8% 1 13 1 0
42 Francesco Mongiovì
Bioghettyson
62 28 2 7% 4 18 0 0
43 Vincenzo Padula
Sporting Team Next Gen
61 26 3 10% 0 10 0 0
44 Emanuele Filiberto Pellegrin
Dracarys Chivasso
54 24 2 8% 1 12 0 0
45 Simone Garino
Bioghettyson
54 27 0 0 1 17 0 0
46 Pietro Magrì
Dracarys Chivasso
51 24 1 4% 0 16 0 0
47 Matteo Galanti
Skunk Milano
48 21 2 9% 1 8 0 0
48 Matteo Roma
Dracarys Chivasso
42 21 0 0 0 14 0 0
49 Mattia Bucci
Nomadi Venaria
36 12 4 25% 0 6 0 0
50 Alberto Giacometti
Hammers
28 8 4 33% 0 5 0 0
51 Stefano Bollito
Sporting Team Next Gen
6 3 0 0 1 2 0 0
52 Luca Curti
Nomadi Venaria
0 0 0 0 0 0 0 0
53 Francesco Dughera
Dracarys Chivasso
0 0 0 0 0 0 0 0
54 Franco Giambanco
Sporting Team Next Gen
0 0 0 0 0 0 0 0
55 Gianluca Martinelli
Hammers
0 0 0 0 0 0 0 0
56 Riccardo Pajno Ferrara
Sporting Team Next Gen
0 0 0 0 0 0 0 0
57 Adriano Paribello Grasso
Dracarys Chivasso
0 0 0 0 0 0 0 0
58 Alessandro Rolino
Nomadi Venaria
0 0 0 0 0 0 0 0
59 Alessandro Santomaggio
Decepticon
0 0 0 0 0 0 0 0
60 Riccardo Santoro
Nomadi Venaria
0 0 0 0 0 0 0 0
61 Marco Schiaroli
Dracarys Chivasso
0 0 0 0 0 0 0 0
62 Andrea Vitale
Hitbusters
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 Arianna Vismara
Sporting Team Next Gen
145 68 3 4% 1 18 0 0
2 Noemi Castelluccio
Hitbusters
52 26 0 0 0 16 0 0
3 Sabrina Capitolo
Hammers
50 25 0 0 0 16 0 0
4 Martina Bracesco
Nomadi Venaria
28 11 2 15% 1 12 0 0
5 Sabrina Zanfretta
Nomadi Venaria
19 8 1 11% 0 6 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni
                Total Queries: 30
        Total Time: 0.43007206916809
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034187.5645
            [end] => 1766034187.5648
            [time] => 0.00030303001403809
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1766034187.567
            [end] => 1766034187.5672
            [time] => 0.00022101402282715
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1766034187.5673
            [end] => 1766034187.5676
            [time] => 0.00030207633972168
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (3747,3750,3748,3751,3749,3754,3752,3753,3756,3755,3758,3760,3759,3757,3761,3765,3763,3762,3764,3766,3771,3768,3767,3769,3770,3776,3775,3772,3774,3773,3780,3781,3779,3777,3778,3782,3785,3783,3784,3786,3788,3789,3790,3791,3787,3795,3792,3796,3793,3794,3800,3799,3798,3801,3797,3803,3804,3802,3805,3806,3810,3808,3809,3807,3811,3816,3815,3814,3812,3813,3819,3821,3820,3817,3818,3822,3826,3825,3824,3823,3828,3829,3827,3831,3830,3834,3833,3832,3835,3836) order by id ASC
            [start] => 1766034187.5712
            [end] => 1766034187.5741
            [time] => 0.0029408931732178
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3747,3750,3748,3751,3749,3754,3752,3753,3756,3755,3758,3760,3759,3757,3761,3765,3763,3762,3764,3766,3771,3768,3767,3769,3770,3776,3775,3772,3774,3773,3780,3781,3779,3777,3778,3782,3785,3783,3784,3786,3788,3789,3790,3791,3787,3795,3792,3796,3793,3794,3800,3799,3798,3801,3797,3803,3804,3802,3805,3806,3810,3808,3809,3807,3811,3816,3815,3814,3812,3813,3819,3821,3820,3817,3818,3822,3826,3825,3824,3823,3828,3829,3827,3831,3830,3834,3833,3832,3835,3836)
            [start] => 1766034187.709
            [end] => 1766034187.7222
            [time] => 0.013159036636353
        )

    [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 <= 1766034187 OR start >= 1766034187) AND (end >= 1766034187 OR end = 0) AND (start < 1766034187) ORDER BY name ASC
            [start] => 1766034187.7499
            [end] => 1766034187.7508
            [time] => 0.00094699859619141
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1766034187.7509
            [end] => 1766034187.7511
            [time] => 0.00021505355834961
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1766034187.7512
            [end] => 1766034187.7515
            [time] => 0.00025510787963867
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (3747,3750,3748,3751,3749,3754,3752,3753,3756,3755,3758,3760,3759,3757,3761,3765,3763,3762,3764,3766,3771,3768,3767,3769,3770,3776,3775,3772,3774,3773,3780,3781,3779,3777,3778,3782,3785,3783,3784,3786,3788,3789,3790,3791,3787,3795,3792,3796,3793,3794,3800,3799,3798,3801,3797,3803,3804,3802,3805,3806,3810,3808,3809,3807,3811,3816,3815,3814,3812,3813,3819,3821,3820,3817,3818,3822,3826,3825,3824,3823,3828,3829,3827,3831,3830,3834,3833,3832,3835,3836) order by id ASC
            [start] => 1766034187.755
            [end] => 1766034187.758
            [time] => 0.0029990673065186
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1766034187.8931
            [end] => 1766034187.8936
            [time] => 0.00049614906311035
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1766034187.8949
            [end] => 1766034187.8952
            [time] => 0.00025320053100586
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1766034187.8952
            [end] => 1766034187.8955
            [time] => 0.00021910667419434
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1766034187.8955
            [end] => 1766034187.8957
            [time] => 0.00021982192993164
        )

    [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 <= 1725022053 OR start >= 1725022053) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) AND team_id in (37,5,7,34,13,6,47,39,4,27) ORDER BY lastname,firstname ASC
            [start] => 1766034187.8958
            [end] => 1766034187.8971
            [time] => 0.0012531280517578
        )

    [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 = '29') 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] => 1766034187.8975
            [end] => 1766034187.9095
            [time] => 0.011964082717896
        )

    [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 = '29')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034187.9097
            [end] => 1766034188.112
            [time] => 0.20225787162781
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1766034188.1129
            [end] => 1766034188.1133
            [time] => 0.00031208992004395
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1766034188.1133
            [end] => 1766034188.1136
            [time] => 0.00030088424682617
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1766034188.1137
            [end] => 1766034188.1139
            [time] => 0.00021791458129883
        )

    [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 <= 1725022053 OR start >= 1725022053) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) AND team_id in (37,5,7,34,13,6,47,39,4,27) ORDER BY lastname,firstname ASC
            [start] => 1766034188.114
            [end] => 1766034188.1149
            [time] => 0.00095796585083008
        )

    [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 = '29') 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] => 1766034188.1151
            [end] => 1766034188.127
            [time] => 0.011919975280762
        )

    [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 = '29')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034188.1271
            [end] => 1766034188.2938
            [time] => 0.16669583320618
        )

    [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 <= 1725022053 OR start >= 1725022053) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) ORDER BY lastname,firstname ASC
            [start] => 1766034188.294
            [end] => 1766034188.2977
            [time] => 0.0036430358886719
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034188.3009
            [end] => 1766034188.3011
            [time] => 0.0002748966217041
        )

    [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 <= 1766034188 OR start >= 1766034188) AND (end >= 1766034188 OR end = 0) AND (start < 1766034188) ORDER BY name ASC
            [start] => 1766034188.3012
            [end] => 1766034188.302
            [time] => 0.00079488754272461
        )

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

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

)