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

Campionati: Campionato Eccellenza 2024/2025 B1

  1. Home
  2. Campionati
  3. Campionati

Martedì 15-10-2024

Giovedì 17-10-2024

Mercoledì 23-10-2024

Giovedì 24-10-2024

Venerdì 25-10-2024

Domenica 27-10-2024

Mercoledì 30-10-2024

Giovedì 31-10-2024

Mercoledì 06-11-2024

Giovedì 07-11-2024

Venerdì 08-11-2024

Domenica 10-11-2024

Mercoledì 13-11-2024

Giovedì 14-11-2024

Domenica 17-11-2024

Martedì 19-11-2024

Mercoledì 20-11-2024

Giovedì 21-11-2024

Mercoledì 27-11-2024

Giovedì 28-11-2024

Domenica 01-12-2024

Mercoledì 04-12-2024

Giovedì 05-12-2024

Martedì 10-12-2024

Giovedì 12-12-2024

Domenica 15-12-2024

Mercoledì 08-01-2025

Domenica 12-01-2025

Mercoledì 15-01-2025

Giovedì 16-01-2025

Martedì 21-01-2025

Mercoledì 22-01-2025

Domenica 26-01-2025

Martedì 28-01-2025

Giovedì 30-01-2025

Venerdì 31-01-2025

Domenica 02-02-2025

Giovedì 06-02-2025

Venerdì 07-02-2025

Domenica 09-02-2025

Martedì 11-02-2025

Giovedì 13-02-2025

Domenica 16-02-2025

Martedì 18-02-2025

Domenica 23-02-2025

Martedì 25-02-2025

Mercoledì 26-02-2025

Domenica 09-03-2025

Mercoledì 12-03-2025

Domenica 16-03-2025

Martedì 18-03-2025

Venerdì 21-03-2025

Domenica 23-03-2025

Martedì 25-03-2025

Domenica 30-03-2025

Martedì 01-04-2025

Mercoledì 02-04-2025

Domenica 06-04-2025

Mercoledì 09-04-2025

Giovedì 10-04-2025

Domenica 13-04-2025

Martedì 15-04-2025

Martedì 29-04-2025

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 Furious 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 Furious 		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 Furious 		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 Furious 		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 Furious 		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 Furious 		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 Furious 		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 Furious 		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.61101484298706
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781154509.9523
            [end] => 1781154509.9526
            [time] => 0.00030398368835449
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1781154509.9551
            [end] => 1781154509.9553
            [time] => 0.00022482872009277
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1781154509.9554
            [end] => 1781154509.9557
            [time] => 0.00027108192443848
        )

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

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

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

    [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 <= 1781154510 OR start >= 1781154510) AND (end >= 1781154510 OR end = 0) AND (start < 1781154510) ORDER BY name ASC
            [start] => 1781154510.2196
            [end] => 1781154510.2209
            [time] => 0.0013129711151123
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1781154510.221
            [end] => 1781154510.2212
            [time] => 0.00021004676818848
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1781154510.2213
            [end] => 1781154510.2216
            [time] => 0.00025296211242676
        )

    [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] => 1781154510.2217
            [end] => 1781154510.2249
            [time] => 0.0031468868255615
        )

    [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] => 1781154510.2255
            [end] => 1781154510.2293
            [time] => 0.0038168430328369
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1781154510.4066
            [end] => 1781154510.4071
            [time] => 0.00047516822814941
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1781154510.4084
            [end] => 1781154510.4086
            [time] => 0.00021886825561523
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1781154510.4087
            [end] => 1781154510.409
            [time] => 0.00025200843811035
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1781154510.409
            [end] => 1781154510.4092
            [time] => 0.00022292137145996
        )

    [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] => 1781154510.4094
            [end] => 1781154510.4108
            [time] => 0.0014688968658447
        )

    [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] => 1781154510.4112
            [end] => 1781154510.4268
            [time] => 0.015572071075439
        )

    [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] => 1781154510.4271
            [end] => 1781154510.7445
            [time] => 0.31746697425842
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '29'
            [start] => 1781154510.7455
            [end] => 1781154510.7458
            [time] => 0.00032901763916016
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1781154510.7459
            [end] => 1781154510.7462
            [time] => 0.00026392936706543
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '29'
            [start] => 1781154510.7462
            [end] => 1781154510.7464
            [time] => 0.00022292137145996
        )

    [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] => 1781154510.7465
            [end] => 1781154510.7476
            [time] => 0.0010640621185303
        )

    [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] => 1781154510.7478
            [end] => 1781154510.7629
            [time] => 0.015131950378418
        )

    [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] => 1781154510.763
            [end] => 1781154510.9704
            [time] => 0.2073860168457
        )

    [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] => 1781154510.9706
            [end] => 1781154510.9745
            [time] => 0.0038480758666992
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781154510.9777
            [end] => 1781154510.978
            [time] => 0.00023603439331055
        )

    [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 (start = 0 OR start <= 1781154510 OR start >= 1781154510) AND (end >= 1781154510 OR end = 0) AND (start < 1781154510) ORDER BY name ASC
            [start] => 1781154510.978
            [end] => 1781154510.979
            [time] => 0.00094509124755859
        )

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

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

)