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

Campionati: Campionato Eccellenza 2024/2025 B1

  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 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
        )

)