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

Campionati: Campionato Eccellenza 2024/2025 A1

  1. Home
  2. Campionati
  3. Campionati

Mercoledì 16-10-2024

Martedì 22-10-2024

Mercoledì 23-10-2024

Domenica 27-10-2024

Martedì 29-10-2024

Mercoledì 30-10-2024

Mercoledì 06-11-2024

Domenica 10-11-2024

Mercoledì 13-11-2024

Venerdì 15-11-2024

Domenica 17-11-2024

Martedì 19-11-2024

Mercoledì 20-11-2024

Domenica 24-11-2024

Lunedì 25-11-2024

Mercoledì 27-11-2024

Giovedì 28-11-2024

Venerdì 29-11-2024

Domenica 01-12-2024

Martedì 03-12-2024

Venerdì 06-12-2024

Mercoledì 11-12-2024

Venerdì 13-12-2024

Domenica 15-12-2024

Mercoledì 18-12-2024

Giovedì 19-12-2024

Giovedì 09-01-2025

Domenica 12-01-2025

Martedì 14-01-2025

Mercoledì 15-01-2025

Venerdì 17-01-2025

Domenica 19-01-2025

Mercoledì 22-01-2025

Domenica 26-01-2025

Mercoledì 29-01-2025

Sabato 01-02-2025

Domenica 02-02-2025

Mercoledì 05-02-2025

Giovedì 06-02-2025

Domenica 09-02-2025

Mercoledì 12-02-2025

Giovedì 13-02-2025

Domenica 16-02-2025

Martedì 18-02-2025

Venerdì 21-02-2025

Mercoledì 26-02-2025

Giovedì 27-02-2025

Mercoledì 05-03-2025

Giovedì 06-03-2025

Domenica 09-03-2025

Martedì 11-03-2025

Giovedì 13-03-2025

Domenica 16-03-2025

Mercoledì 19-03-2025

Giovedì 20-03-2025

Domenica 23-03-2025

Mercoledì 26-03-2025

Giovedì 27-03-2025

Venerdì 28-03-2025

Domenica 30-03-2025

Mercoledì 02-04-2025

Giovedì 03-04-2025

Domenica 06-04-2025

Martedì 08-04-2025

Venerdì 11-04-2025

Domenica 13-04-2025

Mercoledì 16-04-2025

Giovedì 17-04-2025

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.58941698074341
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781150417.7977
            [end] => 1781150417.798
            [time] => 0.00031208992004395
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1781150417.8005
            [end] => 1781150417.8008
            [time] => 0.00027704238891602
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1781150417.8009
            [end] => 1781150417.8012
            [time] => 0.00027203559875488
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '25' 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] => 1781150417.8013
            [end] => 1781150417.8059
            [time] => 0.0045809745788574
        )

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

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

    [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 <= 1781150418 OR start >= 1781150418) AND (end >= 1781150418 OR end = 0) AND (start < 1781150418) ORDER BY name ASC
            [start] => 1781150418.0413
            [end] => 1781150418.0425
            [time] => 0.0012350082397461
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1781150418.0426
            [end] => 1781150418.0428
            [time] => 0.00022411346435547
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1781150418.0429
            [end] => 1781150418.0432
            [time] => 0.00024890899658203
        )

    [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] => 1781150418.0433
            [end] => 1781150418.0465
            [time] => 0.0031518936157227
        )

    [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] => 1781150418.0471
            [end] => 1781150418.0509
            [time] => 0.0037682056427002
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1781150418.2375
            [end] => 1781150418.2379
            [time] => 0.00044083595275879
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1781150418.2396
            [end] => 1781150418.2404
            [time] => 0.00082302093505859
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1781150418.2406
            [end] => 1781150418.2409
            [time] => 0.00030994415283203
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1781150418.2409
            [end] => 1781150418.2411
            [time] => 0.0002291202545166
        )

    [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] => 1781150418.2412
            [end] => 1781150418.2428
            [time] => 0.0015900135040283
        )

    [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] => 1781150418.2433
            [end] => 1781150418.2587
            [time] => 0.015398979187012
        )

    [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] => 1781150418.259
            [end] => 1781150418.5653
            [time] => 0.30635905265808
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '25'
            [start] => 1781150418.5665
            [end] => 1781150418.5668
            [time] => 0.00034999847412109
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1781150418.5669
            [end] => 1781150418.5672
            [time] => 0.00027203559875488
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '25'
            [start] => 1781150418.5672
            [end] => 1781150418.5674
            [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 <= 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] => 1781150418.5675
            [end] => 1781150418.5687
            [time] => 0.0012180805206299
        )

    [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] => 1781150418.5688
            [end] => 1781150418.5841
            [time] => 0.015297889709473
        )

    [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] => 1781150418.5842
            [end] => 1781150418.7916
            [time] => 0.20734286308289
        )

    [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] => 1781150418.7918
            [end] => 1781150418.7957
            [time] => 0.003870964050293
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781150418.799
            [end] => 1781150418.7993
            [time] => 0.0002591609954834
        )

    [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 <= 1781150418 OR start >= 1781150418) AND (end >= 1781150418 OR end = 0) AND (start < 1781150418) ORDER BY name ASC
            [start] => 1781150418.7993
            [end] => 1781150418.8003
            [time] => 0.00097012519836426
        )

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

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

)