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

Campionati: Campionato Eccellenza 2023/2024 A2

  1. Home
  2. Campionati
  3. Campionati

Mercoledì 08-11-2023

Domenica 12-11-2023

Martedì 14-11-2023

Mercoledì 15-11-2023

Domenica 19-11-2023

Mercoledì 22-11-2023

Domenica 26-11-2023

Lunedì 27-11-2023

Mercoledì 29-11-2023

Domenica 03-12-2023

Mercoledì 13-12-2023

Giovedì 14-12-2023

Domenica 17-12-2023

Mercoledì 20-12-2023

Giovedì 21-12-2023

Martedì 09-01-2024

Mercoledì 10-01-2024

Domenica 14-01-2024

Martedì 16-01-2024

Mercoledì 17-01-2024

Venerdì 19-01-2024

Domenica 21-01-2024

Mercoledì 24-01-2024

Giovedì 25-01-2024

Domenica 28-01-2024

Mercoledì 31-01-2024

Venerdì 02-02-2024

Domenica 04-02-2024

Mercoledì 14-02-2024

Venerdì 16-02-2024

Domenica 18-02-2024

Mercoledì 21-02-2024

Giovedì 22-02-2024

Domenica 25-02-2024

Giovedì 29-02-2024

Domenica 03-03-2024

Mercoledì 06-03-2024

Venerdì 08-03-2024

Domenica 10-03-2024

Mercoledì 13-03-2024

Giovedì 14-03-2024

Domenica 17-03-2024

Mercoledì 20-03-2024

Venerdì 22-03-2024

Domenica 24-03-2024

Mercoledì 03-04-2024

Venerdì 05-04-2024

Domenica 07-04-2024

Mercoledì 10-04-2024

Domenica 14-04-2024

Giovedì 18-04-2024

Domenica 21-04-2024

Domenica 28-04-2024

Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
1 Genova Hit Ball 45 18 15 3 1608 1035 573
2 Skoppiati 45 18 15 3 1808 1578 230
3 All Blacks 36 18 12 6 1452 1424 28
4 Flamurtari 30 18 10 8 1732 1601 131
5 Torino Warriors 30 18 10 8 1744 1676 68
6 Sheet 30 18 10 8 1503 1522 -19
7 Pellegrini Venaria 30 18 10 8 1546 1525 21
8 Guardians Chivasso 18 18 6 12 1541 1659 -118
9 Hammers 5 18 2 16 1519 1851 -332
10 Sporting Team Furious 0 18 0 18 1179 1761 -582
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 Pietro Evangelista
Flamurtari 		757 23 237 91% 2 18 2 0
2 Luca Fagherazzi
Genova Hit Ball 		479 154 57 27% 3 17 0 0
3 Riccardo Francabandiera
Skoppiati 		429 153 41 21% 1 18 0 0
4 Marcello Bacchini
All Blacks 		406 119 56 32% 2 18 1 0
5 Gabriele Barone
Pellegrini Venaria 		401 139 41 23% 0 18 0 0
6 Riccardo De Marco
Torino Warriors 		377 64 83 56% 1 10 0 0
7 Ion Soroceanu
Skoppiati 		362 133 32 19% 1 18 2 0
8 Lennin Jarek Garcia
Skoppiati 		344 121 34 22% 4 18 0 0
9 Stefano Benedetti
Sheet 		341 64 71 53% 1 17 0 0
10 Alessandro Romano
Flamurtari 		340 59 74 56% 1 18 0 0
11 Federico Perno
All Blacks 		331 131 23 15% 2 18 1 0
12 Luca Mocciaro
Pellegrini Venaria 		299 46 69 60% 0 15 0 0
13 Davide Centin
Hammers 		293 106 27 20% 1 16 0 0
14 Matteo Turigliatto
Flamurtari 		289 128 11 8% 0 15 0 0
15 Jacopo Sanfilippo
Torino Warriors 		285 69 49 42% 0 16 0 0
16 Rosso Paolo
Guardians Chivasso 		284 79 42 35% 1 18 0 0
17 Stefano Borelli
Torino Warriors 		280 104 24 19% 1 18 0 0
18 Giovanni Marino
Hammers 		275 130 5 4% 3 16 0 0
19 Mauro Pompili
All Blacks 		273 87 33 28% 0 18 0 0
20 Andrea Lavalle
Sheet 		273 90 31 26% 1 17 0 0
21 Diego Leonardi
All Blacks 		267 78 37 32% 5 18 1 0
22 Luca Siciliano
Genova Hit Ball 		265 116 11 9% 0 15 0 0
23 Marco Gamba
Torino Warriors 		260 124 4 3% 0 17 0 0
24 Dario Ravera
Genova Hit Ball 		257 100 19 16% 1 14 0 0
25 Carlo Pangallo
Sheet 		248 67 38 36% 0 18 1 0
26 Federico Solinas
Torino Warriors 		242 91 20 18% 0 14 0 0
27 Stefano Falvo
Sporting Team Furious 		241 80 27 25% 2 14 0 0
28 Giovanni Marsico
Skoppiati 		221 70 27 28% 1 18 0 0
29 Alberto Casalegno
Pellegrini Venaria 		218 79 20 20% 2 17 0 0
30 Gianluca Zingarelli
All Blacks 		192 63 22 26% 2 17 1 0
31 Gabriele Salerno
Hammers 		191 61 23 27% 3 14 1 0
32 Federico Sisci
Pellegrini Venaria 		184 74 12 14% 1 15 0 0
33 Domenico Pirozzolo
Pellegrini Venaria 		175 71 11 13% 0 18 0 0
34 Enrico Salari
Flamurtari 		174 78 6 7% 1 12 0 0
35 Leonardo Farina
Genova Hit Ball 		165 78 3 4% 2 16 0 0
36 Andrea Giustetti
Sheet 		154 53 16 23% 0 17 1 0
37 Luca Dragna
Pellegrini Venaria 		151 68 5 7% 1 16 0 0
38 Davide Ciancio
Genova Hit Ball 		148 65 6 8% 0 17 0 0
39 Ivan Russo
Hammers 		145 68 3 4% 0 17 0 0
40 Francesco Dughera
Guardians Chivasso 		144 57 10 15% 2 17 0 0
41 Patrick Marzano
All Blacks 		140 52 12 19% 3 18 1 0
42 Riccardo Merlo
Genova Hit Ball 		137 67 1 1% 0 14 0 0
43 Federico Suppo
Skoppiati 		135 51 11 18% 3 12 0 0
44 Lorenzo Fontana
Skoppiati 		109 41 9 18% 1 13 0 0
45 Stefano Truzzi
Sheet 		106 29 16 36% 1 17 1 0
46 Andrea Lovera
All Blacks 		104 34 12 26% 0 17 1 0
47 Angelo D'Alessandra
Guardians Chivasso 		104 43 6 12% 1 10 1 0
48 Marco Zanatta
Flamurtari 		84 33 6 15% 0 16 0 0
49 Matteo Barberis
Sporting Team Furious 		77 37 1 3% 0 11 0 0
50 Daniele Managò
Flamurtari 		47 13 7 35% 3 15 0 0
51 Carlo Del console
Sporting Team Furious 		45 21 1 5% 1 12 0 0
52 Luca Curti
Pellegrini Venaria 		44 13 6 32% 0 12 0 0
53 Giorgio Recalcati
Genova Hit Ball 		38 19 0 0 0 13 0 0
54 Gianmarco Fogliato
Torino Warriors 		34 14 2 13% 0 3 0 0
55 Davide Casalegno
Pellegrini Venaria 		32 13 2 13% 1 14 0 0
56 Antonio Marincola
Sporting Team Furious 		25 11 1 8% 0 5 0 0
57 Vincenzo Padula
Sporting Team Furious 		23 10 1 9% 0 11 0 0
58 Leonardo Chiarella
Genova Hit Ball 		6 3 0 0 0 4 1 0
59 Antonio D'Elicio
Torino Warriors 		0 0 0 0 0 0 0 0
60 Andrea De Blasio
Sheet 		0 0 0 0 0 0 0 0
61 Federico Gennaro
Guardians Chivasso 		0 0 0 0 0 0 0 0
62 Alberto Giacometti
Hammers 		0 0 0 0 0 0 0 0
63 Andrea Giannitti
Sporting Team Furious 		0 0 0 0 0 0 0 0
64 Giacomo Guarrato
Torino Warriors 		0 0 0 0 0 0 0 0
65 Fabio Ingrassia
Sheet 		0 0 0 0 0 0 0 0
66 Adriano Paribello Grasso
Guardians Chivasso 		0 0 0 0 0 0 0 0
67 Ivano Reato
Guardians Chivasso 		0 0 0 0 0 0 0 0
68 Marco Salusso
Sheet 		0 0 0 0 0 0 0 0
69 Marcello Saporito
Guardians Chivasso 		0 0 0 0 0 0 0 0
70 Massimo Sbano
Hammers 		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 Carlotta Amodeo
Torino Warriors 		100 41 6 13% 2 18 0 0
2 Ilaria Mezzatesta
Sporting Team Furious 		32 16 0 0 0 13 0 0
3 Barbara Tombolato
Pellegrini Venaria 		32 16 0 0 0 15 0 0
4 Federica Funnone
Flamurtari 		9 3 1 25% 0 18 0 0
5 Sabrina Capitolo
Hammers 		0 0 0 0 0 0 0 0
6 Arianna Vismara
Sporting Team Furious 		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.62111973762512
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781154511.0782
            [end] => 1781154511.0785
            [time] => 0.00029110908508301
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781154511.0808
            [end] => 1781154511.0811
            [time] => 0.00024604797363281
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781154511.0812
            [end] => 1781154511.0815
            [time] => 0.00027203559875488
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '19' 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] => 1781154511.0816
            [end] => 1781154511.0846
            [time] => 0.003040075302124
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (3060,3062,3063,3064,3069,3067,3065,3068,3066,3073,3074,3072,3071,3070,3079,3077,3078,3075,3076,3080,3081,3084,3083,3086,3085,3089,3087,3092,3090,3093,3094,3091,3096,3097,3098,3099,3095,3100,3101,3102,3103,3104,3105,3109,3106,3148,3107,3110,3114,3112,3111,3113,3117,3118,3116,3115,3119,3108,3061,3088,3122,3120,3123,3121,3124,3129,3128,3125,3127,3126,3130,3134,3131,3133,3132,3136,3135,3137,3138,3139,3140,3142,3141,3143,3144,3147,3145,3149,3146,3082) order by id ASC
            [start] => 1781154511.0852
            [end] => 1781154511.0889
            [time] => 0.0036520957946777
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3060,3062,3063,3064,3069,3067,3065,3068,3066,3073,3074,3072,3071,3070,3079,3077,3078,3075,3076,3080,3081,3084,3083,3086,3085,3089,3087,3092,3090,3093,3094,3091,3096,3097,3098,3099,3095,3100,3101,3102,3103,3104,3105,3109,3106,3148,3107,3110,3114,3112,3111,3113,3117,3118,3116,3115,3119,3108,3061,3088,3122,3120,3123,3121,3124,3129,3128,3125,3127,3126,3130,3134,3131,3133,3132,3136,3135,3137,3138,3139,3140,3142,3141,3143,3144,3147,3145,3149,3146,3082)
            [start] => 1781154511.2663
            [end] => 1781154511.2813
            [time] => 0.015001058578491
        )

    [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 <= 1781154511 OR start >= 1781154511) AND (end >= 1781154511 OR end = 0) AND (start < 1781154511) ORDER BY name ASC
            [start] => 1781154511.3173
            [end] => 1781154511.3186
            [time] => 0.001209020614624
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781154511.3187
            [end] => 1781154511.3192
            [time] => 0.00049519538879395
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781154511.3192
            [end] => 1781154511.3195
            [time] => 0.00027179718017578
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (3060,3062,3063,3064,3061,3069,3067,3065,3068,3066,3073,3074,3072,3071,3070,3079,3077,3078,3075,3076,3080,3081,3084,3083,3082,3085,3086,3089,3087,3088,3092,3090,3093,3094,3091,3096,3097,3098,3099,3095,3100,3101,3102,3103,3104,3105,3109,3106,3107,3108,3110,3114,3112,3111,3113,3117,3118,3116,3115,3119,3122,3120,3123,3121,3124,3129,3128,3125,3127,3126,3130,3134,3131,3133,3132,3136,3135,3137,3138,3139,3140,3142,3141,3143,3144,3148,3147,3145,3149,3146) order by id ASC
            [start] => 1781154511.3241
            [end] => 1781154511.3279
            [time] => 0.0037250518798828
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781154511.5055
            [end] => 1781154511.506
            [time] => 0.00046992301940918
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781154511.5077
            [end] => 1781154511.508
            [time] => 0.0002288818359375
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781154511.5081
            [end] => 1781154511.5083
            [time] => 0.00024604797363281
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781154511.5084
            [end] => 1781154511.5086
            [time] => 0.00021600723266602
        )

    [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 <= 1693760743 OR start >= 1693760743) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (31,36,38,8,14,32,11,4,34,33) ORDER BY lastname,firstname ASC
            [start] => 1781154511.5087
            [end] => 1781154511.5104
            [time] => 0.0017681121826172
        )

    [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 = '19') 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] => 1781154511.511
            [end] => 1781154511.5266
            [time] => 0.015669107437134
        )

    [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 = '19')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1781154511.5269
            [end] => 1781154511.7958
            [time] => 0.26891708374023
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781154511.7969
            [end] => 1781154511.7972
            [time] => 0.00032305717468262
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781154511.7973
            [end] => 1781154511.7976
            [time] => 0.00026488304138184
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781154511.7976
            [end] => 1781154511.7978
            [time] => 0.00024604797363281
        )

    [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 <= 1693760743 OR start >= 1693760743) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) AND team_id in (31,36,38,8,14,32,11,4,34,33) ORDER BY lastname,firstname ASC
            [start] => 1781154511.7979
            [end] => 1781154511.7991
            [time] => 0.0011489391326904
        )

    [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 = '19') 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] => 1781154511.7992
            [end] => 1781154511.8148
            [time] => 0.015536069869995
        )

    [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 = '19')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1781154511.8149
            [end] => 1781154512.0919
            [time] => 0.27707719802856
        )

    [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 <= 1693760743 OR start >= 1693760743) AND (end >= 1727647200 OR end = 0) AND (start < 1727647200) ORDER BY lastname,firstname ASC
            [start] => 1781154512.0922
            [end] => 1781154512.0963
            [time] => 0.0041000843048096
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781154512.0995
            [end] => 1781154512.0998
            [time] => 0.00030207633972168
        )

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

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

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

)