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

Campionati: Campionato Eccellenza 2025/2026 A2

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 Bioghettyson 3 1 1 0 92 50 42
2 All Blacks 3 1 1 0 90 59 31
3 Pellegrini Venaria 3 1 1 0 94 68 26
4 Trefferspan 3 1 1 0 67 59 8
5 Sheet 0 0 0 0 0 0 0
6 Skunk Milano 0 0 0 0 0 0 0
7 Black Knights 0 1 0 1 59 67 -8
8 Hammers 0 1 0 1 68 94 -26
9 Hocheti Pokety 0 1 0 1 59 90 -31
10 Igadan 0 1 0 1 50 92 -42
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 Francesco Caligaris
All Blacks
57 18 7 28% 1 2 0 0
2 Gabriele Spina
Igadan
52 17 6 26% 1 2 2 0
3 Gianluca Martinelli
Hammers
33 12 3 20% 0 1 0 0
4 Jacopo Marchitelli
Trefferspan
27 9 3 25% 0 1 0 0
5 Paul Mihei
Bioghettyson
26 7 4 36% 0 1 0 0
6 Patrick Marzano
All Blacks
25 5 5 50% 0 2 1 0
7 Marcello Bacchini
All Blacks
24 9 2 18% 0 2 0 0
8 Alessandro Bruno
Bioghettyson
24 9 2 18% 0 1 0 0
9 Fabrizio Gennaro
All Blacks
22 8 2 20% 1 2 1 0
10 Luca Mocciaro
Pellegrini Venaria
20 7 2 22% 0 1 0 0
11 Alessandro Maniscalco
Igadan
19 5 3 38% 0 2 0 0
12 Matteo Vanni
Black Knights
19 5 3 38% 0 1 0 0
13 Alberto Maggia
Igadan
19 8 1 11% 0 2 0 0
14 Federico Perno
All Blacks
19 8 1 11% 0 1 0 0
15 Gianluca Zingarelli
All Blacks
18 3 4 57% 1 1 0 0
16 Ramon Rutigliano
Hocheti Pokety
18 6 2 25% 0 1 1 0
17 Luigi Ghirardi
Hocheti Pokety
17 7 1 13% 0 1 0 0
18 Luca Dragna
Pellegrini Venaria
16 8 0 0 0 1 0 0
19 Domenico Pirozzolo
Pellegrini Venaria
16 8 0 0 0 1 0 0
20 Diego Leonardi
All Blacks
15 3 3 50% 1 1 1 0
21 Lorenzo De Nicola Civitarese
Black Knights
14 4 2 33% 0 1 0 0
22 Alberto Racco
Hocheti Pokety
14 4 2 33% 0 1 0 0
23 Alberto Casalegno
Pellegrini Venaria
14 7 0 0 0 1 0 0
24 Gabriele Salerno
Trefferspan
13 5 1 17% 0 1 0 0
25 Andrea Giannitti
Igadan
12 3 2 40% 0 2 0 0
26 Andrea Vecchiattini
Igadan
12 3 2 40% 0 1 0 0
27 Giulio Cocirio
Trefferspan
11 4 1 20% 0 1 0 0
28 Nicol Sciretta
Pellegrini Venaria
11 4 1 20% 0 1 0 0
29 Gianluca Zanetti
Igadan
10 2 2 50% 0 2 1 0
30 Gabriele Barone
Pellegrini Venaria
10 5 0 0 1 1 0 0
31 Marco Barrasso
Bioghettyson
10 5 0 0 0 1 0 0
32 Marco Antinoro
Black Knights
9 3 1 25% 0 1 0 0
33 Emiliano Travaglini
Bioghettyson
9 3 1 25% 0 1 0 0
34 Enrico Truffa
Igadan
9 3 1 25% 0 1 0 0
35 Davide Centin
Hammers
8 1 2 67% 0 1 0 0
36 Salvatore Lo Monaco
Hammers
8 4 0 0 0 1 0 0
37 Andrea Tapella
Bioghettyson
8 4 0 0 1 1 0 0
38 Tommaso Baudi Di Vesme Gabutti
Bioghettyson
7 2 1 33% 0 1 0 0
39 Simone Basano
Trefferspan
6 3 0 0 0 1 0 0
40 Massimiliano Casigli
Black Knights
6 3 0 0 0 1 0 0
41 Giovanni Marino
Hammers
6 3 0 0 1 1 0 0
42 Lorenzo Novara
Hammers
6 3 0 0 0 1 0 0
43 Davide Rivetti
Trefferspan
6 3 0 0 0 1 0 0
44 Gianluca Varetto
Black Knights
6 3 0 0 0 1 0 0
45 Lorenzo Zezza
Pellegrini Venaria
6 3 0 0 0 1 0 0
46 Simone De Meo
Hocheti Pokety
5 1 1 50% 2 1 0 0
47 Francesco Mongiovì
Bioghettyson
5 1 1 50% 0 1 0 0
48 Gabriele Di Stefano
Trefferspan
4 2 0 0 0 1 0 0
49 Samuel Maselli
Hocheti Pokety
4 2 0 0 0 1 0 0
50 Ivan Russo
Hammers
4 2 0 0 0 1 0 0
51 Francesco Rigoni
Bioghettyson
3 0 1 0 0 1 0 0
52 Alessandro Varetto
Black Knights
3 0 1 0 0 1 0 0
53 Fabio Bragagnolo
Black Knights
2 1 0 0 0 1 0 0
54 Stefano Benedetti
Sheet
0 0 0 0 0 0 0 0
55 Stefano Braschi
Skunk Milano
0 0 0 0 0 0 0 0
56 Francesco Colombo
Skunk Milano
0 0 0 0 0 0 0 0
57 Francesco Croci
Trefferspan
0 0 0 0 0 0 0 0
58 Daniele Demarchi
Sheet
0 0 0 0 0 0 0 0
59 Matteo Folladori
Skunk Milano
0 0 0 0 0 0 0 0
60 Matteo Galanti
Skunk Milano
0 0 0 0 0 0 0 0
61 Simone Garino
Bioghettyson
0 0 0 0 0 0 0 0
62 Alberto Giacometti
Hammers
0 0 0 0 0 0 0 0
63 Andrea Giustetti
Sheet
0 0 0 0 0 0 0 0
64 Edoardo Gladiali
Skunk Milano
0 0 0 0 0 0 0 0
65 Fabio Ingrassia
Sheet
0 0 0 0 0 0 0 0
66 Andrea Lavalle
Sheet
0 0 0 0 0 0 0 0
67 Gianluca Mondo
Sheet
0 0 0 0 0 0 0 0
68 Carlo Pangallo
Sheet
0 0 0 0 0 0 0 0
69 Alessandro Perrone
Skunk Milano
0 0 0 0 0 0 0 0
70 Marco Salusso
Sheet
0 0 0 0 0 0 0 0
71 Massimo Sbano
Hammers
0 0 0 0 0 0 0 0
72 Federico Sisci
Pellegrini Venaria
0 0 0 0 0 0 0 0
73 Tommaso Tomasina
Skunk Milano
0 0 0 0 0 0 0 0
74 Stefano Truzzi
Sheet
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
2 1 0 0 0 1 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni
                Total Queries: 30
        Total Time: 0.41828870773315
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034101.9767
            [end] => 1766034101.9771
            [time] => 0.00036811828613281
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1766034101.9793
            [end] => 1766034101.9796
            [time] => 0.0002739429473877
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1766034101.9797
            [end] => 1766034101.98
            [time] => 0.00024604797363281
        )

    [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] => 1766034101.9801
            [end] => 1766034101.9829
            [time] => 0.0028059482574463
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (4136,4139,4135,4138,4137,4144,4142,4141,4140,4143,4145,4147,4148,4146,4149,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] => 1766034101.9834
            [end] => 1766034101.986
            [time] => 0.0025138854980469
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (4136,4139,4135,4138,4137,4144,4142,4141,4140,4143,4145,4147,4148,4146,4149,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] => 1766034101.994
            [end] => 1766034102.0071
            [time] => 0.013065814971924
        )

    [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 <= 1766034102 OR start >= 1766034102) AND (end >= 1766034102 OR end = 0) AND (start < 1766034102) ORDER BY name ASC
            [start] => 1766034102.0346
            [end] => 1766034102.0355
            [time] => 0.00094485282897949
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1766034102.0356
            [end] => 1766034102.0359
            [time] => 0.00022602081298828
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1766034102.036
            [end] => 1766034102.0362
            [time] => 0.0002601146697998
        )

    [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] => 1766034102.0363
            [end] => 1766034102.0392
            [time] => 0.0028312206268311
        )

    [10] => Array
        (
            [query] => select * from match_time where match_id in (4136,4139,4135,4138,4137,4144,4142,4141,4140,4143,4145,4147,4148,4146,4149,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] => 1766034102.0398
            [end] => 1766034102.0423
            [time] => 0.0024797916412354
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1766034102.0503
            [end] => 1766034102.0507
            [time] => 0.00038290023803711
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1766034102.0513
            [end] => 1766034102.0515
            [time] => 0.00023698806762695
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1766034102.0516
            [end] => 1766034102.0518
            [time] => 0.00025010108947754
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1766034102.0519
            [end] => 1766034102.0521
            [time] => 0.00021100044250488
        )

    [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] => 1766034102.0522
            [end] => 1766034102.0535
            [time] => 0.0013577938079834
        )

    [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] => 1766034102.0541
            [end] => 1766034102.0659
            [time] => 0.011805057525635
        )

    [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] => 1766034102.0661
            [end] => 1766034102.258
            [time] => 0.19189882278442
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '41'
            [start] => 1766034102.259
            [end] => 1766034102.2593
            [time] => 0.0003359317779541
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1766034102.2594
            [end] => 1766034102.2597
            [time] => 0.00029897689819336
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '41'
            [start] => 1766034102.2597
            [end] => 1766034102.2599
            [time] => 0.00021004676818848
        )

    [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] => 1766034102.26
            [end] => 1766034102.261
            [time] => 0.00096702575683594
        )

    [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] => 1766034102.2611
            [end] => 1766034102.2728
            [time] => 0.01171088218689
        )

    [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] => 1766034102.2729
            [end] => 1766034102.4392
            [time] => 0.16624116897583
        )

    [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] => 1766034102.4393
            [end] => 1766034102.4431
            [time] => 0.0037670135498047
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034102.4464
            [end] => 1766034102.4468
            [time] => 0.00040411949157715
        )

    [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 <= 1766034102 OR start >= 1766034102) AND (end >= 1766034102 OR end = 0) AND (start < 1766034102) ORDER BY name ASC
            [start] => 1766034102.4469
            [end] => 1766034102.4477
            [time] => 0.00075602531433105
        )

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

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

)