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

Campionati: Campionato Eccellenza 2022/2023 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 Black Knights 39 14 13 1 1338 880 458
2 Iron Lion Tyson 33 14 11 3 1066 832 234
3 Trefferspan 30 14 10 4 1174 909 265
4 Meatballs 23 14 8 6 818 819 -1
5 Monstars 20 14 7 7 1081 1032 49
6 Homeless 13 14 4 10 1052 1145 -93
7 Jedi Knights 9 14 3 11 818 1071 -253
8 Legio X 0 14 0 14 574 1233 -659
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 Daniele Carbone
Black Knights 		420 150 40 21% 1 13 0 0
2 Jacopo Marchitelli
Trefferspan 		372 171 10 6% 1 14 0 0
3 Giulio Cocirio
Trefferspan 		322 149 8 5% 1 14 0 0
4 Alessio Argano
Monstars 		312 135 14 9% 2 14 0 0
5 Luigi Ghirardi
Homeless 		300 117 22 16% 0 14 0 0
6 Davide Martini
Monstars 		282 93 32 26% 1 13 0 0
7 Patrick Marzano
Black Knights 		268 86 32 27% 0 14 1 0
8 Paul Mihei
Iron Lion Tyson 		268 104 20 16% 3 13 1 0
9 Emiliano Travaglini
Iron Lion Tyson 		265 101 21 17% 0 12 1 0
10 Paolo Guerra
Meatballs 		256 95 22 19% 1 13 0 0
11 Samuel Romanazzi
Homeless 		226 83 20 19% 2 14 1 0
12 Giovanni Aquila
Jedi Knights 		224 52 40 43% 0 14 0 0
13 Paolo Gazzola
Black Knights 		181 74 11 13% 3 13 0 0
14 Mauro Mola
Meatballs 		179 58 21 27% 0 13 0 0
15 Fabio Bragagnolo
Black Knights 		179 64 17 21% 0 14 2 0
16 Francesco Croci
Trefferspan 		176 64 16 20% 2 13 1 0
17 Andrea Lovera
Jedi Knights 		148 56 12 18% 0 7 0 0
18 Federico Listello
Meatballs 		136 50 12 19% 0 10 0 0
19 Paolo Capomolla
Monstars 		131 55 7 11% 3 13 0 0
20 Francesco Luigi Scarfò
Jedi Knights 		127 47 11 19% 2 8 0 0
21 Mattia Allemano
Homeless 		125 40 15 27% 0 13 2 0
22 Mattia Valetti
Black Knights 		113 46 7 13% 1 14 1 0
23 Francesco Rigoni
Iron Lion Tyson 		113 49 5 9% 0 11 0 0
24 Pier Paolo Specchiulli
Legio X 		111 45 7 13% 1 14 0 0
25 Cherif Balde
Iron Lion Tyson 		110 49 4 8% 0 10 0 0
26 Adriano Paribello Grasso
Monstars 		109 53 1 2% 0 14 0 0
27 Davide Rivetti
Trefferspan 		107 43 7 14% 3 11 0 0
28 Gabriele Bonaldo
Meatballs 		106 44 6 12% 0 12 3 0
29 Claudio Bonocore
Homeless 		100 29 14 33% 1 12 0 0
30 Simone Basano
Legio X 		100 35 10 22% 0 12 0 0
31 Justin Ossai
Legio X 		99 39 7 15% 0 13 0 0
32 Simone Garino
Iron Lion Tyson 		97 41 5 11% 0 11 0 0
33 Francesco Ghio
Monstars 		89 43 1 2% 1 14 0 0
34 Emanuele Filiberto Pellegrin
Monstars 		88 44 0 0 0 10 0 0
35 Mattia Gizzi
Homeless 		82 32 6 16% 0 10 1 0
36 Gabriele Di Stefano
Trefferspan 		74 34 2 6% 1 10 0 0
37 Leonardo Specchiulli
Legio X 		72 24 8 25% 1 13 0 0
38 Gaetano De Vaire
Black Knights 		69 24 7 23% 0 13 1 0
39 Roberto Amin Abdou Awad
Iron Lion Tyson 		69 30 3 9% 2 13 0 0
40 Valerio Brocci
Black Knights 		64 23 6 21% 3 11 2 0
41 Emanuele Nigro
Trefferspan 		62 28 2 7% 0 13 0 0
42 Emanuele Preti
Monstars 		61 29 1 3% 1 11 0 0
43 Leonardo Morrone
Homeless 		60 21 6 22% 2 12 1 0
44 Alberico Franzin
Iron Lion Tyson 		60 27 2 7% 3 11 1 0
45 Alessio Noto
Legio X 		54 24 2 8% 1 12 1 0
46 Roberto Perrini
Jedi Knights 		53 22 3 12% 1 10 0 0
47 Samuele Carnelli
Legio X 		43 17 3 15% 0 11 0 0
48 Simone Casale
Jedi Knights 		40 14 4 22% 0 7 0 0
49 Edoardo Di Noia
Trefferspan 		39 18 1 5% 2 11 1 0
50 Stefano Zorzan
Homeless 		37 8 7 47% 0 9 0 0
51 Marco Gramigna
Jedi Knights 		36 15 2 12% 0 8 0 0
52 Alberto Amoruso
Trefferspan 		32 13 2 13% 2 4 0 0
53 Lorenzo Marchitelli
Legio X 		25 11 1 8% 3 14 0 0
54 Jairo Mattia Agaliati Fadda
Trefferspan 		24 12 0 0 1 8 0 0
55 Giacomo Pezzuto
Homeless 		20 4 4 50% 1 8 5 0
56 Andrea Rossotto
Legio X 		12 6 0 0 1 7 1 0
57 Marco Antonucci
Legio X 		8 4 0 0 0 4 0 0
58 Valerio Ianniello
Legio X 		6 3 0 0 0 4 0 0
59 Mario Franchi
Iron Lion Tyson 		0 0 0 0 0 3 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 Roberta Binello
Jedi Knights 		147 48 17 26% 1 12 0 0
2 Arianna Vismara
Meatballs 		110 40 10 20% 1 12 0 0
3 Lisa Portarulo
Homeless 		98 43 4 9% 3 14 1 0
4 Mara Ferraris
Black Knights 		34 14 2 13% 0 12 1 0
5 Elisa Genovese
Jedi Knights 		19 8 1 11% 0 13 0 0
6 SIlvia Petiti
Iron Lion Tyson 		19 8 1 11% 1 13 0 0
7 Sara Sottolano
Meatballs 		17 7 1 13% 0 7 0 0
8 Laura Mongi
Jedi Knights 		12 6 0 0 1 11 0 0
9 Rossella De Blasio
Meatballs 		3 0 1 0 0 9 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.46719622612
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770965347.0846
            [end] => 1770965347.085
            [time] => 0.00036311149597168
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1770965347.0873
            [end] => 1770965347.0875
            [time] => 0.0002591609954834
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1770965347.0876
            [end] => 1770965347.0879
            [time] => 0.00029301643371582
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '12' ORDER BY 
        case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end, 
        round_id+0,
        date+0,
        match_id 
        ASC
            [start] => 1770965347.088
            [end] => 1770965347.0909
            [time] => 0.0028371810913086
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2620,2618,2621,2619,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2645,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673) order by id ASC
            [start] => 1770965347.0913
            [end] => 1770965347.0942
            [time] => 0.0029671192169189
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2620,2618,2621,2619,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2645,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673)
            [start] => 1770965347.1883
            [end] => 1770965347.2016
            [time] => 0.013319969177246
        )

    [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 <= 1770965347 OR start >= 1770965347) AND (end >= 1770965347 OR end = 0) AND (start < 1770965347) ORDER BY name ASC
            [start] => 1770965347.2169
            [end] => 1770965347.2179
            [time] => 0.0010011196136475
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1770965347.2179
            [end] => 1770965347.2181
            [time] => 0.00020813941955566
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1770965347.2182
            [end] => 1770965347.2185
            [time] => 0.00024604797363281
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2620,2618,2621,2619,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2645,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673) order by id ASC
            [start] => 1770965347.2217
            [end] => 1770965347.2246
            [time] => 0.0029420852661133
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1770965347.3182
            [end] => 1770965347.3186
            [time] => 0.00045084953308105
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1770965347.3195
            [end] => 1770965347.3197
            [time] => 0.0002439022064209
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1770965347.3198
            [end] => 1770965347.3201
            [time] => 0.0002439022064209
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1770965347.3201
            [end] => 1770965347.3203
            [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 <= 1663340180 OR start >= 1663340180) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (23,43,25,9,40,24,26,27) ORDER BY lastname,firstname ASC
            [start] => 1770965347.3204
            [end] => 1770965347.3217
            [time] => 0.0013508796691895
        )

    [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 = '12') 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] => 1770965347.3221
            [end] => 1770965347.3354
            [time] => 0.013219833374023
        )

    [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 = '12')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1770965347.3356
            [end] => 1770965347.5527
            [time] => 0.21710991859436
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '12'
            [start] => 1770965347.5536
            [end] => 1770965347.554
            [time] => 0.00034499168395996
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1770965347.5541
            [end] => 1770965347.5544
            [time] => 0.0002748966217041
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '12'
            [start] => 1770965347.5544
            [end] => 1770965347.5546
            [time] => 0.00021600723266602
        )

    [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 <= 1663340180 OR start >= 1663340180) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (23,43,25,9,40,24,26,27) ORDER BY lastname,firstname ASC
            [start] => 1770965347.5547
            [end] => 1770965347.5557
            [time] => 0.00098919868469238
        )

    [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 = '12') 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] => 1770965347.5558
            [end] => 1770965347.5692
            [time] => 0.013351917266846
        )

    [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 = '12')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1770965347.5693
            [end] => 1770965347.755
            [time] => 0.18567299842834
        )

    [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 <= 1663340180 OR start >= 1663340180) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) ORDER BY lastname,firstname ASC
            [start] => 1770965347.7553
            [end] => 1770965347.759
            [time] => 0.003781795501709
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1770965347.7623
            [end] => 1770965347.7626
            [time] => 0.00029206275939941
        )

    [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 <= 1770965347 OR start >= 1770965347) AND (end >= 1770965347 OR end = 0) AND (start < 1770965347) ORDER BY name ASC
            [start] => 1770965347.7626
            [end] => 1770965347.7634
            [time] => 0.00081706047058105
        )

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

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

)