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

Campionati: Campionato Eccellenza 2021/2022 A2

  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 Torino Warriors 46 18 15 3 1800 1282 518
2 Sporting Team 36 18 12 6 1547 1434 113
3 Flamurtari 36 18 12 6 1386 1345 41
4 Igadan 30 18 10 8 1412 1310 102
5 All Blacks 30 18 10 8 1278 1297 -19
6 Gunners 22 18 8 10 1428 1419 9
7 Hammers 21 18 7 11 1297 1389 -92
8 Together Hit 19 18 6 12 1365 1623 -258
9 Sheet 15 18 5 13 1324 1462 -138
10 Bioghettyson 15 18 5 13 1102 1378 -276
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 		686 187 104 36% 0 15 0 0
2 Gabriele Gazzetta
Together Hit 		434 121 64 35% 2 18 1 0
3 Giovanni Marino
Hammers 		434 208 6 3% 2 17 1 0
4 Roberto Carrer
Hammers 		409 116 59 34% 2 15 0 0
5 Davide Castaldo
Gunners 		390 114 54 32% 1 18 0 0
6 Riccardo De Marco
Torino Warriors 		385 113 53 32% 0 17 0 0
7 Alberto Dolfin
Sporting Team 		382 89 68 43% 1 12 1 0
8 Pietro Evangelista
Flamurtari 		377 13 117 90% 2 12 0 0
9 Marco Bernocco
Gunners 		376 149 26 15% 0 18 0 0
10 Matteo Turigliatto
Flamurtari 		375 147 27 16% 2 18 0 0
11 Marcello Bacchini
All Blacks 		340 119 34 22% 1 18 0 0
12 Federico Solinas
Torino Warriors 		321 135 17 11% 2 16 0 0
13 Gianmarco Fogliato
Torino Warriors 		307 131 15 10% 1 16 0 0
14 Alessandro Bosa
All Blacks 		299 94 37 28% 3 15 0 0
15 Mauro Pompili
Igadan 		296 109 26 19% 0 17 0 0
16 Andrea Lavalle
Sheet 		291 105 27 20% 0 17 0 0
17 Davide Salvaggio
Sheet 		283 83 39 32% 1 17 0 0
18 Francesco De Gaetano
Together Hit 		280 110 20 15% 1 18 0 0
19 Daniele Brunetto
Gunners 		271 77 39 34% 2 18 0 0
20 Andrea De Blasio
Bioghettyson 		258 87 28 24% 1 18 1 0
21 Marco Gamba
Torino Warriors 		257 118 7 6% 0 18 0 0
22 Alberto Maggia
Igadan 		242 88 22 20% 1 18 0 0
23 Alessandro Maniscalco
Igadan 		239 97 15 13% 2 18 0 0
24 Gianluca Zanetti
Igadan 		231 93 15 14% 2 16 0 0
25 Jacopo Sanfilippo
Torino Warriors 		230 70 30 30% 0 15 0 0
26 Alessandro Varetto
All Blacks 		225 63 33 34% 2 14 0 0
27 Franco Giambanco
Sporting Team 		225 84 19 18% 2 18 1 0
28 Andrea Vitale
Bioghettyson 		224 64 32 33% 1 18 1 0
29 Filippo Venturini
Sheet 		211 59 31 34% 0 17 1 0
30 Giuseppe Armanno
Igadan 		209 79 17 18% 0 17 0 0
31 Enrico Testa
Together Hit 		204 66 24 27% 1 12 0 0
32 Enrico Salari
Flamurtari 		200 82 12 13% 3 16 1 0
33 Stefano Benedetti
Sheet 		192 63 22 26% 0 13 0 0
34 Lorenzo Novara
Hammers 		191 76 13 15% 1 15 1 0
35 Carlo Pangallo
Sheet 		188 64 20 24% 2 16 0 0
36 Enrico Truffa
Igadan 		186 57 24 30% 1 17 0 0
37 Ivan Russo
Hammers 		182 85 4 4% 3 17 0 0
38 Davide Giordano
Together Hit 		166 59 16 21% 0 11 2 0
39 Alessandro Romano
Flamurtari 		164 46 24 34% 0 13 1 0
40 Fabio Ingrassia
Bioghettyson 		164 70 8 10% 0 17 1 0
41 Francesco Caligaris
Torino Warriors 		150 54 14 21% 3 14 0 0
42 Fabrizio Alberto
Together Hit 		136 50 12 19% 1 18 1 0
43 Enrico Brunello
Gunners 		125 49 9 16% 0 16 0 0
44 Massimiliano Casigli
Sporting Team 		120 48 8 14% 0 18 1 0
45 Daniele Managò
Flamurtari 		120 51 6 11% 0 17 2 0
46 Antonio Marincola
Flamurtari 		114 39 12 24% 2 12 0 0
47 Andrea Tapella
Bioghettyson 		110 40 10 20% 0 17 0 0
48 Gianluca Zingarelli
All Blacks 		109 38 11 22% 1 14 0 0
49 Matteo Macario Cot
Torino Warriors 		109 47 5 10% 2 8 0 0
50 Gianluca Varetto
All Blacks 		107 49 3 6% 1 18 0 0
51 Diego Leonardi
All Blacks 		106 41 8 16% 0 18 3 0
52 Stefano Falvo
Sporting Team 		99 45 3 6% 2 17 0 0
53 Daniele Demarchi
Sheet 		88 29 10 26% 1 17 1 0
54 Francesco Mongiovì
Bioghettyson 		88 38 4 10% 3 18 1 0
55 Tommaso Baudi Di Vesme Gabutti
Bioghettyson 		85 29 9 24% 0 17 2 0
56 Simone Gasbarroni
Bioghettyson 		83 25 11 31% 0 11 0 0
57 Stefano Truzzi
Bioghettyson 		81 27 9 25% 1 9 0 0
58 Andrea Murtas
All Blacks 		78 30 6 17% 0 13 0 0
59 Giacomo Guarrato
Gunners 		75 30 5 14% 2 12 0 0
60 Giuseppe Sceusi
Gunners 		75 36 1 3% 2 18 0 0
61 Massimiliano Taglianetti
Sheet 		51 18 5 22% 0 7 0 0
62 Emanuele Massè
Together Hit 		34 14 2 13% 0 4 1 0
63 Stefano Borelli
Torino Warriors 		32 16 0 0 0 5 0 0
64 Daniele Morano
Hammers 		31 14 1 7% 2 9 0 0
65 Andrea Petrilli
Sporting Team 		24 12 0 0 1 8 0 0
66 Fabrizio Caddeo
Flamurtari 		18 9 0 0 0 9 2 0
67 Marco Zanatta
Flamurtari 		12 6 0 0 2 15 0 0
68 Davide Senatore
Sheet 		10 2 2 50% 0 3 0 0
69 Stefano Incorvaia
All Blacks 		8 4 0 0 0 5 0 0
70 Francesco Bruno
Sporting Team 		6 3 0 0 1 17 0 0
71 Sergio Laganà
Together Hit 		4 2 0 0 0 3 0 0
72 Gabriele Argirò
Together Hit 		0 0 0 0 0 1 0 0
73 Gabriele Lepore
Bioghettyson 		0 0 0 0 0 1 0 0
74 Stefano Mazzilli
Together Hit 		0 0 0 0 0 0 0 0
75 Davide Pivato
Together Hit 		0 0 0 0 0 0 0 0
76 Marco Salusso
Sheet 		0 0 0 0 0 0 0 0
77 Stefano Santangelo
Together Hit 		0 0 0 0 0 0 0 0
78 Giorgio Spinosa
Hammers 		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 Alessia Scardicchio
Gunners 		106 53 0 0 1 18 0 0
2 Carlotta Amodeo
Together Hit 		99 36 9 20% 0 18 0 0
3 Sabrina Capitolo
Hammers 		32 16 0 0 2 17 0 0
4 Rebecca Aurigemma
Hammers 		10 5 0 0 0 14 0 0
5 Federica Funnone
Flamurtari 		4 2 0 0 1 18 0 0
6 Cristina Rijillo
Sheet 		0 0 0 0 0 4 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.42767691612244
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034118.8502
            [end] => 1766034118.8505
            [time] => 0.00032496452331543
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '5'
            [start] => 1766034118.8526
            [end] => 1766034118.8529
            [time] => 0.00030398368835449
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '5'
            [start] => 1766034118.8531
            [end] => 1766034118.8533
            [time] => 0.00023818016052246
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2114,2037,2096,2035,2093,2086,2060,2104,2097,2061,2027,2049,2116,2091,2044,2070,2056,2063,2099,2092,2033,2034,2036,2062,2065,2064,2030,2088,2050,2112,2042,2076,2073,2045,2029,2057,2055,2084,2038,2103,2068,2053,2040,2077,2066,2069,2051,2080,2048,2082,2041,2059,2052,2106,2105,2072,2089,2071,2094,2046,2108,2101,2047,2054,2115,2110,2081,2079,2078,2107,2043,2075,2109,2095,2067,2087,2090,2031,2028,2074,2039,2100,2102,2058,2083,2098,2111,2085,2032,2113) order by id ASC
            [start] => 1766034118.8569
            [end] => 1766034118.86
            [time] => 0.0030241012573242
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2114,2037,2096,2035,2093,2086,2060,2104,2097,2061,2027,2049,2116,2091,2044,2070,2056,2063,2099,2092,2033,2034,2036,2062,2065,2064,2030,2088,2050,2112,2042,2076,2073,2045,2029,2057,2055,2084,2038,2103,2068,2053,2040,2077,2066,2069,2051,2080,2048,2082,2041,2059,2052,2106,2105,2072,2089,2071,2094,2046,2108,2101,2047,2054,2115,2110,2081,2079,2078,2107,2043,2075,2109,2095,2067,2087,2090,2031,2028,2074,2039,2100,2102,2058,2083,2098,2111,2085,2032,2113)
            [start] => 1766034118.9949
            [end] => 1766034119.0083
            [time] => 0.01334285736084
        )

    [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 <= 1766034119 OR start >= 1766034119) AND (end >= 1766034119 OR end = 0) AND (start < 1766034119) ORDER BY name ASC
            [start] => 1766034119.0325
            [end] => 1766034119.0335
            [time] => 0.00094103813171387
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '5'
            [start] => 1766034119.0335
            [end] => 1766034119.0338
            [time] => 0.00026106834411621
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '5'
            [start] => 1766034119.0339
            [end] => 1766034119.0342
            [time] => 0.00025701522827148
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2114,2037,2096,2035,2093,2086,2060,2104,2097,2061,2027,2049,2116,2091,2044,2070,2056,2063,2099,2092,2033,2034,2036,2062,2065,2064,2030,2088,2050,2112,2042,2076,2073,2045,2029,2057,2055,2084,2038,2103,2068,2053,2040,2077,2066,2069,2051,2080,2048,2082,2041,2059,2052,2106,2105,2072,2089,2071,2094,2046,2108,2101,2047,2054,2115,2110,2081,2079,2078,2107,2043,2075,2109,2095,2067,2087,2090,2031,2028,2074,2039,2100,2102,2058,2083,2098,2111,2085,2032,2113) order by id ASC
            [start] => 1766034119.0377
            [end] => 1766034119.0407
            [time] => 0.0029289722442627
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '5'
            [start] => 1766034119.1753
            [end] => 1766034119.1758
            [time] => 0.00047588348388672
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '5'
            [start] => 1766034119.1775
            [end] => 1766034119.1778
            [time] => 0.00031399726867676
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '5'
            [start] => 1766034119.178
            [end] => 1766034119.1782
            [time] => 0.00026917457580566
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '5'
            [start] => 1766034119.1782
            [end] => 1766034119.1785
            [time] => 0.00021505355834961
        )

    [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 <= 1632055282 OR start >= 1632055282) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (31,36,37,30,34,28,32,35,29,33) ORDER BY lastname,firstname ASC
            [start] => 1766034119.1786
            [end] => 1766034119.1799
            [time] => 0.001352071762085
        )

    [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 = '5') 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] => 1766034119.1804
            [end] => 1766034119.1925
            [time] => 0.012148141860962
        )

    [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 = '5')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034119.1928
            [end] => 1766034119.3935
            [time] => 0.20068383216858
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '5'
            [start] => 1766034119.3946
            [end] => 1766034119.395
            [time] => 0.0003359317779541
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '5'
            [start] => 1766034119.3951
            [end] => 1766034119.3954
            [time] => 0.00026607513427734
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '5'
            [start] => 1766034119.3954
            [end] => 1766034119.3956
            [time] => 0.00027012825012207
        )

    [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 <= 1632055282 OR start >= 1632055282) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (31,36,37,30,34,28,32,35,29,33) ORDER BY lastname,firstname ASC
            [start] => 1766034119.3958
            [end] => 1766034119.3967
            [time] => 0.00098419189453125
        )

    [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 = '5') 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] => 1766034119.3969
            [end] => 1766034119.409
            [time] => 0.012089014053345
        )

    [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 = '5')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034119.4091
            [end] => 1766034119.5744
            [time] => 0.16535019874573
        )

    [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 <= 1632055282 OR start >= 1632055282) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) ORDER BY lastname,firstname ASC
            [start] => 1766034119.5747
            [end] => 1766034119.5779
            [time] => 0.0031900405883789
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034119.5806
            [end] => 1766034119.581
            [time] => 0.00031399726867676
        )

    [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 <= 1766034119 OR start >= 1766034119) AND (end >= 1766034119 OR end = 0) AND (start < 1766034119) ORDER BY name ASC
            [start] => 1766034119.581
            [end] => 1766034119.5818
            [time] => 0.00080013275146484
        )

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

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

)