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 Monstars 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 Homeless 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
Monstars 		0 0 0 0 0 0 0 0
40 Andrea Brocchetta
Monstars 		0 0 0 0 0 0 0 0
41 Alessandro Castello
Monstars 		0 0 0 0 0 0 0 0
42 Daniele Cecconata
Monstars 		0 0 0 0 0 0 0 0
43 Daniele Cena
Monstars 		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
Monstars 		0 0 0 0 0 0 0 0
48 Marco Lorandi
Meatballs 		0 0 0 0 0 0 0 0
49 Pierluigi Marchisio
Homeless 		0 0 0 0 0 0 0 0
50 Andrea Merlo
Homeless 		0 0 0 0 0 0 0 0
51 Justin Ossai
Hitbusters 		0 0 0 0 0 0 0 0
52 Gaetano Rendine
Homeless 		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
Monstars 		0 0 0 0 0 0 0 0
8 Chiara Gilardi
Monstars 		0 0 0 0 0 0 0 0
9 Sara Marino
Homeless 		0 0 0 0 0 0 0 0
10 Elena Pasino
Homeless 		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.42937445640564
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034219.3933
            [end] => 1766034219.3936
            [time] => 0.00033903121948242
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1766034219.3957
            [end] => 1766034219.3959
            [time] => 0.0001978874206543
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1766034219.396
            [end] => 1766034219.3963
            [time] => 0.00028800964355469
        )

    [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] => 1766034219.3964
            [end] => 1766034219.3991
            [time] => 0.0026640892028809
        )

    [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] => 1766034219.3995
            [end] => 1766034219.4022
            [time] => 0.0027549266815186
        )

    [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] => 1766034219.486
            [end] => 1766034219.4986
            [time] => 0.012535810470581
        )

    [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 <= 1766034219 OR start >= 1766034219) AND (end >= 1766034219 OR end = 0) AND (start < 1766034219) ORDER BY name ASC
            [start] => 1766034219.5151
            [end] => 1766034219.5161
            [time] => 0.00092911720275879
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1766034219.5161
            [end] => 1766034219.5164
            [time] => 0.00022482872009277
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1766034219.5165
            [end] => 1766034219.5167
            [time] => 0.00025296211242676
        )

    [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] => 1766034219.5168
            [end] => 1766034219.5195
            [time] => 0.0026979446411133
        )

    [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] => 1766034219.5199
            [end] => 1766034219.5227
            [time] => 0.0028219223022461
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1766034219.6064
            [end] => 1766034219.6069
            [time] => 0.0004570484161377
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1766034219.6079
            [end] => 1766034219.6081
            [time] => 0.00026082992553711
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1766034219.6082
            [end] => 1766034219.6085
            [time] => 0.0002439022064209
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1766034219.6085
            [end] => 1766034219.6087
            [time] => 0.00022602081298828
        )

    [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] => 1766034219.6088
            [end] => 1766034219.6101
            [time] => 0.0012500286102295
        )

    [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] => 1766034219.6105
            [end] => 1766034219.6227
            [time] => 0.012195110321045
        )

    [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] => 1766034219.6228
            [end] => 1766034219.82
            [time] => 0.19712710380554
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '21'
            [start] => 1766034219.8208
            [end] => 1766034219.8211
            [time] => 0.00033187866210938
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1766034219.8212
            [end] => 1766034219.8215
            [time] => 0.0003209114074707
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '21'
            [start] => 1766034219.8215
            [end] => 1766034219.8218
            [time] => 0.0002281665802002
        )

    [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] => 1766034219.8219
            [end] => 1766034219.8228
            [time] => 0.00096988677978516
        )

    [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] => 1766034219.823
            [end] => 1766034219.835
            [time] => 0.011965036392212
        )

    [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] => 1766034219.835
            [end] => 1766034220.0067
            [time] => 0.17162418365479
        )

    [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] => 1766034220.007
            [end] => 1766034220.0107
            [time] => 0.0037870407104492
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034220.0142
            [end] => 1766034220.0145
            [time] => 0.00029301643371582
        )

    [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 <= 1766034220 OR start >= 1766034220) AND (end >= 1766034220 OR end = 0) AND (start < 1766034220) ORDER BY name ASC
            [start] => 1766034220.0145
            [end] => 1766034220.0154
            [time] => 0.00081586837768555
        )

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

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

)