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

Campionati: Campionato Eccellenza 2023/2024 B2

  1. Home
  2. Campionati
  3. Campionati

Venerdì 03-11-2023

Domenica 05-11-2023

Venerdì 10-11-2023

Domenica 12-11-2023

Giovedì 16-11-2023

Venerdì 17-11-2023

Domenica 19-11-2023

Mercoledì 22-11-2023

Venerdì 24-11-2023

Domenica 26-11-2023

Martedì 28-11-2023

Domenica 03-12-2023

Mercoledì 06-12-2023

Giovedì 07-12-2023

Venerdì 15-12-2023

Domenica 17-12-2023

Domenica 14-01-2024

Martedì 16-01-2024

Venerdì 19-01-2024

Domenica 21-01-2024

Giovedì 25-01-2024

Venerdì 26-01-2024

Domenica 28-01-2024

Venerdì 02-02-2024

Domenica 04-02-2024

Martedì 06-02-2024

Giovedì 08-02-2024

Domenica 18-02-2024

Venerdì 23-02-2024

Domenica 25-02-2024

Mercoledì 28-02-2024

Lunedì 04-03-2024

Lunedì 11-03-2024

Domenica 17-03-2024

Martedì 26-03-2024

Domenica 07-04-2024

Mercoledì 17-04-2024

Venerdì 19-04-2024

Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
1 Skunk Milano 38 14 13 1 1175 738 437
2 Trefferspan 36 14 12 2 1362 906 456
3 Krakens Chivasso 24 14 8 6 1148 1121 27
4 Hitbusters 24 14 8 6 1126 997 129
5 Together Hit 21 14 7 7 1085 1110 -25
6 Meatballs 15 14 5 9 917 962 -45
7 Explichit 8 14 3 11 869 1283 -414
8 Nomadi Venaria 0 14 0 14 881 1446 -565
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 Jacopo Marchitelli
Trefferspan 		423 156 37 19% 1 14 0 0
2 Federico Zoccarato
Nomadi Venaria 		313 89 45 34% 3 13 0 0
3 Giulio Cocirio
Trefferspan 		304 116 24 17% 2 13 0 0
4 Gianluca Sabatino
Together Hit 		279 84 37 31% 0 13 0 0
5 Luca Maria Mercurio
Hitbusters 		248 82 28 25% 0 13 2 0
6 Tommaso Tomasina
Skunk Milano 		246 90 22 20% 0 11 1 0
7 Andrea Crovagna
Together Hit 		245 91 21 19% 1 13 0 0
8 Stefano Mazzilli
Together Hit 		238 65 36 36% 2 13 0 0
9 Paolo Guerra
Meatballs 		236 76 28 27% 2 13 0 0
10 Daniele Tessarin
Hitbusters 		234 78 26 25% 0 13 2 0
11 Francesco Colombo
Skunk Milano 		210 72 22 23% 3 12 0 0
12 Gabriele Di Stefano
Trefferspan 		204 78 16 17% 0 11 0 0
13 Francesco Croci
Trefferspan 		184 62 20 24% 4 14 1 0
14 Lorenzo Zezza
Nomadi Venaria 		182 64 18 22% 2 12 0 0
15 Matteo Folladori
Skunk Milano 		161 73 5 6% 0 11 0 0
16 Riccardo Ajassa
Hitbusters 		155 61 11 15% 1 9 1 0
17 Federico Listello
Meatballs 		153 54 15 22% 0 12 0 0
18 Francesco Cissello
Together Hit 		151 56 13 19% 1 10 0 0
19 Alessandro Perrone
Skunk Milano 		139 56 9 14% 1 10 0 0
20 Stefano Braschi
Skunk Milano 		127 50 9 15% 1 9 1 0
21 Alessandro Caivano
Hitbusters 		125 55 5 8% 1 9 0 0
22 Gabriele Cappero
Nomadi Venaria 		120 51 6 11% 3 11 0 0
23 Davide Rivetti
Trefferspan 		105 39 9 19% 0 12 0 0
24 Alessandro Del Buono
Nomadi Venaria 		84 30 8 21% 0 7 0 0
25 Mauro Mola
Meatballs 		78 30 6 17% 2 12 0 0
26 Gabriele Argirò
Together Hit 		76 29 6 17% 0 9 0 0
27 Christian Alescio
Nomadi Venaria 		75 27 7 21% 2 8 0 0
28 Riccardo Artuffo
Meatballs 		71 31 3 9% 2 11 0 0
29 Simone Basano
Trefferspan 		68 31 2 6% 1 13 0 0
30 Emanuele Nigro
Trefferspan 		65 25 5 17% 1 13 1 0
31 Mauro Maria Pittavino
Together Hit 		61 26 3 10% 2 13 1 0
32 Simone Conti
Nomadi Venaria 		61 29 1 3% 4 10 0 0
33 Gabriele Bonaldo
Meatballs 		56 25 2 7% 1 12 0 0
34 Matteo Galanti
Skunk Milano 		34 14 2 13% 1 10 2 0
35 Jacopo Gatti
Nomadi Venaria 		22 11 0 0 1 10 0 0
36 Edoardo Corigliano
Skunk Milano 		21 6 3 33% 0 1 0 0
37 Nicol Sciretta
Nomadi Venaria 		16 5 2 29% 0 3 0 0
38 Mattia Bucci
Nomadi Venaria 		2 1 0 0 0 2 0 0
39 Mattia Borca
Krakens Chivasso 		0 0 0 0 0 0 0 0
40 Andrea Brocchetta
Krakens Chivasso 		0 0 0 0 0 0 0 0
41 Alessandro Castello
Krakens Chivasso 		0 0 0 0 0 0 0 0
42 Daniele Cecconata
Krakens Chivasso 		0 0 0 0 0 0 0 0
43 Daniele Cena
Krakens Chivasso 		0 0 0 0 0 0 0 0
44 Lorenzo Curti
Nomadi Venaria 		0 0 0 0 0 0 0 0
45 Edoardo Di Noia
Trefferspan 		0 0 0 0 0 0 0 0
46 Simone Gasbarroni
Hitbusters 		0 0 0 0 0 0 0 0
47 Lorenzo Lombardo
Krakens Chivasso 		0 0 0 0 0 0 0 0
48 Marco Lorandi
Meatballs 		0 0 0 0 0 0 0 0
49 Pierluigi Marchisio
Explichit 		0 0 0 0 0 0 0 0
50 Andrea Merlo
Explichit 		0 0 0 0 0 0 0 0
51 Justin Ossai
Hitbusters 		0 0 0 0 0 0 0 0
52 Gaetano Rendine
Explichit 		0 0 0 0 0 0 0 0
53 Massimiliano Taglianetti
Meatballs 		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 Lisa Portarulo
Meatballs 		112 44 8 15% 2 12 0 0
2 Noemi Castelluccio
Hitbusters 		108 54 0 0 0 12 1 0
3 Federica Nardacchione
Hitbusters 		98 49 0 0 2 9 1 0
4 Rossella De Blasio
Meatballs 		42 21 0 0 1 13 0 0
5 Rebecca Aurigemma
Together Hit 		24 12 0 0 0 9 0 0
6 Sara Sottolano
Meatballs 		19 5 3 38% 2 10 0 0
7 Mara Ferraris
Krakens Chivasso 		0 0 0 0 0 0 0 0
8 Chiara Gilardi
Krakens Chivasso 		0 0 0 0 0 0 0 0
9 Sara Marino
Explichit 		0 0 0 0 0 0 0 0
10 Elena Pasino
Explichit 		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.67641949653625
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1786246202.1984
            [end] => 1786246202.2008
            [time] => 0.0023298263549805
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1786246202.2034
            [end] => 1786246202.2058
            [time] => 0.0024011135101318
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1786246202.2059
            [end] => 1786246202.2063
            [time] => 0.00035595893859863
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '21' 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] => 1786246202.2064
            [end] => 1786246202.2126
            [time] => 0.0061659812927246
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (3243,3241,3242,3247,3244,3245,3246,3248,3249,3250,3251,3253,3254,3255,3256,3257,3259,3262,3263,3260,3266,3265,3267,3264,3261,3270,3271,3268,3269,3275,3272,3274,3273,3277,3278,3276,3279,3280,3282,3283,3284,3285,3287,3286,3252,3240,3288,3290,3289,3291,3281,3258,3292,3293,3294,3295) order by id ASC
            [start] => 1786246202.213
            [end] => 1786246202.218
            [time] => 0.0049910545349121
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3243,3241,3242,3247,3244,3245,3246,3248,3249,3250,3251,3253,3254,3255,3256,3257,3259,3262,3263,3260,3266,3265,3267,3264,3261,3270,3271,3268,3269,3275,3272,3274,3273,3277,3278,3276,3279,3280,3282,3283,3284,3285,3287,3286,3252,3240,3288,3290,3289,3291,3281,3258,3292,3293,3294,3295)
            [start] => 1786246202.3353
            [end] => 1786246202.3499
            [time] => 0.014591932296753
        )

    [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 <= 1786246202 OR start >= 1786246202) AND (end >= 1786246202 OR end = 0) AND (start < 1786246202) ORDER BY name ASC
            [start] => 1786246202.3723
            [end] => 1786246202.3734
            [time] => 0.001147985458374
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1786246202.3736
            [end] => 1786246202.3738
            [time] => 0.00023508071899414
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1786246202.3739
            [end] => 1786246202.3742
            [time] => 0.00025200843811035
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (3243,3241,3242,3240,3247,3244,3245,3246,3248,3249,3250,3251,3253,3254,3255,3252,3256,3257,3259,3258,3262,3263,3260,3261,3266,3265,3267,3264,3270,3271,3268,3269,3275,3272,3274,3273,3277,3278,3276,3279,3280,3282,3283,3281,3284,3285,3287,3286,3288,3290,3289,3291,3292,3293,3294,3295) order by id ASC
            [start] => 1786246202.3778
            [end] => 1786246202.3814
            [time] => 0.0036380290985107
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1786246202.4915
            [end] => 1786246202.4919
            [time] => 0.00044989585876465
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1786246202.493
            [end] => 1786246202.4933
            [time] => 0.00030517578125
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1786246202.4934
            [end] => 1786246202.4937
            [time] => 0.00026893615722656
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1786246202.4937
            [end] => 1786246202.4939
            [time] => 0.00024986267089844
        )

    [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 <= 1693780767 OR start >= 1693780767) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (43,13,9,24,47,39,29,27) ORDER BY lastname,firstname ASC
            [start] => 1786246202.4941
            [end] => 1786246202.4955
            [time] => 0.0014660358428955
        )

    [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 = '21') 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] => 1786246202.496
            [end] => 1786246202.5146
            [time] => 0.018619060516357
        )

    [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 = '21')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1786246202.5148
            [end] => 1786246202.8549
            [time] => 0.34000301361084
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1786246202.8556
            [end] => 1786246202.856
            [time] => 0.00034594535827637
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1786246202.8561
            [end] => 1786246202.8564
            [time] => 0.0002748966217041
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1786246202.8564
            [end] => 1786246202.8566
            [time] => 0.00021696090698242
        )

    [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 <= 1693780767 OR start >= 1693780767) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (43,13,9,24,47,39,29,27) ORDER BY lastname,firstname ASC
            [start] => 1786246202.8567
            [end] => 1786246202.8579
            [time] => 0.0012140274047852
        )

    [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 = '21') 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] => 1786246202.8582
            [end] => 1786246202.8748
            [time] => 0.016613960266113
        )

    [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 = '21')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1786246202.8749
            [end] => 1786246203.1257
            [time] => 0.25077795982361
        )

    [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 <= 1693780767 OR start >= 1693780767) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) ORDER BY lastname,firstname ASC
            [start] => 1786246203.126
            [end] => 1786246203.1296
            [time] => 0.0036489963531494
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1786246203.1328
            [end] => 1786246203.1331
            [time] => 0.00026488304138184
        )

    [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 <= 1786246203 OR start >= 1786246203) AND (end >= 1786246203 OR end = 0) AND (start < 1786246203) ORDER BY name ASC
            [start] => 1786246203.1331
            [end] => 1786246203.1341
            [time] => 0.0010290145874023
        )

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

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

)