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.63150858879089
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781150355.9246
            [end] => 1781150355.9268
            [time] => 0.0021460056304932
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781150355.9324
            [end] => 1781150355.9327
            [time] => 0.00021791458129883
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781150355.9328
            [end] => 1781150355.9331
            [time] => 0.00025606155395508
        )

    [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] => 1781150355.9332
            [end] => 1781150355.9372
            [time] => 0.004065990447998
        )

    [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] => 1781150355.9379
            [end] => 1781150355.9426
            [time] => 0.0047390460968018
        )

    [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] => 1781150356.3207
            [end] => 1781150356.336
            [time] => 0.01530909538269
        )

    [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 <= 1781150356 OR start >= 1781150356) AND (end >= 1781150356 OR end = 0) AND (start < 1781150356) ORDER BY name ASC
            [start] => 1781150356.3716
            [end] => 1781150356.3729
            [time] => 0.0012919902801514
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781150356.373
            [end] => 1781150356.3732
            [time] => 0.00020408630371094
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781150356.3733
            [end] => 1781150356.3735
            [time] => 0.00025105476379395
        )

    [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] => 1781150356.3737
            [end] => 1781150356.3769
            [time] => 0.0031530857086182
        )

    [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] => 1781150356.3775
            [end] => 1781150356.3812
            [time] => 0.0037391185760498
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781150356.5593
            [end] => 1781150356.5598
            [time] => 0.00045609474182129
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781150356.5615
            [end] => 1781150356.5618
            [time] => 0.00026607513427734
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781150356.5619
            [end] => 1781150356.5622
            [time] => 0.00024914741516113
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781150356.5622
            [end] => 1781150356.5624
            [time] => 0.0002131462097168
        )

    [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] => 1781150356.5625
            [end] => 1781150356.5641
            [time] => 0.0016450881958008
        )

    [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] => 1781150356.5646
            [end] => 1781150356.5801
            [time] => 0.015512943267822
        )

    [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] => 1781150356.5804
            [end] => 1781150356.9077
            [time] => 0.32734107971191
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '19'
            [start] => 1781150356.9088
            [end] => 1781150356.9091
            [time] => 0.00029301643371582
        )

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

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '19'
            [start] => 1781150356.9095
            [end] => 1781150356.9097
            [time] => 0.00024509429931641
        )

    [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] => 1781150356.9098
            [end] => 1781150356.911
            [time] => 0.0011739730834961
        )

    [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] => 1781150356.9111
            [end] => 1781150356.9266
            [time] => 0.015450000762939
        )

    [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] => 1781150356.9267
            [end] => 1781150357.1533
            [time] => 0.22656798362732
        )

    [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] => 1781150357.1535
            [end] => 1781150357.1573
            [time] => 0.0037291049957275
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781150357.1604
            [end] => 1781150357.1607
            [time] => 0.00029397010803223
        )

    [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 <= 1781150357 OR start >= 1781150357) AND (end >= 1781150357 OR end = 0) AND (start < 1781150357) ORDER BY name ASC
            [start] => 1781150357.1608
            [end] => 1781150357.1617
            [time] => 0.00095415115356445
        )

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

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

)