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

Campionati: Campionato Eccellenza 2023/2024 B2

  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
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: 2.6189746856689
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776056348.2455
            [end] => 1776056348.2457
            [time] => 0.000244140625
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1776056348.2521
            [end] => 1776056348.2539
            [time] => 0.0018348693847656
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1776056348.254
            [end] => 1776056348.2543
            [time] => 0.00026488304138184
        )

    [3] => 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] => 1776056348.2545
            [end] => 1776056348.2587
            [time] => 0.0042479038238525
        )

    [4] => 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] => 1776056348.2591
            [end] => 1776056348.2659
            [time] => 0.0068089962005615
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data 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)
            [start] => 1776056348.5698
            [end] => 1776056348.5875
            [time] => 0.017642021179199
        )

    [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 <= 1776056348 OR start >= 1776056348) AND (end >= 1776056348 OR end = 0) AND (start < 1776056348) ORDER BY name ASC
            [start] => 1776056348.6685
            [end] => 1776056348.6716
            [time] => 0.0031609535217285
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1776056348.6718
            [end] => 1776056348.6747
            [time] => 0.0029618740081787
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1776056348.6748
            [end] => 1776056348.6777
            [time] => 0.002892017364502
        )

    [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] => 1776056348.6779
            [end] => 1776056348.688
            [time] => 0.010061025619507
        )

    [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] => 1776056348.6884
            [end] => 1776056348.695
            [time] => 0.0066399574279785
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1776056349.4159
            [end] => 1776056349.425
            [time] => 0.0091309547424316
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1776056349.43
            [end] => 1776056349.4418
            [time] => 0.01176118850708
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1776056349.4419
            [end] => 1776056349.4423
            [time] => 0.00034093856811523
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1776056349.4423
            [end] => 1776056349.4425
            [time] => 0.00021696090698242
        )

    [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] => 1776056349.4427
            [end] => 1776056349.4509
            [time] => 0.0082299709320068
        )

    [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] => 1776056349.4514
            [end] => 1776056349.4978
            [time] => 0.046463966369629
        )

    [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] => 1776056349.498
            [end] => 1776056350.695
            [time] => 1.1970129013062
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1776056350.6959
            [end] => 1776056350.6969
            [time] => 0.0010199546813965
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1776056350.697
            [end] => 1776056350.6973
            [time] => 0.00026297569274902
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1776056350.6973
            [end] => 1776056350.6975
            [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 <= 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] => 1776056350.6976
            [end] => 1776056350.6997
            [time] => 0.0021190643310547
        )

    [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] => 1776056350.6999
            [end] => 1776056350.7602
            [time] => 0.060259103775024
        )

    [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] => 1776056350.7603
            [end] => 1776056351.9601
            [time] => 1.1997561454773
        )

    [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] => 1776056351.9604
            [end] => 1776056351.9739
            [time] => 0.013499021530151
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1776056351.9805
            [end] => 1776056351.9808
            [time] => 0.00030303001403809
        )

    [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 <= 1776056351 OR start >= 1776056351) AND (end >= 1776056351 OR end = 0) AND (start < 1776056351) ORDER BY name ASC
            [start] => 1776056351.9809
            [end] => 1776056351.9834
            [time] => 0.0025780200958252
        )

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

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

)