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

Campionati: Campionato Eccellenza 2022/2023 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 Red Devils 45 18 15 3 1914 1571 343
2 Evolution 43 18 14 4 2085 1850 235
3 Lab To Hit 36 18 12 6 2092 1929 163
4 Sotomayor 33 18 11 7 1969 1843 126
5 Sunknights 29 18 10 8 1832 1861 -29
6 Piccolo Club 24 18 8 10 1967 1883 84
7 Sporting Team 18 18 6 12 1864 2037 -173
8 Citmabun 15 18 5 13 1670 1806 -136
9 Pazzeschi 15 18 5 13 1746 1976 -230
10 Torino Warriors 12 18 4 14 1712 2095 -383
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
Sporting Team 		1147 212 241 53% 0 17 0 0
2 Amedeo Biglino
Evolution 		583 161 87 35% 2 18 1 0
3 Mirko Violetto
Sunknights 		582 129 108 46% 4 17 0 0
4 Simone Selvaggio
Piccolo Club 		524 130 88 40% 1 18 1 0
5 Daniel Tiago Guzzafame
Sunknights 		511 107 99 48% 1 16 0 0
6 Roberto Coletta
Sotomayor 		496 125 82 40% 0 18 0 0
7 Riccardo De Marco
Torino Warriors 		455 85 95 53% 1 16 0 0
8 Luca Cardinali
Lab To Hit 		453 99 85 46% 3 18 0 0
9 Andrea Belcastro
Red Devils 		438 174 30 15% 2 18 0 0
10 Federico Pistidda
Lab To Hit 		437 70 99 59% 0 17 0 0
11 Claudio Belci
Sotomayor 		434 118 66 36% 2 18 0 0
12 Mattia Rizzon
Lab To Hit 		430 80 90 53% 1 18 1 0
13 Donald Basso
Piccolo Club 		422 112 66 37% 3 18 0 0
14 Daniele Gennaro
Citmabun 		408 129 50 28% 0 18 0 0
15 Antonio De Rosa
Pazzeschi 		379 125 43 26% 0 18 0 0
16 Michele Messina
Red Devils 		378 126 42 25% 0 18 0 0
17 Giuseppe Mirra
Pazzeschi 		344 97 50 34% 2 17 0 0
18 Mattia Vazzoler
Red Devils 		341 109 41 27% 0 17 1 0
19 Riccardo Del Boca
Pazzeschi 		338 109 40 27% 1 17 0 0
20 Marco Bressello
Citmabun 		337 83 57 41% 1 17 2 0
21 Gaspare Guarrato
Evolution 		333 96 47 33% 0 18 0 0
22 Riccardo Simini
Red Devils 		328 110 36 25% 3 17 0 0
23 Raffaele Maurelli
Evolution 		327 84 53 39% 0 16 0 0
24 Daniele Botosso
Piccolo Club 		319 80 53 40% 0 16 0 0
25 Antonio Mirco Santarsia
Evolution 		318 102 38 27% 0 18 0 0
26 Riccardo Pajno Ferrara
Sporting Team 		312 96 40 29% 0 17 0 0
27 Federico Solinas
Torino Warriors 		306 105 32 23% 0 18 0 0
28 Federico D'Oria
Lab To Hit 		300 48 68 59% 0 17 0 0
29 Davide Giordano
Pazzeschi 		297 90 39 30% 0 16 0 0
30 Jacopo Sanfilippo
Torino Warriors 		280 89 34 28% 2 18 0 0
31 Maurizio Rattalino
Sunknights 		277 62 51 45% 1 14 0 0
32 Leonardo Cicogna
Piccolo Club 		263 82 33 29% 3 16 0 0
33 Marco Antonio De Nichilo
Sunknights 		246 69 36 34% 1 14 0 0
34 Davide Brunello
Evolution 		243 66 37 36% 1 17 0 0
35 Marco De Salvo
Sotomayor 		240 72 32 31% 0 15 0 0
36 Stefano Calvo
Lab To Hit 		238 65 36 36% 0 17 0 0
37 Giacomo Garzaro
Citmabun 		235 71 31 30% 1 18 0 0
38 Simone Gabellini
Sotomayor 		221 97 9 8% 3 14 0 0
39 Giulio Naggi
Evolution 		214 68 26 28% 0 18 0 0
40 Luca Ambrosino
Citmabun 		204 63 26 29% 1 17 0 0
41 Sergio Fileccia
Pazzeschi 		204 81 14 15% 1 17 0 0
42 Riccardo Damiano
Citmabun 		198 69 20 22% 3 15 0 0
43 Matteo Macario Cot
Torino Warriors 		189 81 9 10% 0 17 1 0
44 Alessio Petrosino
Sotomayor 		184 65 18 22% 1 12 0 0
45 Danilo Sacchetto
Pazzeschi 		180 69 14 17% 1 17 0 0
46 Enrico Demonte
Sotomayor 		172 80 4 5% 0 18 0 0
47 Alberto Dolfin
Piccolo Club 		170 52 22 30% 0 17 0 0
48 Gianmarco Fogliato
Torino Warriors 		170 61 16 21% 0 14 0 0
49 Gaetano Dinatale
Sporting Team 		166 68 10 13% 0 18 1 0
50 Filippo Rovai
Sotomayor 		165 45 25 36% 1 10 0 0
51 Luca Cangialosi
Citmabun 		162 69 8 10% 0 14 0 0
52 Alex Serratore
Sporting Team 		161 43 25 37% 0 18 1 0
53 Andrea Suman
Red Devils 		149 58 11 16% 0 14 0 0
54 Andrea Joly
Piccolo Club 		143 55 11 17% 1 16 0 0
55 Stefano Benedetto
Red Devils 		138 57 8 12% 2 13 0 0
56 Marco Virgilio
Red Devils 		135 54 9 14% 0 14 0 0
57 Alessandro Rigardo
Lab To Hit 		123 45 11 20% 0 16 0 0
58 Gianluca Zanetti
Torino Warriors 		121 50 7 12% 1 11 0 0
59 Fabrizio Gennaro
Citmabun 		119 49 7 13% 0 16 0 0
60 Stefano Borelli
Torino Warriors 		116 55 2 4% 0 16 0 0
61 Matteo Cipolletta
Piccolo Club 		110 37 12 24% 1 14 0 0
62 Filippo Venturini
Lab To Hit 		104 28 16 36% 0 17 0 0
63 Alessandro Adami
Sunknights 		95 31 11 26% 0 13 0 0
64 Marco Gamba
Torino Warriors 		72 33 2 6% 1 15 0 0
65 Enrico Spagnolini
Sunknights 		71 31 3 9% 0 17 0 0
66 Franco Giambanco
Sporting Team 		57 21 5 19% 1 17 1 0
67 Leonardo Ramirez
Evolution 		43 17 3 15% 1 18 0 0
68 Matteo Clara
Sunknights 		27 12 1 8% 1 14 0 0
69 Alessandro Santomaggio
Evolution 		15 6 1 14% 0 5 0 0
70 Roberto Riccio
Piccolo Club 		11 4 1 20% 0 1 0 0
71 Francesco Bruno
Sporting Team 		6 3 0 0 1 16 0 0
72 Francesco Caligaris
Torino Warriors 		0 0 0 0 0 0 0 0
73 Alessio Casali
Red Devils 		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 Martina Lupo
Sotomayor 		50 25 0 0 3 18 0 0
2 Julie Carpinelli
Sunknights 		17 7 1 13% 0 9 0 0
3 Ilaria Mezzatesta
Sporting Team 		10 5 0 0 0 16 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.4314079284668
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034117.7189
            [end] => 1766034117.7192
            [time] => 0.00035977363586426
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1766034117.7213
            [end] => 1766034117.7216
            [time] => 0.00025010108947754
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1766034117.7217
            [end] => 1766034117.722
            [time] => 0.00029397010803223
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2280,2277,2279,2281,2278,2284,2285,2286,2282,2283,2287,2291,2290,2289,2288,2292,2293,2296,2295,2294,2297,2301,2298,2299,2300,2302,2306,2304,2303,2305,2310,2311,2309,2307,2308,2313,2314,2316,2315,2312,2320,2319,2318,2317,2321,2322,2326,2325,2323,2324,2331,2328,2327,2329,2330,2332,2335,2336,2333,2334,2339,2340,2341,2337,2338,2344,2343,2342,2346,2345,2347,2349,2348,2350,2351,2356,2355,2354,2352,2353,2359,2361,2357,2360,2358,2365,2362,2364,2363,2366) order by id ASC
            [start] => 1766034117.7255
            [end] => 1766034117.7285
            [time] => 0.0029559135437012
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2280,2277,2279,2281,2278,2284,2285,2286,2282,2283,2287,2291,2290,2289,2288,2292,2293,2296,2295,2294,2297,2301,2298,2299,2300,2302,2306,2304,2303,2305,2310,2311,2309,2307,2308,2313,2314,2316,2315,2312,2320,2319,2318,2317,2321,2322,2326,2325,2323,2324,2331,2328,2327,2329,2330,2332,2335,2336,2333,2334,2339,2340,2341,2337,2338,2344,2343,2342,2346,2345,2347,2349,2348,2350,2351,2356,2355,2354,2352,2353,2359,2361,2357,2360,2358,2365,2362,2364,2363,2366)
            [start] => 1766034117.8651
            [end] => 1766034117.8783
            [time] => 0.013175964355469
        )

    [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 <= 1766034117 OR start >= 1766034117) AND (end >= 1766034117 OR end = 0) AND (start < 1766034117) ORDER BY name ASC
            [start] => 1766034117.9026
            [end] => 1766034117.9035
            [time] => 0.00094318389892578
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1766034117.9036
            [end] => 1766034117.9038
            [time] => 0.0002448558807373
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1766034117.9039
            [end] => 1766034117.9042
            [time] => 0.00025200843811035
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2280,2277,2279,2281,2278,2284,2285,2286,2282,2283,2287,2291,2290,2289,2288,2292,2293,2296,2295,2294,2297,2301,2298,2299,2300,2302,2306,2304,2303,2305,2310,2311,2309,2307,2308,2313,2314,2316,2315,2312,2320,2319,2318,2317,2321,2322,2326,2325,2323,2324,2331,2328,2327,2329,2330,2332,2335,2336,2333,2334,2339,2340,2341,2337,2338,2344,2343,2342,2346,2345,2347,2349,2348,2350,2351,2356,2355,2354,2352,2353,2359,2361,2357,2360,2358,2365,2362,2364,2363,2366) order by id ASC
            [start] => 1766034117.9077
            [end] => 1766034117.9107
            [time] => 0.0030660629272461
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1766034118.0461
            [end] => 1766034118.0466
            [time] => 0.00047683715820312
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1766034118.0481
            [end] => 1766034118.0484
            [time] => 0.00028491020202637
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1766034118.0484
            [end] => 1766034118.0487
            [time] => 0.00027108192443848
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1766034118.0487
            [end] => 1766034118.0489
            [time] => 0.00020289421081543
        )

    [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 <= 1663329952 OR start >= 1663329952) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (2,16,17,18,19,21,1,35,22,33) ORDER BY lastname,firstname ASC
            [start] => 1766034118.049
            [end] => 1766034118.0505
            [time] => 0.0014522075653076
        )

    [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 = '8') 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] => 1766034118.051
            [end] => 1766034118.0632
            [time] => 0.012217044830322
        )

    [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 = '8')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034118.0635
            [end] => 1766034118.2669
            [time] => 0.20348191261292
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1766034118.268
            [end] => 1766034118.2683
            [time] => 0.00029706954956055
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1766034118.2684
            [end] => 1766034118.2687
            [time] => 0.00027298927307129
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1766034118.2687
            [end] => 1766034118.2689
            [time] => 0.00020599365234375
        )

    [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 <= 1663329952 OR start >= 1663329952) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (2,16,17,18,19,21,1,35,22,33) ORDER BY lastname,firstname ASC
            [start] => 1766034118.269
            [end] => 1766034118.27
            [time] => 0.00099897384643555
        )

    [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 = '8') 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] => 1766034118.2702
            [end] => 1766034118.2823
            [time] => 0.012066125869751
        )

    [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 = '8')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034118.2824
            [end] => 1766034118.4483
            [time] => 0.16592502593994
        )

    [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 <= 1663329952 OR start >= 1663329952) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) ORDER BY lastname,firstname ASC
            [start] => 1766034118.4485
            [end] => 1766034118.4522
            [time] => 0.0036969184875488
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034118.4554
            [end] => 1766034118.4556
            [time] => 0.00026607513427734
        )

    [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 <= 1766034118 OR start >= 1766034118) AND (end >= 1766034118 OR end = 0) AND (start < 1766034118) ORDER BY name ASC
            [start] => 1766034118.4557
            [end] => 1766034118.4565
            [time] => 0.00073885917663574
        )

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

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

)