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

Campionati: Campionato Eccellenza 2021/2022 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 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.45782208442688
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034109.941
            [end] => 1766034109.9412
            [time] => 0.00027894973754883
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1766034109.9434
            [end] => 1766034109.9436
            [time] => 0.00024294853210449
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1766034109.9437
            [end] => 1766034109.944
            [time] => 0.00024604797363281
        )

    [3] => 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] => 1766034109.9441
            [end] => 1766034109.947
            [time] => 0.0028820037841797
        )

    [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,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] => 1766034109.9476
            [end] => 1766034109.9505
            [time] => 0.0029618740081787
        )

    [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,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)
            [start] => 1766034110.0874
            [end] => 1766034110.1005
            [time] => 0.01311993598938
        )

    [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 <= 1766034110 OR start >= 1766034110) AND (end >= 1766034110 OR end = 0) AND (start < 1766034110) ORDER BY name ASC
            [start] => 1766034110.1251
            [end] => 1766034110.1261
            [time] => 0.00096392631530762
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1766034110.1262
            [end] => 1766034110.1264
            [time] => 0.00022602081298828
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1766034110.1265
            [end] => 1766034110.1268
            [time] => 0.00026798248291016
        )

    [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] => 1766034110.1269
            [end] => 1766034110.1297
            [time] => 0.0027949810028076
        )

    [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] => 1766034110.1303
            [end] => 1766034110.1332
            [time] => 0.0029149055480957
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1766034110.2702
            [end] => 1766034110.2707
            [time] => 0.00052499771118164
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1766034110.2721
            [end] => 1766034110.2724
            [time] => 0.00033307075500488
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1766034110.2725
            [end] => 1766034110.2728
            [time] => 0.00025796890258789
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1766034110.2728
            [end] => 1766034110.273
            [time] => 0.00021481513977051
        )

    [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] => 1766034110.2731
            [end] => 1766034110.2745
            [time] => 0.001370906829834
        )

    [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] => 1766034110.275
            [end] => 1766034110.2871
            [time] => 0.01216197013855
        )

    [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] => 1766034110.2874
            [end] => 1766034110.4891
            [time] => 0.20169591903687
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '6'
            [start] => 1766034110.4903
            [end] => 1766034110.4906
            [time] => 0.00028896331787109
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1766034110.4907
            [end] => 1766034110.491
            [time] => 0.00024104118347168
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '6'
            [start] => 1766034110.491
            [end] => 1766034110.4912
            [time] => 0.00019598007202148
        )

    [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] => 1766034110.4913
            [end] => 1766034110.4922
            [time] => 0.00090980529785156
        )

    [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] => 1766034110.4923
            [end] => 1766034110.5043
            [time] => 0.011970043182373
        )

    [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] => 1766034110.5044
            [end] => 1766034110.6991
            [time] => 0.19467902183533
        )

    [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] => 1766034110.6993
            [end] => 1766034110.7026
            [time] => 0.0033810138702393
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034110.7057
            [end] => 1766034110.7061
            [time] => 0.00033402442932129
        )

    [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 <= 1766034110 OR start >= 1766034110) AND (end >= 1766034110 OR end = 0) AND (start < 1766034110) ORDER BY name ASC
            [start] => 1766034110.7061
            [end] => 1766034110.7069
            [time] => 0.0007929801940918
        )

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

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

)