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

Campionati: Campionato Eccellenza 2023/2024 B1

  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 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
        )

)