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

Campionati: Campionato Eccellenza 2025/2026 A2

  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 Sheet 26 10 9 1 768 697 71
2 Pellegrini Venaria 24 11 8 3 1066 888 178
3 All Blacks 24 8 8 0 570 409 161
4 Trefferspan 21 10 7 3 768 586 182
5 Black Knights 19 10 6 4 833 712 121
6 Bioghettyson 18 11 6 5 725 711 14
7 Hammers 6 10 2 8 629 848 -219
8 Igadan 5 10 2 8 598 711 -113
9 Hocheti Pokety 4 9 1 8 683 880 -197
10 Skunk Milano 0 9 0 9 588 786 -198
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 Gabriele Barone
Pellegrini Venaria 		278 106 22 17% 3 11 0 0
2 Jacopo Marchitelli
Trefferspan 		275 94 29 24% 0 10 1 0
3 Alberto Casalegno
Pellegrini Venaria 		240 93 18 16% 1 11 0 0
4 Luca Mocciaro
Pellegrini Venaria 		224 61 34 36% 1 9 0 0
5 Stefano Benedetti
Sheet 		212 76 20 21% 0 10 1 0
6 Alessandro Varetto
Black Knights 		211 65 27 29% 1 10 0 0
7 Luigi Ghirardi
Hocheti Pokety 		202 74 18 20% 0 9 0 0
8 Gianluca Martinelli
Hammers 		200 79 14 15% 2 10 0 0
9 Paul Mihei
Bioghettyson 		195 60 25 29% 3 11 1 0
10 Emiliano Travaglini
Bioghettyson 		191 64 21 25% 3 11 1 0
11 Ramon Rutigliano
Hocheti Pokety 		177 54 23 30% 0 9 1 0
12 Gabriele Di Stefano
Trefferspan 		164 55 18 25% 1 10 0 0
13 Lorenzo De Nicola Civitarese
Black Knights 		154 47 20 30% 1 10 0 0
14 Luca Dragna
Pellegrini Venaria 		154 71 4 5% 1 11 0 0
15 Giovanni Marino
Hammers 		151 74 1 1% 2 10 0 0
16 Marco Salusso
Sheet 		147 36 25 41% 0 6 0 0
17 Marcello Bacchini
All Blacks 		141 54 11 17% 0 8 1 0
18 Domenico Pirozzolo
Pellegrini Venaria 		140 55 10 15% 0 11 0 0
19 Alessandro Bruno
Bioghettyson 		135 48 13 21% 1 11 1 0
20 Matteo Vanni
Black Knights 		132 42 16 28% 1 10 0 0
21 Alberto Racco
Hocheti Pokety 		131 40 17 30% 1 9 2 0
22 Fabio Bragagnolo
Black Knights 		128 37 18 33% 0 9 2 0
23 Simone De Meo
Hocheti Pokety 		122 46 10 18% 2 8 0 0
24 Gianluca Zanetti
Igadan 		121 47 9 16% 0 10 0 0
25 Giulio Cocirio
Trefferspan 		117 42 11 21% 0 9 0 0
26 Tommaso Tomasina
Skunk Milano 		116 49 6 11% 0 7 1 0
27 Alessandro Maniscalco
Igadan 		115 50 5 9% 0 10 0 0
28 Edoardo Gladiali
Skunk Milano 		113 52 3 5% 0 8 0 0
29 Carlo Pangallo
Sheet 		112 50 4 7% 1 10 0 0
30 Francesco Caligaris
All Blacks 		111 42 9 18% 0 8 0 0
31 Alessandro Perrone
Skunk Milano 		108 51 2 4% 0 9 0 0
32 Stefano Braschi
Skunk Milano 		102 42 6 13% 1 9 0 0
33 Andrea Lavalle
Sheet 		102 42 6 13% 1 10 0 0
34 Diego Leonardi
All Blacks 		98 22 18 45% 2 8 1 0
35 Federico Perno
All Blacks 		97 41 5 11% 0 8 1 0
36 Davide Centin
Hammers 		96 36 8 18% 0 10 0 0
37 Gabriele Salerno
Trefferspan 		96 36 8 18% 1 10 0 0
38 Andrea Giustetti
Sheet 		94 32 10 24% 1 10 0 0
39 Enrico Truffa
Igadan 		91 32 9 22% 1 10 0 0
40 Gianluca Varetto
Black Knights 		90 27 12 31% 0 9 0 0
41 Andrea Vecchiattini
Igadan 		89 37 5 12% 1 10 0 0
42 Andrea Giannitti
Igadan 		83 40 1 2% 0 10 0 0
43 Francesco Colombo
Skunk Milano 		79 35 3 8% 0 9 3 0
44 Marco Antinoro
Black Knights 		77 28 7 20% 1 10 0 0
45 Gabriele Spina
Igadan 		76 29 6 17% 2 9 0 0
46 Gianluca Mondo
Sheet 		73 26 7 21% 1 6 0 0
47 Ivan Russo
Hammers 		73 35 1 3% 0 10 1 0
48 Patrick Marzano
All Blacks 		70 29 4 12% 0 8 0 0
49 Alberto Maggia
Igadan 		64 26 4 13% 0 10 0 0
50 Stefano Truzzi
Sheet 		63 24 5 17% 0 10 0 0
51 Salvatore Lo Monaco
Hammers 		60 27 2 7% 1 6 0 0
52 Fabrizio Gennaro
All Blacks 		59 22 5 19% 2 8 4 0
53 Fabio Ingrassia
Sheet 		59 25 3 11% 1 9 0 0
54 Andrea Tapella
Bioghettyson 		58 23 4 15% 1 10 0 0
55 Tommaso Baudi Di Vesme Gabutti
Bioghettyson 		54 21 4 16% 0 10 1 0
56 Massimo Sbano
Hammers 		50 25 0 0 0 7 0 0
57 Simone Basano
Trefferspan 		49 20 3 13% 0 10 0 0
58 Francesco Croci
Trefferspan 		45 15 5 25% 0 8 0 0
59 Davide Rivetti
Trefferspan 		45 21 1 5% 0 10 0 0
60 Marco Barrasso
Bioghettyson 		40 20 0 0 0 7 2 0
61 Matteo Galanti
Skunk Milano 		40 20 0 0 2 8 1 0
62 Samuel Maselli
Hocheti Pokety 		36 18 0 0 1 7 2 0
63 Lorenzo Zezza
Pellegrini Venaria 		36 18 0 0 1 8 0 0
64 Massimiliano Casigli
Black Knights 		34 14 2 13% 0 7 0 0
65 Lorenzo Novara
Hammers 		31 14 1 7% 1 6 1 0
66 Gianluca Zingarelli
All Blacks 		31 14 1 7% 0 7 0 0
67 Francesco Mongiovì
Bioghettyson 		29 13 1 7% 0 10 0 0
68 Matteo Folladori
Skunk Milano 		23 10 1 9% 0 2 0 0
69 Nicol Sciretta
Pellegrini Venaria 		19 8 1 11% 0 5 0 0
70 Francesco Rigoni
Bioghettyson 		18 6 2 25% 1 10 1 0
71 Daniele Demarchi
Sheet 		16 8 0 0 0 6 0 0
72 Andrea Garzena
Hocheti Pokety 		11 4 1 20% 0 5 2 0
73 Marco Potenza
All Blacks 		9 3 1 25% 0 1 0 0
74 Simone Garino
Bioghettyson 		6 3 0 0 1 5 0 0
75 Andrea Poso
Skunk Milano 		6 3 0 0 0 2 2 0
76 Michelangelo Lupo Benini
Skunk Milano 		0 0 0 0 1 1 1 0
77 Federico Sisci
Pellegrini Venaria 		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 Sabrina Capitolo
Hammers 		17 7 1 13% 0 8 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.62044787406921
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770959821.5057
            [end] => 1770959821.5077
            [time] => 0.0020229816436768
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1770959821.51
            [end] => 1770959821.5117
            [time] => 0.0017750263214111
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1770959821.5119
            [end] => 1770959821.5121
            [time] => 0.00024795532226562
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (4135,4136,4139,4138,4137,4142,4141,4140,4143,4144,4148,4146,4149,4145,4147,4154,4152,4150,4151,4153,4155,4159,4156,4157,4158,4164,4162,4163,4160,4161,4165,4166,4167,4169,4168,4172,4171,4173,4174,4170,4175,4178,4177,4176,4179,4180,4184,4183,4181,4182,4186,4189,4185,4188,4187,4192,4193,4194,4191,4190,4198,4195,4197,4199,4196,4204,4203,4202,4201,4200,4205,4207,4209,4208,4206,4211,4210,4212,4213,4214,4217,4216,4219,4215,4218,4220,4224,4221,4222,4223) order by id ASC
            [start] => 1770959821.5207
            [end] => 1770959821.5261
            [time] => 0.0054080486297607
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (4135,4136,4139,4138,4137,4142,4141,4140,4143,4144,4148,4146,4149,4145,4147,4154,4152,4150,4151,4153,4155,4159,4156,4157,4158,4164,4162,4163,4160,4161,4165,4166,4167,4169,4168,4172,4171,4173,4174,4170,4175,4178,4177,4176,4179,4180,4184,4183,4181,4182,4186,4189,4185,4188,4187,4192,4193,4194,4191,4190,4198,4195,4197,4199,4196,4204,4203,4202,4201,4200,4205,4207,4209,4208,4206,4211,4210,4212,4213,4214,4217,4216,4219,4215,4218,4220,4224,4221,4222,4223)
            [start] => 1770959821.6161
            [end] => 1770959821.6301
            [time] => 0.014015913009644
        )

    [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 <= 1770959821 OR start >= 1770959821) AND (end >= 1770959821 OR end = 0) AND (start < 1770959821) ORDER BY name ASC
            [start] => 1770959821.6582
            [end] => 1770959821.6594
            [time] => 0.0012001991271973
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1770959821.6595
            [end] => 1770959821.6597
            [time] => 0.00022411346435547
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1770959821.6598
            [end] => 1770959821.6601
            [time] => 0.00024318695068359
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (4135,4136,4139,4138,4137,4142,4141,4140,4143,4144,4148,4146,4149,4145,4147,4154,4152,4150,4151,4153,4155,4159,4156,4157,4158,4164,4162,4163,4160,4161,4165,4166,4167,4169,4168,4172,4171,4173,4174,4170,4175,4178,4177,4176,4179,4180,4184,4183,4181,4182,4186,4189,4185,4188,4187,4192,4193,4194,4191,4190,4198,4195,4197,4199,4196,4204,4203,4202,4201,4200,4205,4207,4209,4208,4206,4211,4210,4212,4213,4214,4217,4216,4219,4215,4218,4220,4224,4221,4222,4223) order by id ASC
            [start] => 1770959821.6638
            [end] => 1770959821.6668
            [time] => 0.0030391216278076
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1770959821.749
            [end] => 1770959821.7494
            [time] => 0.00041699409484863
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1770959821.7504
            [end] => 1770959821.7506
            [time] => 0.0002140998840332
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1770959821.7507
            [end] => 1770959821.7509
            [time] => 0.00023388862609863
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1770959821.7509
            [end] => 1770959821.7511
            [time] => 0.00020194053649902
        )

    [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 <= 1756111359 OR start >= 1756111359) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (31,37,23,34,6,28,14,32,39,27) ORDER BY lastname,firstname ASC
            [start] => 1770959821.7512
            [end] => 1770959821.7527
            [time] => 0.0014181137084961
        )

    [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 = '41') 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] => 1770959821.7532
            [end] => 1770959821.7666
            [time] => 0.013394117355347
        )

    [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 = '41')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1770959821.7669
            [end] => 1770959822.1271
            [time] => 0.3601930141449
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1770959822.1282
            [end] => 1770959822.1286
            [time] => 0.0003058910369873
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1770959822.1286
            [end] => 1770959822.1289
            [time] => 0.00027298927307129
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1770959822.1289
            [end] => 1770959822.1292
            [time] => 0.00024294853210449
        )

    [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 <= 1756111359 OR start >= 1756111359) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (31,37,23,34,6,28,14,32,39,27) ORDER BY lastname,firstname ASC
            [start] => 1770959822.1293
            [end] => 1770959822.1303
            [time] => 0.0010011196136475
        )

    [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 = '41') 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] => 1770959822.1304
            [end] => 1770959822.1435
            [time] => 0.01309609413147
        )

    [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 = '41')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1770959822.1435
            [end] => 1770959822.3277
            [time] => 0.1841139793396
        )

    [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 <= 1756111359 OR start >= 1756111359) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) ORDER BY lastname,firstname ASC
            [start] => 1770959822.3279
            [end] => 1770959822.3318
            [time] => 0.0038390159606934
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1770959822.3352
            [end] => 1770959822.3355
            [time] => 0.00033211708068848
        )

    [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 <= 1770959822 OR start >= 1770959822) AND (end >= 1770959822 OR end = 0) AND (start < 1770959822) ORDER BY name ASC
            [start] => 1770959822.3356
            [end] => 1770959822.3363
            [time] => 0.00076508522033691
        )

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

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

)