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 Meatballs 3 1 1 0 94 74 20
2 Guardians Chivasso 3 1 1 0 94 85 9
3 Decepticon 0 0 0 0 0 0 0
4 Driphit 0 0 0 0 0 0 0
5 Hit Bulls 0 0 0 0 0 0 0
6 Iron Lion Tyson 0 0 0 0 0 0 0
7 Nomadi Venaria 0 0 0 0 0 0 0
8 Torino Warriors 0 0 0 0 0 0 0
9 Sporting Team Next Gen 0 1 0 1 85 94 -9
10 Dracarys Chivasso 0 1 0 1 74 94 -20
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 Riccardo Pajno Ferrara
Sporting Team Next Gen
37 14 3 18% 0 1 0 0
2 Rosso Paolo
Guardians Chivasso
31 11 3 21% 0 1 0 0
3 Paolo Guerra
Meatballs
28 14 0 0 0 1 0 0
4 Manuel Spatafora
Guardians Chivasso
27 9 3 25% 0 1 0 0
5 Antonio Marincola
Sporting Team Next Gen
26 10 2 17% 0 1 0 0
6 Justin Ossai
Meatballs
22 5 4 44% 0 1 0 0
7 Francesco Dughera
Dracarys Chivasso
22 8 2 20% 0 1 0 0
8 Adriano Paribello Grasso
Dracarys Chivasso
18 9 0 0 0 1 0 0
9 Andrea De Blasio
Meatballs
17 7 1 13% 0 1 0 0
10 Alex Serratore
Sporting Team Next Gen
16 5 2 29% 0 1 0 0
11 Marco Schiaroli
Dracarys Chivasso
12 3 2 40% 0 1 0 0
12 Massimiliano Taglianetti
Meatballs
12 3 2 40% 0 1 0 0
13 Federico Gennaro
Guardians Chivasso
11 4 1 20% 0 1 0 0
14 Ivano Reato
Guardians Chivasso
10 5 0 0 0 1 0 0
15 Davide Martini
Dracarys Chivasso
9 3 1 25% 0 1 0 0
16 Marcello Saporito
Guardians Chivasso
9 3 1 25% 0 1 0 0
17 Mauro Mola
Meatballs
8 4 0 0 0 1 0 0
18 Matteo Roma
Dracarys Chivasso
7 2 1 33% 1 1 0 0
19 Angelo D'Alessandra
Guardians Chivasso
6 3 0 0 0 1 0 0
20 Federico Listello
Meatballs
6 3 0 0 0 1 0 0
21 Emanuele Filiberto Pellegrin
Dracarys Chivasso
6 3 0 0 0 1 0 0
22 Carlo Del console
Sporting Team Next Gen
4 2 0 0 0 1 0 0
23 Franco Giambanco
Sporting Team Next Gen
2 1 0 0 0 1 0 0
24 Simone Abbona
Driphit
0 0 0 0 0 0 0 0
25 Fabrizio Alberto
Torino Warriors
0 0 0 0 0 0 0 0
26 Christian Alescio
Nomadi Venaria
0 0 0 0 0 0 0 0
27 Matteo Amideo
Iron Lion Tyson
0 0 0 0 0 0 0 0
28 Giuseppe Armanno
Decepticon
0 0 0 0 0 0 0 0
29 Rocco Barbaro
Iron Lion Tyson
0 0 0 0 0 0 0 0
30 Daniele Barbato
Decepticon
0 0 0 0 0 0 0 0
31 Stefano Bollito
Sporting Team Next Gen
0 0 0 0 0 0 0 0
32 Nicolò Bonincontro
Hit Bulls
0 0 0 0 0 0 0 0
33 Stefano Borelli
Torino Warriors
0 0 0 0 0 0 0 0
34 Andrea Brossa
Driphit
0 0 0 0 0 0 0 0
35 Edoardo Bruno
Iron Lion Tyson
0 0 0 0 0 0 0 0
36 Mattia Bucci
Nomadi Venaria
0 0 0 0 0 0 0 0
37 Flavio Caiano
Driphit
0 0 0 0 0 0 0 0
38 Kevin Calvo
Hit Bulls
0 0 0 0 0 0 0 0
39 Luca Cavaglià
Decepticon
0 0 0 0 0 0 0 0
40 Luca Curti
Nomadi Venaria
0 0 0 0 0 0 0 0
41 Antonio D'Elicio
Torino Warriors
0 0 0 0 0 0 0 0
42 Francesco De Gaetano
Torino Warriors
0 0 0 0 0 0 0 0
43 Samuele Dogliani
Iron Lion Tyson
0 0 0 0 0 0 0 0
44 Tommaso Faletti
Iron Lion Tyson
0 0 0 0 0 0 0 0
45 Alberto Gabriolo
Hit Bulls
0 0 0 0 0 0 0 0
46 Marco Gamba
Torino Warriors
0 0 0 0 0 0 0 0
47 Simone Guglielmetto
Decepticon
0 0 0 0 0 0 0 0
48 Marco Lorandi
Meatballs
0 0 0 0 0 1 0 0
49 Alessandro Maggio
Driphit
0 0 0 0 0 0 0 0
50 Mattia Maggio
Driphit
0 0 0 0 0 0 0 0
51 Pietro Magrì
Dracarys Chivasso
0 0 0 0 0 0 0 0
52 Simone Marcarino
Iron Lion Tyson
0 0 0 0 0 0 0 0
53 Benito Manuel Marino
Guardians Chivasso
0 0 0 0 0 0 0 0
54 Simone Mazza
Driphit
0 0 0 0 0 0 0 0
55 Nicolò Negrini
Hit Bulls
0 0 0 0 0 0 0 0
56 Vincenzo Padula
Sporting Team Next Gen
0 0 0 0 0 0 0 0
57 Davide Pivato
Torino Warriors
0 0 0 0 0 0 0 0
58 Mauro Pompili
Torino Warriors
0 0 0 0 0 0 0 0
59 Marco Rizzo
Iron Lion Tyson
0 0 0 0 0 0 0 0
60 John Gonzalo Robles Zavaleta
Iron Lion Tyson
0 0 0 0 0 0 0 0
61 Alessandro Rolino
Nomadi Venaria
0 0 0 0 0 0 0 0
62 Jacopo Sanfilippo
Torino Warriors
0 0 0 0 0 0 0 0
63 Stefano Santangelo
Torino Warriors
0 0 0 0 0 0 0 0
64 Alessandro Santomaggio
Decepticon
0 0 0 0 0 0 0 0
65 Riccardo Santoro
Nomadi Venaria
0 0 0 0 0 0 0 0
66 Federico Solinas
Torino Warriors
0 0 0 0 0 0 0 0
67 Pier Paolo Specchiulli
Hit Bulls
0 0 0 0 0 0 0 0
68 Federico Tibaldi
Hit Bulls
0 0 0 0 0 0 0 0
69 Riccardo Toppan
Decepticon
0 0 0 0 0 0 0 0
70 Federico Zoccarato
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 Martina Bracesco
Nomadi Venaria
0 0 0 0 0 0 0 0
2 Rossella De Blasio
Meatballs
0 0 0 0 0 0 0 0
3 Sara Sottolano
Meatballs
0 0 0 0 0 0 0 0
4 Arianna Vismara
Sporting Team Next Gen
0 0 0 0 0 1 0 0
5 Sabrina Zanfretta
Nomadi Venaria
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.41663241386414
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034221.4011
            [end] => 1766034221.4015
            [time] => 0.00043296813964844
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1766034221.4036
            [end] => 1766034221.404
            [time] => 0.00035715103149414
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1766034221.4041
            [end] => 1766034221.4043
            [time] => 0.00024795532226562
        )

    [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] => 1766034221.4044
            [end] => 1766034221.4072
            [time] => 0.0028030872344971
        )

    [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,4258,4255,4256,4257,4259,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] => 1766034221.4078
            [end] => 1766034221.4103
            [time] => 0.0024318695068359
        )

    [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,4258,4255,4256,4257,4259,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] => 1766034221.4138
            [end] => 1766034221.4266
            [time] => 0.012871980667114
        )

    [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 <= 1766034221 OR start >= 1766034221) AND (end >= 1766034221 OR end = 0) AND (start < 1766034221) ORDER BY name ASC
            [start] => 1766034221.4541
            [end] => 1766034221.4551
            [time] => 0.0009758472442627
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1766034221.4552
            [end] => 1766034221.4554
            [time] => 0.00023388862609863
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1766034221.4555
            [end] => 1766034221.4558
            [time] => 0.00026488304138184
        )

    [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] => 1766034221.4559
            [end] => 1766034221.4588
            [time] => 0.0028541088104248
        )

    [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,4258,4255,4256,4257,4259,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] => 1766034221.4594
            [end] => 1766034221.4618
            [time] => 0.0024769306182861
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1766034221.4653
            [end] => 1766034221.4657
            [time] => 0.00039887428283691
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1766034221.4663
            [end] => 1766034221.4665
            [time] => 0.00022292137145996
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1766034221.4666
            [end] => 1766034221.4668
            [time] => 0.00025391578674316
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1766034221.4668
            [end] => 1766034221.4671
            [time] => 0.00020408630371094
        )

    [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] => 1766034221.4672
            [end] => 1766034221.4685
            [time] => 0.0013179779052734
        )

    [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] => 1766034221.469
            [end] => 1766034221.4805
            [time] => 0.011543035507202
        )

    [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] => 1766034221.4807
            [end] => 1766034221.6719
            [time] => 0.19119381904602
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '42'
            [start] => 1766034221.6726
            [end] => 1766034221.673
            [time] => 0.00032281875610352
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1766034221.6731
            [end] => 1766034221.6733
            [time] => 0.00026893615722656
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '42'
            [start] => 1766034221.6733
            [end] => 1766034221.6736
            [time] => 0.0002589225769043
        )

    [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] => 1766034221.6737
            [end] => 1766034221.6746
            [time] => 0.00094103813171387
        )

    [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] => 1766034221.6748
            [end] => 1766034221.6862
            [time] => 0.011465072631836
        )

    [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] => 1766034221.6863
            [end] => 1766034221.8526
            [time] => 0.16628503799438
        )

    [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] => 1766034221.8528
            [end] => 1766034221.8565
            [time] => 0.0036880970001221
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034221.8599
            [end] => 1766034221.8601
            [time] => 0.00025391578674316
        )

    [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 <= 1766034221 OR start >= 1766034221) AND (end >= 1766034221 OR end = 0) AND (start < 1766034221) ORDER BY name ASC
            [start] => 1766034221.8602
            [end] => 1766034221.8609
            [time] => 0.00075101852416992
        )

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

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

)