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

Campionati: Campionato Eccellenza 2022/2023 A1

  1. Home
  2. Campionati
  3. Campionati

Sabato 05-11-2022

Domenica 06-11-2022

Mercoledì 09-11-2022

Sabato 12-11-2022

Domenica 13-11-2022

Mercoledì 16-11-2022

Sabato 19-11-2022

Domenica 20-11-2022

Mercoledì 23-11-2022

Venerdì 25-11-2022

Sabato 26-11-2022

Mercoledì 30-11-2022

Sabato 03-12-2022

Domenica 04-12-2022

Martedì 13-12-2022

Mercoledì 14-12-2022

Venerdì 16-12-2022

Sabato 17-12-2022

Martedì 10-01-2023

Mercoledì 11-01-2023

Sabato 14-01-2023

Domenica 15-01-2023

Mercoledì 18-01-2023

Sabato 21-01-2023

Domenica 22-01-2023

Martedì 24-01-2023

Mercoledì 25-01-2023

Venerdì 27-01-2023

Domenica 29-01-2023

Martedì 31-01-2023

Mercoledì 01-02-2023

Sabato 04-02-2023

Martedì 07-02-2023

Mercoledì 08-02-2023

Sabato 18-02-2023

Domenica 19-02-2023

Mercoledì 22-02-2023

Venerdì 24-02-2023

Martedì 28-02-2023

Mercoledì 01-03-2023

Mercoledì 08-03-2023

Domenica 12-03-2023

Mercoledì 15-03-2023

Venerdì 17-03-2023

Martedì 21-03-2023

Mercoledì 22-03-2023

Venerdì 24-03-2023

Sabato 25-03-2023

Martedì 28-03-2023

Mercoledì 29-03-2023

Sabato 01-04-2023

Mercoledì 05-04-2023

Sabato 15-04-2023

Domenica 16-04-2023

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.65914416313171
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781154482.154
            [end] => 1781154482.1543
            [time] => 0.00030207633972168
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781154482.157
            [end] => 1781154482.1573
            [time] => 0.00024580955505371
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781154482.1574
            [end] => 1781154482.1576
            [time] => 0.00026202201843262
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '8' 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] => 1781154482.1578
            [end] => 1781154482.1608
            [time] => 0.0030481815338135
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2280,2277,2279,2281,2284,2285,2286,2282,2287,2291,2290,2289,2288,2292,2293,2296,2295,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,2283,2278,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,2294,2365,2362,2364,2363,2366) order by id ASC
            [start] => 1781154482.1614
            [end] => 1781154482.165
            [time] => 0.0036141872406006
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2280,2277,2279,2281,2284,2285,2286,2282,2287,2291,2290,2289,2288,2292,2293,2296,2295,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,2283,2278,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,2294,2365,2362,2364,2363,2366)
            [start] => 1781154482.345
            [end] => 1781154482.3596
            [time] => 0.014658212661743
        )

    [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 <= 1781154482 OR start >= 1781154482) AND (end >= 1781154482 OR end = 0) AND (start < 1781154482) ORDER BY name ASC
            [start] => 1781154482.393
            [end] => 1781154482.3943
            [time] => 0.0012791156768799
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781154482.3944
            [end] => 1781154482.3946
            [time] => 0.00021195411682129
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781154482.3947
            [end] => 1781154482.3949
            [time] => 0.00027012825012207
        )

    [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] => 1781154482.3951
            [end] => 1781154482.3983
            [time] => 0.0031838417053223
        )

    [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] => 1781154482.3989
            [end] => 1781154482.4027
            [time] => 0.0037720203399658
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781154482.5921
            [end] => 1781154482.5925
            [time] => 0.00042510032653809
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781154482.5939
            [end] => 1781154482.5942
            [time] => 0.00022077560424805
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781154482.5943
            [end] => 1781154482.5945
            [time] => 0.00023984909057617
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781154482.5945
            [end] => 1781154482.5948
            [time] => 0.00023794174194336
        )

    [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] => 1781154482.5949
            [end] => 1781154482.5965
            [time] => 0.0015699863433838
        )

    [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] => 1781154482.597
            [end] => 1781154482.6121
            [time] => 0.015092849731445
        )

    [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] => 1781154482.6123
            [end] => 1781154482.9135
            [time] => 0.30118703842163
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781154482.9146
            [end] => 1781154482.9149
            [time] => 0.00030779838562012
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781154482.915
            [end] => 1781154482.9153
            [time] => 0.00025510787963867
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781154482.9153
            [end] => 1781154482.9155
            [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 <= 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] => 1781154482.9156
            [end] => 1781154482.9167
            [time] => 0.0011579990386963
        )

    [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] => 1781154482.9169
            [end] => 1781154482.9325
            [time] => 0.015624046325684
        )

    [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] => 1781154482.9326
            [end] => 1781154483.2172
            [time] => 0.28461313247681
        )

    [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] => 1781154483.2175
            [end] => 1781154483.2216
            [time] => 0.004194974899292
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781154483.225
            [end] => 1781154483.2253
            [time] => 0.00028491020202637
        )

    [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 <= 1781154483 OR start >= 1781154483) AND (end >= 1781154483 OR end = 0) AND (start < 1781154483) ORDER BY name ASC
            [start] => 1781154483.2254
            [end] => 1781154483.2265
            [time] => 0.001054048538208
        )

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

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

)