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

Campionati: Campionato Eccellenza 2025/2026 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 Iron Lion Tyson 27 10 9 1 896 576 320
2 Guardians Chivasso 24 9 8 1 867 649 218
3 Hit Bulls 18 10 6 4 797 698 99
4 Torino Warriors 15 8 5 3 755 621 134
5 Decepticon 14 8 5 3 602 545 57
6 Sporting Team Next Gen 13 8 4 4 588 575 13
7 Meatballs 12 8 4 4 556 547 9
8 Dracarys Chivasso 9 12 3 9 904 1073 -169
9 Driphit 6 8 2 6 524 779 -255
10 Nomadi Venaria 0 11 0 11 799 1225 -426
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 Federico Zoccarato
Nomadi Venaria
275 103 23 18% 2 11 0 0
2 Riccardo Pajno Ferrara
Sporting Team Next Gen
239 85 23 21% 0 8 0 0
3 Giuseppe Armanno
Decepticon
235 77 27 26% 1 8 0 0
4 Nicolò Bonincontro
Hit Bulls
226 86 18 17% 0 10 0 0
5 Edoardo Bruno
Iron Lion Tyson
196 77 14 15% 0 9 0 0
6 Pier Paolo Specchiulli
Hit Bulls
195 72 17 19% 2 10 0 0
7 Marco Schiaroli
Dracarys Chivasso
194 58 26 31% 0 10 0 0
8 Francesco Dughera
Dracarys Chivasso
190 68 18 21% 0 11 0 0
9 Matteo Amideo
Iron Lion Tyson
187 71 15 17% 0 10 0 0
10 Manuel Spatafora
Guardians Chivasso
185 70 15 18% 1 9 0 0
11 Rosso Paolo
Guardians Chivasso
181 62 19 23% 0 9 0 0
12 Adriano Paribello Grasso
Dracarys Chivasso
180 63 18 22% 2 12 0 0
13 John Gonzalo Robles Zavaleta
Iron Lion Tyson
165 66 11 14% 2 10 0 0
14 Mauro Pompili
Torino Warriors
163 59 15 20% 0 8 1 0
15 Stefano Santangelo
Torino Warriors
159 48 21 30% 0 7 3 0
16 Simone Abbona
Driphit
144 45 18 29% 2 8 0 0
17 Paolo Guerra
Meatballs
141 63 5 7% 1 8 0 0
18 Tommaso Faletti
Iron Lion Tyson
133 65 1 2% 3 10 2 0
19 Federico Tibaldi
Hit Bulls
131 37 19 34% 2 9 0 0
20 Andrea Brossa
Driphit
131 49 11 18% 2 7 0 0
21 Davide Casalegno
Nomadi Venaria
126 48 10 17% 3 7 0 0
22 Angelo D'Alessandra
Guardians Chivasso
126 57 4 7% 1 9 0 0
23 Davide Martini
Dracarys Chivasso
125 43 13 23% 0 10 0 0
24 Massimiliano Taglianetti
Meatballs
119 40 13 25% 1 8 0 0
25 Luca Curti
Nomadi Venaria
118 41 12 23% 0 7 0 0
26 Francesco De Gaetano
Torino Warriors
117 39 13 25% 1 7 1 0
27 Flavio Caiano
Driphit
111 45 7 13% 0 7 0 0
28 Alex Serratore
Sporting Team Next Gen
108 36 12 25% 0 8 0 0
29 Antonio Marincola
Sporting Team Next Gen
104 34 12 26% 2 8 0 0
30 Alessandro Santomaggio
Decepticon
104 40 8 17% 0 8 0 0
31 Franco Giambanco
Sporting Team Next Gen
103 41 7 15% 1 8 0 0
32 Marcello Saporito
Guardians Chivasso
103 41 7 15% 1 8 0 0
33 Federico Gennaro
Guardians Chivasso
97 41 5 11% 0 8 0 0
34 Alessandro Rolino
Nomadi Venaria
95 40 5 11% 0 9 0 0
35 Simone Guglielmetto
Decepticon
94 41 4 9% 0 8 0 0
36 Andrea De Blasio
Meatballs
93 39 5 11% 0 7 0 0
37 Kevin Calvo
Hit Bulls
93 42 3 7% 1 10 0 0
38 Pietro Magrì
Dracarys Chivasso
92 43 2 4% 0 11 0 0
39 Riccardo Toppan
Decepticon
91 35 7 17% 0 8 0 0
40 Nicolò Negrini
Hit Bulls
90 39 4 9% 1 10 0 0
41 Ivano Reato
Guardians Chivasso
89 40 3 7% 0 9 0 0
42 Simone Marcarino
Iron Lion Tyson
88 35 6 15% 0 9 1 0
43 Jacopo Sanfilippo
Torino Warriors
87 24 13 35% 0 5 0 0
44 Justin Ossai
Meatballs
85 29 9 24% 0 8 0 0
45 Christian Alescio
Nomadi Venaria
82 32 6 16% 0 7 0 0
46 Benito Manuel Marino
Guardians Chivasso
81 21 13 38% 0 5 0 0
47 Luca Cavaglià
Decepticon
73 32 3 9% 0 7 0 0
48 Marco Gamba
Torino Warriors
65 25 5 17% 0 6 1 0
49 Davide Pivato
Torino Warriors
65 25 5 17% 2 6 0 0
50 Matteo Roma
Dracarys Chivasso
65 28 3 10% 4 11 0 0
51 Marco Rizzo
Iron Lion Tyson
64 32 0 0 2 7 1 0
52 Mattia Bucci
Nomadi Venaria
60 27 2 7% 1 7 0 0
53 Federico Solinas
Torino Warriors
59 19 7 27% 0 5 0 0
54 Simone Mazza
Driphit
59 28 1 3% 1 8 0 0
55 Emanuele Filiberto Pellegrin
Dracarys Chivasso
54 24 2 8% 1 11 1 0
56 Samuele Dogliani
Iron Lion Tyson
53 22 3 12% 0 7 0 0
57 Alberto Gabriolo
Hit Bulls
47 16 5 24% 1 5 0 0
58 Federico Listello
Meatballs
44 19 2 10% 1 7 0 0
59 Mauro Mola
Meatballs
44 22 0 0 0 8 0 0
60 Mattia Maggio
Driphit
38 16 2 11% 0 7 1 0
61 Daniele Barbato
Decepticon
32 13 2 13% 2 8 0 0
62 Carlo Del console
Sporting Team Next Gen
28 14 0 0 1 6 0 0
63 Dante Accarini
Driphit
20 7 2 22% 1 8 0 0
64 Fabrizio Alberto
Torino Warriors
18 6 2 25% 0 6 1 0
65 Antonio D'Elicio
Torino Warriors
17 7 1 13% 0 4 0 0
66 Marco Lorandi
Meatballs
15 6 1 14% 0 7 0 0
67 Alessandro Maggio
Driphit
14 7 0 0 0 6 1 0
68 Stefano Bollito
Sporting Team Next Gen
10 5 0 0 0 4 0 0
69 Rocco Barbaro
Iron Lion Tyson
6 3 0 0 0 2 0 0
70 Valerio Ianniello
Hit Bulls
6 3 0 0 1 2 0 0
71 Stefano Lavino
Decepticon
2 1 0 0 0 2 0 0
72 Stefano Borelli
Torino Warriors
0 0 0 0 0 0 0 0
73 Vincenzo Padula
Sporting Team Next Gen
0 0 0 0 0 1 0 0
74 Riccardo Santoro
Nomadi 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 Zanfretta
Nomadi Venaria
39 15 3 17% 0 11 0 0
2 Arianna Vismara
Sporting Team Next Gen
34 17 0 0 1 8 0 0
3 Sara Sottolano
Meatballs
12 3 2 40% 0 5 0 0
4 Martina Bracesco
Nomadi Venaria
0 0 0 0 0 1 0 0
5 Rossella De Blasio
Meatballs
0 0 0 0 0 0 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni
                Total Queries: 30
        Total Time: 0.50360798835754
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770965376.2332
            [end] => 1770965376.2335
            [time] => 0.0003509521484375
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1770965376.2357
            [end] => 1770965376.236
            [time] => 0.00032591819763184
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1770965376.2361
            [end] => 1770965376.2364
            [time] => 0.00026082992553711
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (4228,4226,4229,4227,4225,4232,4233,4231,4230,4234,4238,4236,4237,4239,4235,4240,4242,4244,4241,4243,4248,4249,4246,4247,4245,4250,4252,4254,4253,4251,4255,4256,4257,4259,4258,4260,4261,4263,4264,4262,4265,4266,4269,4267,4268,4271,4270,4272,4274,4273,4275,4277,4276,4278,4279,4281,4283,4284,4282,4280,4285,4289,4286,4288,4287,4290,4293,4291,4294,4292,4295,4297,4296,4298,4299,4303,4301,4302,4304,4300,4305,4307,4306,4309,4308,4311,4313,4312,4314,4310) order by id ASC
            [start] => 1770965376.2401
            [end] => 1770965376.2431
            [time] => 0.00301194190979
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (4228,4226,4229,4227,4225,4232,4233,4231,4230,4234,4238,4236,4237,4239,4235,4240,4242,4244,4241,4243,4248,4249,4246,4247,4245,4250,4252,4254,4253,4251,4255,4256,4257,4259,4258,4260,4261,4263,4264,4262,4265,4266,4269,4267,4268,4271,4270,4272,4274,4273,4275,4277,4276,4278,4279,4281,4283,4284,4282,4280,4285,4289,4286,4288,4287,4290,4293,4291,4294,4292,4295,4297,4296,4298,4299,4303,4301,4302,4304,4300,4305,4307,4306,4309,4308,4311,4313,4312,4314,4310)
            [start] => 1770965376.321
            [end] => 1770965376.3351
            [time] => 0.014087915420532
        )

    [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 <= 1770965376 OR start >= 1770965376) AND (end >= 1770965376 OR end = 0) AND (start < 1770965376) ORDER BY name ASC
            [start] => 1770965376.3634
            [end] => 1770965376.3644
            [time] => 0.00098991394042969
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1770965376.3645
            [end] => 1770965376.3647
            [time] => 0.00020098686218262
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1770965376.3648
            [end] => 1770965376.365
            [time] => 0.00023603439331055
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (4228,4226,4229,4227,4225,4232,4233,4231,4230,4234,4238,4236,4237,4239,4235,4240,4242,4244,4241,4243,4248,4249,4246,4247,4245,4250,4252,4254,4253,4251,4255,4256,4257,4259,4258,4260,4261,4263,4264,4262,4265,4266,4269,4267,4268,4271,4270,4272,4274,4273,4275,4277,4276,4278,4279,4281,4283,4284,4282,4280,4285,4289,4286,4288,4287,4290,4293,4291,4294,4292,4295,4297,4296,4298,4299,4303,4301,4302,4304,4300,4305,4307,4306,4309,4308,4311,4313,4312,4314,4310) order by id ASC
            [start] => 1770965376.3688
            [end] => 1770965376.372
            [time] => 0.0031981468200684
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1770965376.4489
            [end] => 1770965376.4493
            [time] => 0.00040006637573242
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1770965376.4502
            [end] => 1770965376.4504
            [time] => 0.00023221969604492
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1770965376.4505
            [end] => 1770965376.4507
            [time] => 0.0002439022064209
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1770965376.4508
            [end] => 1770965376.451
            [time] => 0.00020217895507812
        )

    [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 <= 1756214247 OR start >= 1756214247) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (5,7,56,8,12,25,24,47,4,33) ORDER BY lastname,firstname ASC
            [start] => 1770965376.4511
            [end] => 1770965376.4525
            [time] => 0.0014059543609619
        )

    [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 = '42') 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] => 1770965376.453
            [end] => 1770965376.4666
            [time] => 0.013640880584717
        )

    [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 = '42')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1770965376.4669
            [end] => 1770965376.7175
            [time] => 0.25056600570679
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1770965376.7186
            [end] => 1770965376.7189
            [time] => 0.00032591819763184
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1770965376.719
            [end] => 1770965376.7193
            [time] => 0.00026297569274902
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1770965376.7193
            [end] => 1770965376.7196
            [time] => 0.00024509429931641
        )

    [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 <= 1756214247 OR start >= 1756214247) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (5,7,56,8,12,25,24,47,4,33) ORDER BY lastname,firstname ASC
            [start] => 1770965376.7197
            [end] => 1770965376.7207
            [time] => 0.0010421276092529
        )

    [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 = '42') 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] => 1770965376.7209
            [end] => 1770965376.7343
            [time] => 0.013430118560791
        )

    [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 = '42')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1770965376.7344
            [end] => 1770965376.9207
            [time] => 0.18633484840393
        )

    [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 <= 1756214247 OR start >= 1756214247) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) ORDER BY lastname,firstname ASC
            [start] => 1770965376.921
            [end] => 1770965376.9251
            [time] => 0.0041460990905762
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1770965376.9287
            [end] => 1770965376.929
            [time] => 0.0002439022064209
        )

    [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 <= 1770965376 OR start >= 1770965376) AND (end >= 1770965376 OR end = 0) AND (start < 1770965376) ORDER BY name ASC
            [start] => 1770965376.929
            [end] => 1770965376.9299
            [time] => 0.00088596343994141
        )

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

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

)