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

Campionati: Campionato Eccellenza 2023/2024 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 Black Knights 46 18 15 3 1817 1421 396
2 Rising Titans 44 18 15 3 1704 1394 310
3 Hit Bulls 42 18 14 4 1605 1340 265
4 Bioghettyson 33 18 11 7 1542 1359 183
5 Decepticon 24 18 8 10 1519 1567 -48
6 Igadan 24 18 8 10 1680 1598 82
7 Dracarys Chivasso 24 18 8 10 1529 1531 -2
8 Hocheti Pokety 24 18 8 10 1686 1670 16
9 Iron Lion Tyson 9 18 3 15 1335 1596 -261
10 Delirium Consulum -1 18 0 18 886 1827 -941
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 Giuseppe Armanno
Decepticon
470 106 86 45% 0 16 0 0
2 Emiliano Travaglini
Bioghettyson
415 128 53 29% 1 16 0 0
3 Davide Pivato
Igadan
402 114 58 34% 0 17 0 0
4 Alberto Gabriolo
Hit Bulls
396 117 54 32% 3 18 0 0
5 Stefano Santangelo
Igadan
390 132 42 24% 1 18 1 0
6 Lorenzo De Nicola Civitarese
Black Knights
377 124 43 26% 0 18 0 0
7 Simone De Meo
Hocheti Pokety
366 141 28 17% 1 17 0 0
8 Paul Mihei
Bioghettyson
351 117 39 25% 4 17 1 0
9 Ramon Rutigliano
Hocheti Pokety
350 121 36 23% 3 18 0 0
10 Francesco De Gaetano
Igadan
333 108 39 27% 0 17 0 0
11 Nicolò Bonincontro
Hit Bulls
309 129 17 12% 0 17 1 0
12 Manuel Spatafora
Dracarys Chivasso
304 128 16 11% 3 18 0 0
13 Emilio Bertello
Hit Bulls
298 110 26 19% 2 18 0 0
14 Gianluca Varetto
Black Knights
296 106 28 21% 2 17 0 0
15 Kevin Calvo
Hit Bulls
289 104 27 21% 0 18 0 0
16 Alberto Racco
Hocheti Pokety
278 106 22 17% 0 15 0 0
17 Paolo Lamberti
Delirium Consulum
250 89 24 21% 0 15 0 0
18 Marco Barrasso
Bioghettyson
242 64 38 37% 1 12 1 0
19 Luigi Ghirardi
Hocheti Pokety
241 89 21 19% 4 17 7 0
20 Marco Antinoro
Black Knights
229 74 27 27% 1 17 0 0
21 Emanuele Massè
Igadan
222 69 28 29% 2 17 1 0
22 Riccardo Toppan
Decepticon
222 84 18 18% 1 18 0 0
23 Ivan Dastrù
Hocheti Pokety
220 74 24 24% 2 12 0 0
24 Luca Cavaglià
Decepticon
205 92 7 7% 1 18 0 0
25 Renato Dalle Mura
Delirium Consulum
196 83 10 11% 1 16 1 0
26 Fabio Bragagnolo
Black Knights
193 65 21 24% 2 16 0 0
27 Fabrizio Alberto
Igadan
164 61 14 19% 1 18 0 0
28 Federico Tibaldi
Hit Bulls
162 54 18 25% 3 17 0 0
29 Andrea Tapella
Bioghettyson
153 69 5 7% 0 16 1 0
30 Dino Pagano
Delirium Consulum
142 62 6 9% 2 12 0 0
31 Nicolò Negrini
Hit Bulls
136 53 10 16% 0 18 0 0
32 Francesco Mongiovì
Bioghettyson
133 59 5 8% 1 17 1 0
33 Francesco Rigoni
Bioghettyson
132 45 14 24% 1 16 0 0
34 Davide Baldus
Delirium Consulum
122 55 4 7% 2 18 0 0
35 Stefano Lavino
Decepticon
116 49 6 11% 0 18 0 0
36 Simone Guglielmetto
Decepticon
115 50 5 9% 0 15 1 0
37 Andrea Matys
Delirium Consulum
108 48 4 8% 3 16 1 0
38 Thomas Rovetto
Hocheti Pokety
86 34 6 15% 2 16 0 0
39 Daniele Barbato
Decepticon
78 36 2 5% 1 18 0 0
40 Tommaso Baudi Di Vesme Gabutti
Bioghettyson
77 37 1 3% 1 14 0 0
41 Pietro Chevallard
Delirium Consulum
58 26 2 7% 3 14 0 0
42 Samuel Romanazzi
Hocheti Pokety
56 13 10 43% 0 5 5 0
43 Simone Garino
Bioghettyson
48 21 2 9% 0 14 0 0
44 Gianluca Minuto
Delirium Consulum
44 22 0 0 1 13 1 0
45 Mattia Allemano
Iron Lion Tyson
0 0 0 0 0 0 0 0
46 Matteo Amideo
Iron Lion Tyson
0 0 0 0 0 0 0 0
47 Giovanni Aquila
Delirium Consulum
0 0 0 0 0 0 0 0
48 Alessandro Bruno
Iron Lion Tyson
0 0 0 0 0 0 0 0
49 Edoardo Bruno
Iron Lion Tyson
0 0 0 0 0 0 0 0
50 Massimiliano Casigli
Black Knights
0 0 0 0 0 0 0 0
51 Angelo Lorenzo Eliantonio
Iron Lion Tyson
0 0 0 0 0 0 0 0
52 Tommaso Faletti
Iron Lion Tyson
0 0 0 0 0 0 0 0
53 Francesco Ghio
Dracarys Chivasso
0 0 0 0 0 0 0 0
54 Pietro Magrì
Dracarys Chivasso
0 0 0 0 0 0 0 0
55 Benito Manuel Marino
Dracarys Chivasso
0 0 0 0 0 0 0 0
56 Samuel Maselli
Hocheti Pokety
0 0 0 0 0 0 0 0
57 Emanuele Filiberto Pellegrin
Dracarys Chivasso
0 0 0 0 0 0 0 0
58 Marco Rizzo
Iron Lion Tyson
0 0 0 0 0 0 0 0
59 John Gonzalo Robles Zavaleta
Iron Lion Tyson
0 0 0 0 0 0 0 0
60 Matteo Roma
Dracarys Chivasso
0 0 0 0 0 0 0 0
61 Riccardo Sacchetto
Hit Bulls
0 0 0 0 0 0 0 0
62 Pier Paolo Specchiulli
Hit Bulls
0 0 0 0 0 0 0 0
63 Alessandro Varetto
Black Knights
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 Lucrezia Principato
Igadan
50 25 0 0 1 18 0 0
2 Giulia Crespan
Dracarys Chivasso
0 0 0 0 0 0 0 0
3 Eva Silvia Grasso
Dracarys Chivasso
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.42960333824158
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034189.6966
            [end] => 1766034189.697
            [time] => 0.00033116340637207
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1766034189.6991
            [end] => 1766034189.6993
            [time] => 0.00024294853210449
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1766034189.6994
            [end] => 1766034189.6997
            [time] => 0.00028300285339355
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (3151,3150,3154,3153,3152,3158,3159,3157,3155,3156,3160,3162,3164,3161,3163,3167,3166,3169,3168,3165,3173,3174,3170,3172,3171,3177,3179,3178,3176,3175,3181,3183,3182,3180,3184,3185,3186,3188,3189,3187,3192,3191,3190,3193,3194,3196,3197,3198,3195,3199,3201,3200,3203,3204,3202,3208,3209,3206,3205,3207,3211,3213,3214,3210,3212,3219,3217,3218,3215,3216,3223,3224,3221,3222,3220,3225,3227,3229,3228,3226,3233,3234,3232,3231,3230,3236,3237,3235,3239,3238) order by id ASC
            [start] => 1766034189.7032
            [end] => 1766034189.7061
            [time] => 0.0029428005218506
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3151,3150,3154,3153,3152,3158,3159,3157,3155,3156,3160,3162,3164,3161,3163,3167,3166,3169,3168,3165,3173,3174,3170,3172,3171,3177,3179,3178,3176,3175,3181,3183,3182,3180,3184,3185,3186,3188,3189,3187,3192,3191,3190,3193,3194,3196,3197,3198,3195,3199,3201,3200,3203,3204,3202,3208,3209,3206,3205,3207,3211,3213,3214,3210,3212,3219,3217,3218,3215,3216,3223,3224,3221,3222,3220,3225,3227,3229,3228,3226,3233,3234,3232,3231,3230,3236,3237,3235,3239,3238)
            [start] => 1766034189.8412
            [end] => 1766034189.8545
            [time] => 0.013350009918213
        )

    [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 <= 1766034189 OR start >= 1766034189) AND (end >= 1766034189 OR end = 0) AND (start < 1766034189) ORDER BY name ASC
            [start] => 1766034189.8813
            [end] => 1766034189.8823
            [time] => 0.00099492073059082
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1766034189.8823
            [end] => 1766034189.8826
            [time] => 0.00023603439331055
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1766034189.8827
            [end] => 1766034189.8829
            [time] => 0.00025677680969238
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (3151,3150,3154,3153,3152,3158,3159,3157,3155,3156,3160,3162,3164,3161,3163,3167,3166,3169,3168,3165,3173,3174,3170,3172,3171,3177,3179,3178,3176,3175,3181,3183,3182,3180,3184,3185,3186,3188,3189,3187,3192,3191,3190,3193,3194,3196,3197,3198,3195,3199,3201,3200,3203,3204,3202,3208,3209,3206,3205,3207,3211,3213,3214,3210,3212,3219,3217,3218,3215,3216,3223,3224,3221,3222,3220,3225,3227,3229,3228,3226,3233,3234,3232,3231,3230,3236,3237,3235,3239,3238) order by id ASC
            [start] => 1766034189.8865
            [end] => 1766034189.8894
            [time] => 0.0029599666595459
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1766034190.0243
            [end] => 1766034190.0247
            [time] => 0.00046300888061523
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1766034190.0263
            [end] => 1766034190.0266
            [time] => 0.00023698806762695
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1766034190.0266
            [end] => 1766034190.0269
            [time] => 0.00024795532226562
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1766034190.0269
            [end] => 1766034190.0271
            [time] => 0.00021505355834961
        )

    [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 <= 1693761138 OR start >= 1693761138) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (23,5,49,7,37,12,6,28,25,3) ORDER BY lastname,firstname ASC
            [start] => 1766034190.0272
            [end] => 1766034190.0285
            [time] => 0.0012960433959961
        )

    [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 = '20') 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] => 1766034190.029
            [end] => 1766034190.0409
            [time] => 0.011934995651245
        )

    [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 = '20')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034190.0411
            [end] => 1766034190.2435
            [time] => 0.20235586166382
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1766034190.2444
            [end] => 1766034190.2447
            [time] => 0.00033211708068848
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1766034190.2448
            [end] => 1766034190.2451
            [time] => 0.0002601146697998
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1766034190.2451
            [end] => 1766034190.2453
            [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 <= 1693761138 OR start >= 1693761138) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (23,5,49,7,37,12,6,28,25,3) ORDER BY lastname,firstname ASC
            [start] => 1766034190.2454
            [end] => 1766034190.2464
            [time] => 0.0009920597076416
        )

    [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 = '20') 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] => 1766034190.2465
            [end] => 1766034190.2586
            [time] => 0.012046813964844
        )

    [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 = '20')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034190.2587
            [end] => 1766034190.4248
            [time] => 0.16610503196716
        )

    [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 <= 1693761138 OR start >= 1693761138) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) ORDER BY lastname,firstname ASC
            [start] => 1766034190.425
            [end] => 1766034190.4283
            [time] => 0.0033659934997559
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034190.4313
            [end] => 1766034190.4316
            [time] => 0.00023698806762695
        )

    [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 <= 1766034190 OR start >= 1766034190) AND (end >= 1766034190 OR end = 0) AND (start < 1766034190) ORDER BY name ASC
            [start] => 1766034190.4316
            [end] => 1766034190.4324
            [time] => 0.00077486038208008
        )

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

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

)