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

Campionati: Campionato Eccellenza 2023/2024 A1

  1. Home
  2. Campionati
  3. Campionati

Martedì 14-11-2023

Mercoledì 15-11-2023

Giovedì 16-11-2023

Domenica 19-11-2023

Martedì 21-11-2023

Giovedì 23-11-2023

Venerdì 24-11-2023

Domenica 26-11-2023

Lunedì 27-11-2023

Mercoledì 29-11-2023

Venerdì 01-12-2023

Martedì 05-12-2023

Mercoledì 06-12-2023

Mercoledì 13-12-2023

Giovedì 14-12-2023

Domenica 17-12-2023

Mercoledì 10-01-2024

Giovedì 11-01-2024

Venerdì 12-01-2024

Mercoledì 17-01-2024

Giovedì 18-01-2024

Lunedì 22-01-2024

Martedì 23-01-2024

Mercoledì 24-01-2024

Mercoledì 31-01-2024

Giovedì 01-02-2024

Domenica 04-02-2024

Lunedì 05-02-2024

Mercoledì 07-02-2024

Giovedì 08-02-2024

Venerdì 09-02-2024

Mercoledì 14-02-2024

Giovedì 15-02-2024

Venerdì 16-02-2024

Mercoledì 21-02-2024

Venerdì 23-02-2024

Martedì 27-02-2024

Mercoledì 28-02-2024

Venerdì 01-03-2024

Domenica 03-03-2024

Mercoledì 06-03-2024

Giovedì 07-03-2024

Venerdì 08-03-2024

Lunedì 11-03-2024

Mercoledì 13-03-2024

Giovedì 14-03-2024

Venerdì 15-03-2024

Mercoledì 20-03-2024

Venerdì 22-03-2024

Domenica 24-03-2024

Mercoledì 27-03-2024

Mercoledì 03-04-2024

Venerdì 05-04-2024

Domenica 07-04-2024

Mercoledì 10-04-2024

Giovedì 11-04-2024

Domenica 14-04-2024

Domenica 21-04-2024

Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
1 Piccolo Club 47 18 16 2 2245 1847 398
2 Sotomayor 37 18 12 6 2024 1743 281
3 Lab To Hit 36 18 12 6 2095 1952 143
4 Evolution 36 18 12 6 2202 1892 310
5 Red Devils 35 18 12 6 2119 1811 308
6 Sunknights 31 18 10 8 2177 2106 71
7 Pazzeschi 18 18 6 12 1874 2020 -146
8 Sporting Team 15 18 5 13 1705 2050 -345
9 Rdj 9 18 3 15 1893 2290 -397
10 Citmabun 6 18 2 16 1678 2301 -623
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 Federico Garrone
Sporting Team 		897 195 169 46% 0 17 0 0
2 Simone Selvaggio
Piccolo Club 		686 61 188 76% 0 18 0 0
3 Mirko Violetto
Sunknights 		682 122 146 54% 1 17 0 0
4 Alberto Dolfin
Rdj 		657 135 129 49% 1 18 0 0
5 Donald Basso
Piccolo Club 		547 83 127 60% 5 18 1 0
6 Luca Cardinali
Lab To Hit 		502 80 114 59% 1 17 0 0
7 Amedeo Biglino
Evolution 		493 146 67 31% 1 17 0 0
8 Daniele Agnello
Rdj 		489 111 89 45% 4 18 0 0
9 Federico Pistidda
Lab To Hit 		478 53 124 70% 3 17 0 0
10 Roberto Coletta
Sotomayor 		474 126 74 37% 1 17 0 0
11 Riccardo Marello
Piccolo Club 		439 122 65 35% 0 16 0 0
12 Andrea Belcastro
Red Devils 		427 143 47 25% 2 18 0 0
13 Andrea Rigoni
Rdj 		411 102 69 40% 0 18 0 0
14 Mattia Vazzoler
Red Devils 		396 108 60 36% 0 18 0 0
15 Luca Ambrosino
Pazzeschi 		387 114 53 32% 1 16 1 0
16 Mattia Rizzon
Lab To Hit 		377 61 85 58% 3 18 0 0
17 Leonardo Cicogna
Piccolo Club 		344 79 62 44% 3 18 0 0
18 Antonio Mirco Santarsia
Evolution 		340 113 38 25% 2 18 0 0
19 Riccardo Pajno Ferrara
Sporting Team 		339 120 33 22% 1 17 0 0
20 Michele Messina
Red Devils 		333 90 51 36% 0 15 1 0
21 Maurizio Rattalino
Sunknights 		324 84 52 38% 4 14 2 0
22 Federico D'Oria
Lab To Hit 		321 69 61 47% 0 18 0 0
23 Riccardo Simini
Red Devils 		321 102 39 28% 0 16 0 0
24 Davide Giordano
Evolution 		316 134 16 11% 3 18 0 0
25 Raffaele Maurelli
Evolution 		309 111 29 21% 1 18 1 0
26 Daniel Tiago Guzzafame
Sunknights 		307 62 61 50% 0 10 2 0
27 Simone Gabellini
Sotomayor 		307 134 13 9% 1 18 0 0
28 Antonio De Rosa
Pazzeschi 		306 90 42 32% 0 16 0 0
29 Marco Bernocco
Pazzeschi 		305 94 39 29% 0 18 0 0
30 Filippo Rovai
Sotomayor 		304 104 32 24% 1 16 0 0
31 Daniele Gennaro
Red Devils 		295 98 33 25% 1 18 0 0
32 Giuseppe Mirra
Pazzeschi 		292 86 40 32% 0 15 0 0
33 Marco De Salvo
Sotomayor 		275 82 37 31% 3 16 0 0
34 Gaspare Guarrato
Evolution 		275 91 31 25% 0 18 0 0
35 Giulio Naggi
Evolution 		271 107 19 15% 2 18 0 0
36 Stefano Benedetto
Sunknights 		258 72 38 35% 1 14 1 0
37 Luca Cangialosi
Pazzeschi 		249 99 17 15% 1 15 1 0
38 Matteo Cipolletta
Piccolo Club 		246 72 34 32% 1 17 0 0
39 Gabriel Alessandro Delgrosso
Red Devils 		245 76 31 29% 0 18 0 0
40 Daniele Botosso
Piccolo Club 		244 38 56 60% 0 13 0 0
41 Gabriele Spina
Citmabun 		237 72 31 30% 2 17 0 0
42 Alessio Casali
Sunknights 		209 61 29 32% 2 16 2 0
43 Gianluca Zanetti
Citmabun 		207 78 17 18% 1 18 0 0
44 Giacomo Garzaro
Sporting Team 		191 70 17 20% 2 17 0 0
45 Davide Brunello
Evolution 		190 68 18 21% 4 17 0 0
46 Stefano Calvo
Lab To Hit 		187 59 23 28% 0 18 0 0
47 Alessandro Maniscalco
Rdj 		187 77 11 13% 2 17 0 0
48 Alex Serratore
Sporting Team 		175 53 23 30% 2 18 0 0
49 Roberto Riccio
Piccolo Club 		169 68 11 14% 1 16 0 0
50 Enrico Demonte
Sotomayor 		155 73 3 4% 0 13 0 0
51 Fabrizio Gennaro
Rdj 		153 51 17 25% 3 16 1 0
52 Sergio Fileccia
Pazzeschi 		121 47 9 16% 2 15 0 0
53 Alessandro Rigardo
Lab To Hit 		120 42 12 22% 0 17 0 0
54 Gianluca L'Intrepido
Rdj 		117 48 7 13% 1 15 0 0
55 Marco Antonio De Nichilo
Sunknights 		109 32 15 32% 1 7 0 0
56 Filippo Venturini
Lab To Hit 		105 27 17 39% 3 16 0 0
57 Danilo Sacchetto
Pazzeschi 		99 42 5 11% 0 17 0 0
58 Andrea Suman
Red Devils 		97 32 11 26% 0 11 0 0
59 Franco Giambanco
Sporting Team 		95 43 3 7% 0 16 0 0
60 Enrico Spagnolini
Sunknights 		61 26 3 10% 0 15 0 0
61 Alessio Petrosino
Sotomayor 		55 23 3 12% 0 6 0 0
62 Alessandro Adami
Sunknights 		35 16 1 6% 1 8 1 0
63 Matteo Clara
Sunknights 		27 12 1 8% 0 10 0 0
64 Francesco Bruno
Sporting Team 		2 1 0 0 1 18 0 0
65 Gaetano Di Natale
Sporting Team 		0 0 0 0 0 0 0 0
66 Marco Fontana
Citmabun 		0 0 0 0 0 0 0 0
67 Alberto Maggia
Citmabun 		0 0 0 0 0 0 0 0
68 Davide Salvaggio
Red Devils 		0 0 0 0 0 0 0 0
69 Enrico Truffa
Citmabun 		0 0 0 0 0 0 0 0
70 Andrea Vecchiattini
Rdj 		0 0 0 0 0 0 0 0
71 Andrea Vitale
Citmabun 		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 Martina Lupo
Sotomayor 		34 14 2 13% 0 16 0 0
2 Julie Carpinelli
Sunknights 		0 0 0 0 0 0 0 0
3 Francesca Da Re
Citmabun 		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.53206992149353
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781154514.0854
            [end] => 1781154514.0856
            [time] => 0.0002589225769043
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1781154514.0879
            [end] => 1781154514.0881
            [time] => 0.00024509429931641
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1781154514.0882
            [end] => 1781154514.0885
            [time] => 0.00024509429931641
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '18' 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] => 1781154514.0886
            [end] => 1781154514.0916
            [time] => 0.0030200481414795
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2975,2976,2977,2978,2979,2981,2983,2982,2980,2984,2987,2989,2985,2986,2993,2991,2990,2994,2997,2999,2998,2995,2996,3002,3003,3000,3001,3004,3005,3006,3009,3007,3011,3012,3010,3014,3013,3017,3016,3015,3019,3018,3021,3022,3023,3024,3020,3025,3028,3026,3027,3029,3033,3031,3034,3032,3030,2970,2974,2972,2971,2992,3037,3036,3035,3038,3039,3040,3044,3043,3041,3042,3049,3048,3047,3046,3045,2973,3008,3052,3053,3050,3054,3051,3056,3055,3058,3059,3057,2988) order by id ASC
            [start] => 1781154514.0923
            [end] => 1781154514.0959
            [time] => 0.0035951137542725
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2975,2976,2977,2978,2979,2981,2983,2982,2980,2984,2987,2989,2985,2986,2993,2991,2990,2994,2997,2999,2998,2995,2996,3002,3003,3000,3001,3004,3005,3006,3009,3007,3011,3012,3010,3014,3013,3017,3016,3015,3019,3018,3021,3022,3023,3024,3020,3025,3028,3026,3027,3029,3033,3031,3034,3032,3030,2970,2974,2972,2971,2992,3037,3036,3035,3038,3039,3040,3044,3043,3041,3042,3049,3048,3047,3046,3045,2973,3008,3052,3053,3050,3054,3051,3056,3055,3058,3059,3057,2988)
            [start] => 1781154514.2732
            [end] => 1781154514.2881
            [time] => 0.014901876449585
        )

    [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 <= 1781154514 OR start >= 1781154514) AND (end >= 1781154514 OR end = 0) AND (start < 1781154514) ORDER BY name ASC
            [start] => 1781154514.3257
            [end] => 1781154514.327
            [time] => 0.0012650489807129
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1781154514.3271
            [end] => 1781154514.3273
            [time] => 0.00019311904907227
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1781154514.3273
            [end] => 1781154514.3276
            [time] => 0.00025415420532227
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2970,2974,2972,2971,2973,2975,2976,2977,2978,2979,2981,2983,2982,2980,2984,2987,2989,2985,2986,2988,2993,2991,2990,2994,2992,2997,2999,2998,2995,2996,3002,3003,3000,3001,3004,3005,3006,3009,3007,3008,3011,3012,3010,3014,3013,3017,3016,3015,3019,3018,3021,3022,3023,3024,3020,3025,3028,3026,3027,3029,3033,3031,3034,3032,3030,3037,3036,3035,3038,3039,3040,3044,3043,3041,3042,3048,3049,3047,3046,3045,3052,3053,3050,3054,3051,3056,3055,3058,3059,3057) order by id ASC
            [start] => 1781154514.3315
            [end] => 1781154514.3365
            [time] => 0.0049688816070557
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1781154514.515
            [end] => 1781154514.5154
            [time] => 0.00044894218444824
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1781154514.5169
            [end] => 1781154514.5171
            [time] => 0.00021600723266602
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1781154514.5172
            [end] => 1781154514.5174
            [time] => 0.00023317337036133
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1781154514.5174
            [end] => 1781154514.5176
            [time] => 0.00021100044250488
        )

    [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 <= 1693760374 OR start >= 1693760374) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (2,16,17,18,19,20,21,1,35,22) ORDER BY lastname,firstname ASC
            [start] => 1781154514.5178
            [end] => 1781154514.5192
            [time] => 0.001413106918335
        )

    [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 = '18') 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] => 1781154514.5196
            [end] => 1781154514.5348
            [time] => 0.01525092124939
        )

    [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 = '18')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1781154514.5351
            [end] => 1781154514.7867
            [time] => 0.2515881061554
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1781154514.7877
            [end] => 1781154514.7881
            [time] => 0.0003359317779541
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1781154514.7882
            [end] => 1781154514.7884
            [time] => 0.00026416778564453
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1781154514.7885
            [end] => 1781154514.7887
            [time] => 0.00024199485778809
        )

    [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 <= 1693760374 OR start >= 1693760374) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (2,16,17,18,19,20,21,1,35,22) ORDER BY lastname,firstname ASC
            [start] => 1781154514.7888
            [end] => 1781154514.7898
            [time] => 0.0010480880737305
        )

    [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 = '18') 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] => 1781154514.79
            [end] => 1781154514.805
            [time] => 0.015034914016724
        )

    [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 = '18')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1781154514.8051
            [end] => 1781154515.0122
            [time] => 0.20715808868408
        )

    [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 <= 1693760374 OR start >= 1693760374) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) ORDER BY lastname,firstname ASC
            [start] => 1781154515.0124
            [end] => 1781154515.0161
            [time] => 0.0036330223083496
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781154515.0193
            [end] => 1781154515.0196
            [time] => 0.00027608871459961
        )

    [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 <= 1781154515 OR start >= 1781154515) AND (end >= 1781154515 OR end = 0) AND (start < 1781154515) ORDER BY name ASC
            [start] => 1781154515.0196
            [end] => 1781154515.0206
            [time] => 0.0010168552398682
        )

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

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

)