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

Campionati: Campionato Eccellenza 2021/2022 A1

  1. Home
  2. Campionati
  3. Campionati

Mercoledì 27-10-2021

Venerdì 29-10-2021

Domenica 31-10-2021

Sabato 13-11-2021

Domenica 14-11-2021

Mercoledì 17-11-2021

Giovedì 18-11-2021

Domenica 21-11-2021

Sabato 04-12-2021

Domenica 05-12-2021

Martedì 07-12-2021

Giovedì 09-12-2021

Venerdì 10-12-2021

Domenica 12-12-2021

Mercoledì 15-12-2021

Venerdì 17-12-2021

Domenica 19-12-2021

Martedì 08-02-2022

Mercoledì 09-02-2022

Domenica 13-02-2022

Domenica 20-02-2022

Martedì 22-02-2022

Mercoledì 23-02-2022

Mercoledì 02-03-2022

Sabato 05-03-2022

Domenica 06-03-2022

Mercoledì 09-03-2022

Venerdì 11-03-2022

Domenica 13-03-2022

Sabato 19-03-2022

Domenica 20-03-2022

Martedì 22-03-2022

Mercoledì 23-03-2022

Domenica 27-03-2022

Sabato 02-04-2022

Domenica 03-04-2022

Martedì 05-04-2022

Mercoledì 06-04-2022

Giovedì 07-04-2022

Sabato 09-04-2022

Domenica 10-04-2022

Martedì 12-04-2022

Mercoledì 13-04-2022

Sabato 23-04-2022

Domenica 24-04-2022

Mercoledì 04-05-2022

Giovedì 05-05-2022

Sabato 07-05-2022

Domenica 08-05-2022

Lunedì 09-05-2022

Sabato 14-05-2022

Domenica 15-05-2022

Sabato 21-05-2022

Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
1 Lab To Hit 45 18 15 3 1706 1393 313
2 Sotomayor 39 18 13 5 1610 1397 213
3 Piccolo Club 39 18 13 5 1692 1418 274
4 Evolution 36 18 12 6 1587 1499 88
5 Red Devils 33 18 11 7 1500 1286 214
6 Citmabun 30 18 10 8 1387 1371 16
7 Sunknights 23 18 8 10 1478 1554 -76
8 Pazzeschi 12 18 4 14 1304 1664 -360
9 Genova Hit Ball 8 18 3 15 1194 1461 -267
10 Rdj 3 18 1 17 1223 1638 -415
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 Amedeo Biglino
Evolution 		598 191 72 27% 1 18 0 0
2 Mirko Violetto
Sunknights 		521 133 85 39% 2 17 0 0
3 Simone Selvaggio
Piccolo Club 		451 125 67 35% 1 18 0 0
4 Luca Cardinali
Lab To Hit 		446 142 54 28% 2 18 0 0
5 Daniel Tiago Guzzafame
Sunknights 		413 97 73 43% 2 16 0 0
6 Daniele Botosso
Piccolo Club 		377 100 59 37% 1 16 0 0
7 Claudio Belci
Sotomayor 		363 111 47 30% 0 18 0 0
8 Mattia Rizzon
Lab To Hit 		358 89 60 40% 0 17 0 0
9 Federico D'Oria
Lab To Hit 		339 78 61 44% 1 16 0 0
10 Riccardo Del Boca
Pazzeschi 		317 109 33 23% 3 18 0 0
11 Donald Basso
Piccolo Club 		311 91 43 32% 1 13 1 0
12 Roberto Coletta
Sotomayor 		310 95 40 30% 0 18 0 0
13 Luca Fagherazzi
Genova Hit Ball 		309 123 21 15% 3 17 0 0
14 Daniele Agnello
Rdj 		303 90 41 31% 0 17 1 0
15 Riccardo Simini
Red Devils 		302 94 38 29% 0 18 0 0
16 Marco Bressello
Citmabun 		280 92 32 26% 2 18 0 0
17 Antonio De Rosa
Pazzeschi 		280 98 28 22% 1 17 0 0
18 Leonardo Cicogna
Piccolo Club 		262 83 32 28% 1 16 0 0
19 Davide Brunello
Evolution 		251 67 39 37% 3 17 0 0
20 Giuseppe Mirra
Pazzeschi 		246 72 34 32% 0 16 0 0
21 Raffaele Maurelli
Evolution 		242 76 30 28% 0 18 0 0
22 Gaspare Guarrato
Evolution 		242 91 20 18% 2 16 0 0
23 Andrea Belcastro
Red Devils 		239 97 15 13% 0 18 0 0
24 Filippo Rovai
Sotomayor 		236 94 16 15% 1 18 0 0
25 Antonio Mirco Santarsia
Red Devils 		229 65 33 34% 4 18 0 0
26 Marco De Salvo
Sotomayor 		229 80 23 22% 0 16 0 0
27 Marco Potenza
Lab To Hit 		227 64 33 34% 1 16 0 0
28 Mattia Vazzoler
Red Devils 		226 65 32 33% 1 17 0 0
29 Riccardo Marello
Rdj 		223 74 25 25% 0 16 0 0
30 Riccardo Damiano
Citmabun 		222 75 24 24% 1 18 0 0
31 Matteo La Tegola
Genova Hit Ball 		218 100 6 6% 5 17 0 0
32 Dario Ravera
Genova Hit Ball 		214 89 12 12% 0 16 0 0
33 Daniele Gennaro
Citmabun 		210 72 22 23% 0 16 0 0
34 Luca Siciliano
Genova Hit Ball 		189 81 9 10% 1 14 0 0
35 Simone Gabellini
Sotomayor 		186 81 8 9% 0 17 0 0
36 Stefano Calvo
Rdj 		184 59 22 27% 0 15 0 0
37 Maurizio Rattalino
Sunknights 		181 44 31 41% 1 10 0 0
38 Giacomo Garzaro
Citmabun 		181 65 17 21% 1 18 0 0
39 Danilo Sacchetto
Pazzeschi 		178 65 16 20% 2 17 0 0
40 Luca Ambrosino
Citmabun 		172 65 14 18% 2 18 1 0
41 Luca Cangialosi
Citmabun 		167 70 9 11% 4 17 0 0
42 Gabriele Spina
Rdj 		162 48 22 31% 0 17 0 0
43 Andrea Rigoni
Rdj 		162 57 16 22% 0 15 0 0
44 Alessandro Rigardo
Lab To Hit 		158 49 20 29% 3 16 1 0
45 Michele Messina
Red Devils 		158 55 16 23% 0 17 0 0
46 Sergio Fileccia
Pazzeschi 		155 58 13 18% 0 16 1 0
47 Giulio Naggi
Evolution 		146 64 6 9% 0 17 0 0
48 Alessio Casali
Red Devils 		145 44 19 30% 1 18 0 0
49 Enrico Demonte
Sotomayor 		143 64 5 7% 3 16 0 0
50 Andrea Joly
Piccolo Club 		141 60 7 10% 0 17 0 0
51 Alessio Petrosino
Sotomayor 		139 68 1 1% 1 17 0 0
52 Marco Antonio De Nichilo
Sunknights 		134 43 16 27% 0 11 0 0
53 Matteo Cipolletta
Piccolo Club 		126 57 4 7% 1 16 0 0
54 Andrea Suman
Red Devils 		118 53 4 7% 0 17 0 0
55 Davide Ciancio
Genova Hit Ball 		114 48 6 11% 1 16 0 0
56 Davide Roncaglione
Evolution 		100 41 6 13% 1 15 0 0
57 Alessandro Adami
Sunknights 		96 36 8 18% 1 14 2 0
58 Marco Barrasso
Rdj 		94 35 8 19% 3 15 0 0
59 Alessandro Verde
Lab To Hit 		94 35 8 19% 0 17 0 0
60 Fabrizio Gennaro
Citmabun 		93 42 3 7% 0 17 0 0
61 Maurizio Calassi
Pazzeschi 		90 39 4 9% 0 8 0 0
62 Dylan Dominino
Rdj 		82 29 8 22% 2 15 0 0
63 Federico Pistidda
Lab To Hit 		78 15 16 52% 0 11 0 0
64 Stefano Benedetto
Red Devils 		77 31 5 14% 0 12 0 0
65 Matteo Clara
Sunknights 		64 29 2 6% 1 16 1 0
66 Enrico Spagnolini
Sunknights 		59 25 3 11% 0 14 0 0
67 Riccardo Merlo
Genova Hit Ball 		51 21 3 13% 2 14 0 1
68 Giorgio Recalcati
Genova Hit Ball 		34 17 0 0 0 14 0 0
69 Saverio Cicciarella
Pazzeschi 		31 11 3 21% 0 4 0 0
70 Vittorio Di Giulio
Piccolo Club 		15 6 1 14% 0 4 0 0
71 Ludovico Avramidis
Pazzeschi 		0 0 0 0 0 3 0 0
72 Mirco Clausi
Evolution 		0 0 0 0 0 0 0 0
73 Federico Cuffaro
Evolution 		0 0 0 0 0 0 0 0
74 Roberto Riccio
Piccolo Club 		0 0 0 0 0 1 0 0
75 Marco Virgilio
Red Devils 		0 0 0 0 0 1 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 		0 0 0 0 0 1 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.63835310935974
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781150289.2666
            [end] => 1781150289.2669
            [time] => 0.00031304359436035
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1781150289.2694
            [end] => 1781150289.2697
            [time] => 0.00023603439331055
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1781150289.2698
            [end] => 1781150289.2701
            [time] => 0.00027203559875488
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '6' 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] => 1781150289.2702
            [end] => 1781150289.2733
            [time] => 0.0030539035797119
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2161,2162,2134,2153,2119,2188,2202,2138,2123,2185,2120,2193,2182,2146,2145,2192,2189,2133,2154,2118,2132,2200,2203,2130,2139,2166,2150,2204,2181,2127,2126,2170,2167,2186,2156,2196,2124,2176,2187,2174,2180,2149,2197,2160,2128,2206,2117,2198,2179,2164,2183,2143,2157,2168,2140,2165,2148,2191,2190,2144,2147,2163,2178,2199,2177,2155,2158,2175,2137,2184,2136,2159,2121,2195,2171,2122,2141,2125,2169,2142,2131,2129,2201,2151,2152,2173,2135,2205,2194,2172) order by id ASC
            [start] => 1781150289.2739
            [end] => 1781150289.2776
            [time] => 0.0037240982055664
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2161,2162,2134,2153,2119,2188,2202,2138,2123,2185,2120,2193,2182,2146,2145,2192,2189,2133,2154,2118,2132,2200,2203,2130,2139,2166,2150,2204,2181,2127,2126,2170,2167,2186,2156,2196,2124,2176,2187,2174,2180,2149,2197,2160,2128,2206,2117,2198,2179,2164,2183,2143,2157,2168,2140,2165,2148,2191,2190,2144,2147,2163,2178,2199,2177,2155,2158,2175,2137,2184,2136,2159,2121,2195,2171,2122,2141,2125,2169,2142,2131,2129,2201,2151,2152,2173,2135,2205,2194,2172)
            [start] => 1781150289.4551
            [end] => 1781150289.4698
            [time] => 0.014717817306519
        )

    [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 <= 1781150289 OR start >= 1781150289) AND (end >= 1781150289 OR end = 0) AND (start < 1781150289) ORDER BY name ASC
            [start] => 1781150289.5024
            [end] => 1781150289.5035
            [time] => 0.0011439323425293
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1781150289.5036
            [end] => 1781150289.5039
            [time] => 0.00026512145996094
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1781150289.5039
            [end] => 1781150289.5042
            [time] => 0.00025105476379395
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2161,2162,2134,2153,2119,2188,2202,2138,2123,2185,2120,2193,2182,2146,2145,2192,2189,2133,2154,2118,2132,2200,2203,2130,2139,2166,2150,2204,2181,2127,2126,2170,2167,2186,2156,2196,2124,2176,2187,2174,2180,2149,2197,2160,2128,2206,2117,2198,2179,2164,2183,2143,2157,2140,2168,2165,2148,2191,2190,2137,2144,2147,2163,2178,2199,2177,2155,2158,2175,2184,2136,2159,2121,2195,2172,2171,2122,2141,2125,2201,2169,2142,2131,2129,2151,2152,2173,2135,2205,2194) order by id ASC
            [start] => 1781150289.5079
            [end] => 1781150289.5115
            [time] => 0.0035791397094727
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1781150289.6887
            [end] => 1781150289.6891
            [time] => 0.00047183036804199
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1781150289.6907
            [end] => 1781150289.6909
            [time] => 0.00023412704467773
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1781150289.691
            [end] => 1781150289.6913
            [time] => 0.00023603439331055
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1781150289.6913
            [end] => 1781150289.6915
            [time] => 0.00021815299987793
        )

    [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 <= 1632059839 OR start >= 1632059839) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (2,16,38,17,18,19,20,21,1,22) ORDER BY lastname,firstname ASC
            [start] => 1781150289.6916
            [end] => 1781150289.6931
            [time] => 0.0015189647674561
        )

    [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 = '6') 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] => 1781150289.6936
            [end] => 1781150289.7088
            [time] => 0.01519513130188
        )

    [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 = '6')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1781150289.709
            [end] => 1781150290.0001
            [time] => 0.29104495048523
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1781150290.0012
            [end] => 1781150290.0015
            [time] => 0.00028395652770996
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1781150290.0016
            [end] => 1781150290.0019
            [time] => 0.00027990341186523
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1781150290.0019
            [end] => 1781150290.0021
            [time] => 0.00022292137145996
        )

    [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 <= 1632059839 OR start >= 1632059839) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (2,16,38,17,18,19,20,21,1,22) ORDER BY lastname,firstname ASC
            [start] => 1781150290.0022
            [end] => 1781150290.0033
            [time] => 0.0010879039764404
        )

    [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 = '6') 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] => 1781150290.0034
            [end] => 1781150290.019
            [time] => 0.015580892562866
        )

    [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 = '6')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1781150290.0191
            [end] => 1781150290.2939
            [time] => 0.27485609054565
        )

    [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 <= 1632059839 OR start >= 1632059839) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) ORDER BY lastname,firstname ASC
            [start] => 1781150290.2941
            [end] => 1781150290.2978
            [time] => 0.0037260055541992
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781150290.3007
            [end] => 1781150290.3011
            [time] => 0.00035405158996582
        )

    [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 <= 1781150290 OR start >= 1781150290) AND (end >= 1781150290 OR end = 0) AND (start < 1781150290) ORDER BY name ASC
            [start] => 1781150290.3012
            [end] => 1781150290.3022
            [time] => 0.0010221004486084
        )

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

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

)