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

Campionati: Campionato Eccellenza 2023/2024 A1

  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
Giornata 15
Giornata 16
Giornata 17
Giornata 18
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.43268537521362
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034188.3151
            [end] => 1766034188.3155
            [time] => 0.00033903121948242
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1766034188.3176
            [end] => 1766034188.3178
            [time] => 0.00021791458129883
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1766034188.3179
            [end] => 1766034188.3182
            [time] => 0.0002601146697998
        )

    [3] => 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] => 1766034188.3183
            [end] => 1766034188.3211
            [time] => 0.0028040409088135
        )

    [4] => 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] => 1766034188.3217
            [end] => 1766034188.3246
            [time] => 0.002899169921875
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data 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)
            [start] => 1766034188.4602
            [end] => 1766034188.4735
            [time] => 0.013342142105103
        )

    [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 <= 1766034188 OR start >= 1766034188) AND (end >= 1766034188 OR end = 0) AND (start < 1766034188) ORDER BY name ASC
            [start] => 1766034188.5006
            [end] => 1766034188.5015
            [time] => 0.00096511840820312
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1766034188.5016
            [end] => 1766034188.5019
            [time] => 0.0002439022064209
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1766034188.502
            [end] => 1766034188.5022
            [time] => 0.00025606155395508
        )

    [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] => 1766034188.5023
            [end] => 1766034188.5052
            [time] => 0.0028278827667236
        )

    [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] => 1766034188.5058
            [end] => 1766034188.5087
            [time] => 0.0029230117797852
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1766034188.6442
            [end] => 1766034188.6446
            [time] => 0.00046086311340332
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1766034188.6461
            [end] => 1766034188.6463
            [time] => 0.00025391578674316
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1766034188.6464
            [end] => 1766034188.6467
            [time] => 0.0002439022064209
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1766034188.6467
            [end] => 1766034188.6469
            [time] => 0.00020003318786621
        )

    [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] => 1766034188.647
            [end] => 1766034188.6483
            [time] => 0.0012979507446289
        )

    [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] => 1766034188.6488
            [end] => 1766034188.6608
            [time] => 0.011986970901489
        )

    [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] => 1766034188.661
            [end] => 1766034188.8662
            [time] => 0.20514512062073
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '18'
            [start] => 1766034188.8672
            [end] => 1766034188.8676
            [time] => 0.00030803680419922
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1766034188.8676
            [end] => 1766034188.8679
            [time] => 0.00026106834411621
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '18'
            [start] => 1766034188.8679
            [end] => 1766034188.8681
            [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 <= 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] => 1766034188.8682
            [end] => 1766034188.8691
            [time] => 0.00092911720275879
        )

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

    [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] => 1766034189.048
            [end] => 1766034189.0514
            [time] => 0.003399133682251
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034189.0544
            [end] => 1766034189.0547
            [time] => 0.0002901554107666
        )

    [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 <= 1766034189 OR start >= 1766034189) AND (end >= 1766034189 OR end = 0) AND (start < 1766034189) ORDER BY name ASC
            [start] => 1766034189.0548
            [end] => 1766034189.0555
            [time] => 0.00072288513183594
        )

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

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

)