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

Campionati: Campionato Eccellenza 2023/2024 B1

  1. Home
  2. Campionati
  3. Campionati

Giovedì 02-11-2023

Venerdì 03-11-2023

Domenica 05-11-2023

Giovedì 09-11-2023

Venerdì 10-11-2023

Mercoledì 15-11-2023

Venerdì 17-11-2023

Domenica 19-11-2023

Mercoledì 22-11-2023

Venerdì 24-11-2023

Domenica 26-11-2023

Giovedì 30-11-2023

Venerdì 01-12-2023

Domenica 03-12-2023

Martedì 05-12-2023

Giovedì 07-12-2023

Martedì 12-12-2023

Venerdì 15-12-2023

Martedì 09-01-2024

Mercoledì 10-01-2024

Domenica 14-01-2024

Domenica 21-01-2024

Lunedì 22-01-2024

Martedì 23-01-2024

Venerdì 26-01-2024

Domenica 28-01-2024

Martedì 30-01-2024

Venerdì 02-02-2024

Domenica 04-02-2024

Martedì 06-02-2024

Giovedì 08-02-2024

Venerdì 09-02-2024

Mercoledì 14-02-2024

Venerdì 16-02-2024

Lunedì 19-02-2024

Martedì 20-02-2024

Giovedì 22-02-2024

Domenica 25-02-2024

Mercoledì 28-02-2024

Venerdì 01-03-2024

Domenica 03-03-2024

Lunedì 04-03-2024

Martedì 05-03-2024

Venerdì 08-03-2024

Domenica 10-03-2024

Martedì 12-03-2024

Mercoledì 13-03-2024

Venerdì 15-03-2024

Giovedì 21-03-2024

Venerdì 22-03-2024

Domenica 24-03-2024

Martedì 26-03-2024

Mercoledì 03-04-2024

Giovedì 04-04-2024

Venerdì 05-04-2024

Venerdì 12-04-2024

Domenica 14-04-2024

Mercoledì 17-04-2024

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 Get To Hit 33 18 11 7 1542 1359 183
5 Decepticon 24 18 8 10 1519 1567 -48
6 I Gadan 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
Get To Hit 		415 128 53 29% 1 16 0 0
3 Davide Pivato
I Gadan 		402 114 58 34% 0 17 0 0
4 Alberto Gabriolo
Hit Bulls 		396 117 54 32% 3 18 0 0
5 Stefano Santangelo
I Gadan 		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
Get To Hit 		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
I Gadan 		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
Get To Hit 		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è
I Gadan 		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
I Gadan 		164 61 14 19% 1 18 0 0
28 Federico Tibaldi
Hit Bulls 		162 54 18 25% 3 17 0 0
29 Andrea Tapella
Get To Hit 		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ì
Get To Hit 		133 59 5 8% 1 17 1 0
33 Francesco Rigoni
Get To Hit 		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
Get To Hit 		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
Get To Hit 		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
I Gadan 		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.62592434883118
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781154540.4008
            [end] => 1781154540.4011
            [time] => 0.00031399726867676
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1781154540.4038
            [end] => 1781154540.4041
            [time] => 0.00030994415283203
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1781154540.4043
            [end] => 1781154540.4045
            [time] => 0.0002899169921875
        )

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

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

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

    [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 <= 1781154540 OR start >= 1781154540) AND (end >= 1781154540 OR end = 0) AND (start < 1781154540) ORDER BY name ASC
            [start] => 1781154540.6631
            [end] => 1781154540.6644
            [time] => 0.0013129711151123
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1781154540.6645
            [end] => 1781154540.6647
            [time] => 0.00023317337036133
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1781154540.6648
            [end] => 1781154540.6651
            [time] => 0.00025486946105957
        )

    [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] => 1781154540.6652
            [end] => 1781154540.6684
            [time] => 0.0031459331512451
        )

    [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] => 1781154540.669
            [end] => 1781154540.6728
            [time] => 0.003777027130127
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1781154540.8519
            [end] => 1781154540.8524
            [time] => 0.0004880428314209
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1781154540.854
            [end] => 1781154540.8543
            [time] => 0.0002448558807373
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1781154540.8544
            [end] => 1781154540.8546
            [time] => 0.00024604797363281
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1781154540.8546
            [end] => 1781154540.8549
            [time] => 0.00023698806762695
        )

    [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] => 1781154540.855
            [end] => 1781154540.8565
            [time] => 0.0014901161193848
        )

    [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] => 1781154540.8569
            [end] => 1781154540.8729
            [time] => 0.015970945358276
        )

    [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] => 1781154540.8731
            [end] => 1781154541.1935
            [time] => 0.32032704353333
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '20'
            [start] => 1781154541.1944
            [end] => 1781154541.1947
            [time] => 0.00030016899108887
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1781154541.1948
            [end] => 1781154541.1951
            [time] => 0.00026702880859375
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '20'
            [start] => 1781154541.1951
            [end] => 1781154541.1953
            [time] => 0.00022196769714355
        )

    [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] => 1781154541.1954
            [end] => 1781154541.1965
            [time] => 0.0011250972747803
        )

    [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] => 1781154541.1967
            [end] => 1781154541.2125
            [time] => 0.015781879425049
        )

    [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] => 1781154541.2126
            [end] => 1781154541.4427
            [time] => 0.23014998435974
        )

    [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] => 1781154541.4429
            [end] => 1781154541.4465
            [time] => 0.0035848617553711
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781154541.4496
            [end] => 1781154541.45
            [time] => 0.00036406517028809
        )

    [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 (start = 0 OR start <= 1781154541 OR start >= 1781154541) AND (end >= 1781154541 OR end = 0) AND (start < 1781154541) ORDER BY name ASC
            [start] => 1781154541.45
            [end] => 1781154541.451
            [time] => 0.00095701217651367
        )

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

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

)