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

Campionati: Campionato Eccellenza 2023/2024 A2

  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 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 Next Gen 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 Next Gen 		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 Next Gen 		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 Next Gen 		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 Next Gen 		25 11 1 8% 0 5 0 0
57 Vincenzo Padula
Sporting Team Next Gen 		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 Next Gen 		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 Next Gen 		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 Next Gen 		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.51198959350586
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034109.1354
            [end] => 1766034109.1358
            [time] => 0.00040888786315918
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1766034109.1383
            [end] => 1766034109.1387
            [time] => 0.00041794776916504
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1766034109.1389
            [end] => 1766034109.1393
            [time] => 0.00035595893859863
        )

    [3] => 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] => 1766034109.1395
            [end] => 1766034109.143
            [time] => 0.0034840106964111
        )

    [4] => 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] => 1766034109.1435
            [end] => 1766034109.1466
            [time] => 0.0030457973480225
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data 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)
            [start] => 1766034109.283
            [end] => 1766034109.2967
            [time] => 0.013628005981445
        )

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

    [7] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1766034109.3252
            [end] => 1766034109.3254
            [time] => 0.00018095970153809
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1766034109.3255
            [end] => 1766034109.3257
            [time] => 0.00024104118347168
        )

    [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] => 1766034109.3259
            [end] => 1766034109.3287
            [time] => 0.0028398036956787
        )

    [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] => 1766034109.3293
            [end] => 1766034109.3323
            [time] => 0.0029881000518799
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1766034109.4969
            [end] => 1766034109.4998
            [time] => 0.0028619766235352
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1766034109.5016
            [end] => 1766034109.5019
            [time] => 0.00031495094299316
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1766034109.502
            [end] => 1766034109.5057
            [time] => 0.0037670135498047
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1766034109.5058
            [end] => 1766034109.506
            [time] => 0.00025606155395508
        )

    [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] => 1766034109.5062
            [end] => 1766034109.5076
            [time] => 0.0013980865478516
        )

    [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] => 1766034109.5081
            [end] => 1766034109.5509
            [time] => 0.042800903320312
        )

    [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] => 1766034109.5512
            [end] => 1766034109.797
            [time] => 0.2458381652832
        )

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

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1766034109.7985
            [end] => 1766034109.7988
            [time] => 0.00027894973754883
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1766034109.7988
            [end] => 1766034109.799
            [time] => 0.00021195411682129
        )

    [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] => 1766034109.7991
            [end] => 1766034109.8
            [time] => 0.0009617805480957
        )

    [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] => 1766034109.8002
            [end] => 1766034109.8123
            [time] => 0.012160062789917
        )

    [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] => 1766034109.8124
            [end] => 1766034109.9784
            [time] => 0.16596102714539
        )

    [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] => 1766034109.9786
            [end] => 1766034109.9822
            [time] => 0.0036249160766602
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034109.9853
            [end] => 1766034109.9858
            [time] => 0.00042891502380371
        )

    [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 <= 1766034109 OR start >= 1766034109) AND (end >= 1766034109 OR end = 0) AND (start < 1766034109) ORDER BY name ASC
            [start] => 1766034109.9858
            [end] => 1766034109.9866
            [time] => 0.00078296661376953
        )

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

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

)