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

Campionati: Campionato Eccellenza 2024/2025 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 42 18 14 4 1951 1713 238
2 Lab To Hit 39 18 13 5 2057 1781 276
3 Evolution 39 18 13 5 2066 1816 250
4 Red Devils 39 18 13 5 1922 1656 266
5 Sunknights 30 18 10 8 1817 1840 -23
6 Sotomayor 29 18 10 8 1904 1835 69
7 Genova Hit Ball 18 18 6 12 1611 1706 -95
8 Pazzeschi 15 18 5 13 1616 1915 -299
9 Sporting Team 13 18 4 14 1805 2007 -202
10 Rdj 6 18 2 16 1631 2111 -480
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
Red Devils 		969 192 195 50% 1 18 0 0
2 Simone Selvaggio
Piccolo Club 		647 34 193 85% 1 18 0 0
3 Luca Fagherazzi
Genova Hit Ball 		603 171 87 34% 2 18 0 0
4 Luca Cardinali
Lab To Hit 		520 116 96 45% 1 18 0 0
5 Mirko Violetto
Sunknights 		514 128 86 40% 0 18 0 0
6 Federico Pistidda
Lab To Hit 		477 78 107 58% 3 18 0 0
7 Amedeo Biglino
Evolution 		475 125 75 38% 1 17 0 0
8 Daniele Agnello
Rdj 		455 88 93 51% 1 18 0 0
9 Marco De Salvo
Sotomayor 		423 123 59 32% 2 17 0 0
10 Roberto Coletta
Sotomayor 		422 133 52 28% 0 16 0 0
11 Donald Basso
Piccolo Club 		420 126 56 31% 2 17 1 0
12 Mattia Rizzon
Lab To Hit 		406 77 84 52% 0 17 0 0
13 Andrea Belcastro
Red Devils 		402 132 46 26% 0 18 0 0
14 Alberto Dolfin
Rdj 		400 65 90 58% 1 17 0 0
15 Filippo Rovai
Sotomayor 		392 127 46 27% 2 17 0 0
16 Daniel Tiago Guzzafame
Sunknights 		384 75 78 51% 1 13 0 0
17 Riccardo Simini
Red Devils 		364 122 40 25% 2 18 0 0
18 Giuseppe Mirra
Pazzeschi 		355 95 55 37% 2 18 0 0
19 Mattia Vazzoler
Red Devils 		339 93 51 35% 0 18 0 0
20 Andrea Rigoni
Pazzeschi 		335 43 83 66% 1 16 0 0
21 Giulio Naggi
Evolution 		327 99 43 30% 0 18 0 0
22 Michele Messina
Red Devils 		322 89 48 35% 0 15 0 0
23 Davide Giordano
Evolution 		317 103 37 26% 3 18 0 0
24 Luca Siciliano
Genova Hit Ball 		299 118 21 15% 1 17 2 0
25 Dario Ravera
Genova Hit Ball 		298 110 26 19% 4 17 0 0
26 Luca Cangialosi
Pazzeschi 		293 94 35 27% 2 16 0 0
27 Antonio Mirco Santarsia
Evolution 		285 90 35 28% 1 18 2 0
28 Daniele Botosso
Piccolo Club 		275 58 53 48% 2 17 0 0
29 Riccardo Pajno Ferrara
Sporting Team 		250 92 22 19% 1 16 0 0
30 Federico D'Oria
Lab To Hit 		243 60 41 41% 0 18 0 0
31 Gaetano Di Natale
Sporting Team 		238 71 32 31% 1 16 1 0
32 Luca Ambrosino
Pazzeschi 		235 62 37 37% 2 14 0 0
33 Alessio Casali
Sunknights 		233 61 37 38% 3 16 0 0
34 Gaspare Guarrato
Evolution 		231 96 13 12% 1 17 0 0
35 Davide Brunello
Evolution 		218 73 24 25% 1 18 0 0
36 Simone Gabellini
Sotomayor 		211 86 13 13% 0 15 0 0
37 Raffaele Maurelli
Evolution 		197 70 19 21% 2 18 1 0
38 Maurizio Rattalino
Sunknights 		192 54 28 34% 2 13 0 0
39 Stefano Calvo
Lab To Hit 		189 51 29 36% 0 17 0 0
40 Daniele Gennaro
Red Devils 		189 54 27 33% 0 14 2 0
41 Enrico Demonte
Sotomayor 		188 88 4 4% 4 18 0 0
42 Riccardo Marello
Piccolo Club 		185 55 25 31% 0 14 0 0
43 Leonardo Farina
Genova Hit Ball 		182 76 10 12% 0 17 1 0
44 Matteo Cipolletta
Piccolo Club 		173 52 23 31% 2 17 0 0
45 Stefano Benedetto
Sunknights 		169 47 25 35% 1 14 0 0
46 Gabriel Alessandro Delgrosso
Red Devils 		159 42 25 37% 3 16 1 0
47 Andrea Vecchiattini
Rdj 		154 59 12 17% 1 17 0 0
48 Roberto Riccio
Piccolo Club 		148 59 10 14% 1 16 0 0
49 Davide Salvaggio
Red Devils 		141 45 17 27% 5 18 0 0
50 Alex Serratore
Sporting Team 		137 37 21 36% 2 16 0 0
51 Alessandro Maniscalco
Rdj 		128 49 10 17% 0 17 0 0
52 Giacomo Garzaro
Sporting Team 		124 56 4 7% 4 13 0 0
53 Filippo Venturini
Lab To Hit 		122 31 20 39% 4 17 0 0
54 Davide Ciancio
Genova Hit Ball 		122 49 8 14% 3 18 0 0
55 Antonio De Rosa
Pazzeschi 		118 38 14 27% 0 9 0 0
56 Danilo Sacchetto
Pazzeschi 		101 37 9 20% 1 18 0 0
57 Alessandro Rigardo
Lab To Hit 		91 41 3 7% 1 15 0 0
58 Leonardo Cicogna
Piccolo Club 		90 15 20 57% 0 9 1 0
59 Fabrizio Gennaro
Rdj 		82 32 6 16% 2 14 0 0
60 Giorgio Recalcati
Genova Hit Ball 		78 36 2 5% 1 15 0 0
61 Gianluca L'Intrepido
Rdj 		68 22 8 27% 0 10 0 0
62 Franco Giambanco
Sporting Team 		62 25 4 14% 2 15 0 0
63 Enrico Spagnolini
Sunknights 		55 26 1 4% 1 15 0 0
64 Alessandro Adami
Sunknights 		49 17 5 23% 0 11 0 0
65 Marco Virgilio
Sunknights 		40 14 4 22% 1 3 0 0
66 Alessio Petrosino
Sotomayor 		33 15 1 6% 0 4 0 0
67 Matteo Clara
Sunknights 		27 12 1 8% 0 8 0 0
68 Leonardo Chiarella
Genova Hit Ball 		19 8 1 11% 1 18 0 0
69 Francesco Bruno
Sporting Team 		18 6 2 25% 1 17 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 		40 20 0 0 1 18 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.43443489074707
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034120.2247
            [end] => 1766034120.225
            [time] => 0.00030088424682617
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1766034120.2273
            [end] => 1766034120.2275
            [time] => 0.00022482872009277
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1766034120.2276
            [end] => 1766034120.2279
            [time] => 0.00027608871459961
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (3421,3425,3424,3423,3422,3427,3428,3429,3426,3430,3431,3434,3433,3432,3435,3439,3440,3436,3437,3438,3444,3442,3445,3443,3441,3448,3446,3447,3450,3449,3455,3452,3454,3451,3453,3457,3460,3458,3456,3459,3462,3465,3464,3463,3461,3467,3466,3468,3470,3469,3471,3473,3474,3475,3472,3478,3477,3476,3479,3480,3483,3481,3485,3484,3482,3487,3486,3490,3489,3488,3493,3492,3491,3494,3495,3497,3499,3498,3500,3496,3501,3503,3504,3505,3502,3508,3507,3510,3509,3506) order by id ASC
            [start] => 1766034120.2315
            [end] => 1766034120.2344
            [time] => 0.0029518604278564
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3421,3425,3424,3423,3422,3427,3428,3429,3426,3430,3431,3434,3433,3432,3435,3439,3440,3436,3437,3438,3444,3442,3445,3443,3441,3448,3446,3447,3450,3449,3455,3452,3454,3451,3453,3457,3460,3458,3456,3459,3462,3465,3464,3463,3461,3467,3466,3468,3470,3469,3471,3473,3474,3475,3472,3478,3477,3476,3479,3480,3483,3481,3485,3484,3482,3487,3486,3490,3489,3488,3493,3492,3491,3494,3495,3497,3499,3498,3500,3496,3501,3503,3504,3505,3502,3508,3507,3510,3509,3506)
            [start] => 1766034120.3696
            [end] => 1766034120.3844
            [time] => 0.014756917953491
        )

    [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 <= 1766034120 OR start >= 1766034120) AND (end >= 1766034120 OR end = 0) AND (start < 1766034120) ORDER BY name ASC
            [start] => 1766034120.4128
            [end] => 1766034120.4139
            [time] => 0.0010528564453125
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1766034120.414
            [end] => 1766034120.4142
            [time] => 0.00021696090698242
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1766034120.4143
            [end] => 1766034120.4145
            [time] => 0.00023794174194336
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (3421,3425,3424,3423,3422,3427,3428,3429,3426,3430,3431,3434,3433,3432,3435,3439,3440,3436,3437,3438,3444,3442,3445,3443,3441,3448,3446,3447,3450,3449,3455,3452,3454,3451,3453,3457,3460,3458,3456,3459,3462,3465,3464,3463,3461,3467,3466,3468,3470,3469,3471,3473,3474,3475,3472,3478,3477,3476,3479,3480,3483,3481,3485,3484,3482,3487,3486,3490,3489,3488,3493,3492,3491,3494,3495,3497,3499,3498,3500,3496,3501,3503,3504,3505,3502,3508,3507,3510,3509,3506) order by id ASC
            [start] => 1766034120.4182
            [end] => 1766034120.4212
            [time] => 0.0030510425567627
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1766034120.5579
            [end] => 1766034120.5584
            [time] => 0.00043916702270508
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1766034120.5599
            [end] => 1766034120.5602
            [time] => 0.00029611587524414
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1766034120.5603
            [end] => 1766034120.5606
            [time] => 0.00025796890258789
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1766034120.5606
            [end] => 1766034120.5608
            [time] => 0.00023603439331055
        )

    [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 <= 1724582460 OR start >= 1724582460) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) AND team_id in (16,38,17,18,19,20,21,1,35,22) ORDER BY lastname,firstname ASC
            [start] => 1766034120.5609
            [end] => 1766034120.5623
            [time] => 0.0013601779937744
        )

    [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 = '25') 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] => 1766034120.5628
            [end] => 1766034120.5748
            [time] => 0.011987924575806
        )

    [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 = '25')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034120.575
            [end] => 1766034120.7809
            [time] => 0.20586800575256
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1766034120.7821
            [end] => 1766034120.7824
            [time] => 0.00031685829162598
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1766034120.7825
            [end] => 1766034120.7827
            [time] => 0.00026392936706543
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1766034120.7827
            [end] => 1766034120.783
            [time] => 0.00021505355834961
        )

    [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 <= 1724582460 OR start >= 1724582460) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) AND team_id in (16,38,17,18,19,20,21,1,35,22) ORDER BY lastname,firstname ASC
            [start] => 1766034120.783
            [end] => 1766034120.784
            [time] => 0.00092101097106934
        )

    [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 = '25') 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] => 1766034120.7841
            [end] => 1766034120.796
            [time] => 0.011906147003174
        )

    [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 = '25')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034120.7961
            [end] => 1766034120.9617
            [time] => 0.1656379699707
        )

    [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 <= 1724582460 OR start >= 1724582460) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) ORDER BY lastname,firstname ASC
            [start] => 1766034120.9619
            [end] => 1766034120.9654
            [time] => 0.0035090446472168
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034120.9685
            [end] => 1766034120.9688
            [time] => 0.00027108192443848
        )

    [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 <= 1766034120 OR start >= 1766034120) AND (end >= 1766034120 OR end = 0) AND (start < 1766034120) ORDER BY name ASC
            [start] => 1766034120.9688
            [end] => 1766034120.9696
            [time] => 0.00077915191650391
        )

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

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

)