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.65596556663513
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781150266.3847
            [end] => 1781150266.385
            [time] => 0.00030422210693359
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781150266.3876
            [end] => 1781150266.3879
            [time] => 0.00031185150146484
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781150266.388
            [end] => 1781150266.3883
            [time] => 0.00027108192443848
        )

    [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] => 1781150266.3884
            [end] => 1781150266.3926
            [time] => 0.004180908203125
        )

    [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] => 1781150266.3932
            [end] => 1781150266.397
            [time] => 0.0038058757781982
        )

    [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] => 1781150266.5793
            [end] => 1781150266.5943
            [time] => 0.01500391960144
        )

    [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 <= 1781150266 OR start >= 1781150266) AND (end >= 1781150266 OR end = 0) AND (start < 1781150266) ORDER BY name ASC
            [start] => 1781150266.6274
            [end] => 1781150266.6288
            [time] => 0.0013208389282227
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781150266.6289
            [end] => 1781150266.6291
            [time] => 0.00021696090698242
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781150266.6292
            [end] => 1781150266.6294
            [time] => 0.00023913383483887
        )

    [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] => 1781150266.6296
            [end] => 1781150266.6327
            [time] => 0.0031599998474121
        )

    [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] => 1781150266.6333
            [end] => 1781150266.6371
            [time] => 0.0037848949432373
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781150266.8183
            [end] => 1781150266.8187
            [time] => 0.00038599967956543
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781150266.8202
            [end] => 1781150266.8204
            [time] => 0.00023198127746582
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781150266.8205
            [end] => 1781150266.8208
            [time] => 0.0002751350402832
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781150266.8208
            [end] => 1781150266.8211
            [time] => 0.00021910667419434
        )

    [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] => 1781150266.8212
            [end] => 1781150266.8228
            [time] => 0.0016210079193115
        )

    [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] => 1781150266.8234
            [end] => 1781150266.8391
            [time] => 0.015740156173706
        )

    [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] => 1781150266.8394
            [end] => 1781150267.2011
            [time] => 0.36168098449707
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '8'
            [start] => 1781150267.2022
            [end] => 1781150267.2025
            [time] => 0.0003049373626709
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781150267.2026
            [end] => 1781150267.2029
            [time] => 0.00028204917907715
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '8'
            [start] => 1781150267.2029
            [end] => 1781150267.2031
            [time] => 0.00021696090698242
        )

    [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] => 1781150267.2032
            [end] => 1781150267.2043
            [time] => 0.0010950565338135
        )

    [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] => 1781150267.2044
            [end] => 1781150267.2194
            [time] => 0.014942169189453
        )

    [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] => 1781150267.2195
            [end] => 1781150267.4387
            [time] => 0.21927714347839
        )

    [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] => 1781150267.439
            [end] => 1781150267.4431
            [time] => 0.0041220188140869
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781150267.4465
            [end] => 1781150267.4468
            [time] => 0.00029301643371582
        )

    [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 <= 1781150267 OR start >= 1781150267) AND (end >= 1781150267 OR end = 0) AND (start < 1781150267) ORDER BY name ASC
            [start] => 1781150267.4468
            [end] => 1781150267.4479
            [time] => 0.0010590553283691
        )

    [28] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1781150267.45
            [end] => 1781150267.4503
            [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] => 1781150267.4512
            [end] => 1781150267.4516
            [time] => 0.00036501884460449
        )

)