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

Campionati: Campionato Eccellenza 2021/2022 B1

  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 Guardians Chivasso 51 18 17 1 1571 1098 473
2 Dracarys Chivasso 38 18 12 6 1288 1045 243
3 Sporting Team Next Gen 38 18 13 5 1455 1140 315
4 Skoppiati 32 18 11 7 1426 1284 142
5 Pellegrini Venaria 27 18 9 9 1306 1215 91
6 Lighting Bugs 26 18 9 9 1283 1267 16
7 Decepticon 24 18 8 10 1059 1177 -118
8 Hit Bulls 19 18 6 12 1315 1454 -139
9 Hitbusters 9 18 3 15 981 1429 -448
10 Black Knights 6 18 2 16 1131 1706 -575
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 Riccardo Pajno Ferrara
Sporting Team Next Gen 		557 178 67 27% 1 17 0 0
2 Gaetano Dinatale
Sporting Team Next Gen 		517 215 29 12% 1 18 0 0
3 Gabriel Alessandro Delgrosso
Black Knights 		508 110 96 47% 1 17 0 0
4 Gaetano Rendine
Dracarys Chivasso 		435 165 35 18% 1 18 1 0
5 Marco Broggini
Guardians Chivasso 		431 154 41 21% 2 18 0 0
6 Gabriele Barone
Pellegrini Venaria 		324 141 14 9% 1 16 0 0
7 Matteo Bercan
Skoppiati 		317 106 35 25% 2 12 0 0
8 Rosso Paolo
Guardians Chivasso 		311 88 45 34% 4 18 0 0
9 Alberto Gabriolo
Hit Bulls 		309 93 41 31% 3 18 0 0
10 Giovanni Marsico
Skoppiati 		302 97 36 27% 1 18 0 0
11 Paolo Gazzola
Black Knights 		301 83 45 35% 1 18 0 0
12 Davide Barboni
Lighting Bugs 		289 95 33 26% 3 17 0 0
13 Davide Gatti
Lighting Bugs 		283 89 35 28% 1 18 0 0
14 Benito Manuel Marino
Guardians Chivasso 		282 87 36 29% 1 18 0 0
15 Alessio Rimicci
Lighting Bugs 		282 99 28 22% 3 17 0 0
16 Lennin Jarek Garcia
Skoppiati 		279 105 23 18% 0 17 1 0
17 Domenico Pirozzolo
Pellegrini Venaria 		277 125 9 7% 4 18 0 0
18 Luca Maria Mercurio
Hitbusters 		244 83 26 24% 2 18 0 0
19 Salvatore Lo Monaco
Decepticon 		240 78 28 26% 0 14 1 0
20 Manuel Spatafora
Dracarys Chivasso 		235 113 3 3% 1 16 0 0
21 Marcello Saporito
Dracarys Chivasso 		225 93 13 12% 1 17 1 0
22 Riccardo Sacchetto
Hit Bulls 		218 82 18 18% 1 12 0 0
23 Leonardo Ramirez
Decepticon 		212 82 16 16% 3 18 1 0
24 Angelo D'Alessandra
Guardians Chivasso 		207 99 3 3% 3 18 0 0
25 Nicolò Bonincontro
Hit Bulls 		203 79 15 16% 2 18 0 0
26 Emilio Bertello
Hit Bulls 		203 82 13 14% 1 14 0 0
27 Federico Sisci
Pellegrini Venaria 		196 89 6 6% 1 14 0 0
28 Riccardo Ajassa
Hitbusters 		185 67 17 20% 4 16 1 0
29 Alessandro Caivano
Hitbusters 		175 80 5 6% 0 17 0 0
30 Luca Dragna
Pellegrini Venaria 		175 83 3 3% 1 17 0 0
31 Lorenzo Fontana
Skoppiati 		174 57 20 26% 5 17 3 0
32 Francesco Dughera
Guardians Chivasso 		173 73 9 11% 1 18 0 0
33 Federico Suppo
Skoppiati 		172 65 14 18% 3 14 1 0
34 Alberto Casalegno
Pellegrini Venaria 		167 76 5 6% 0 13 0 0
35 Davide Baldus
Dracarys Chivasso 		165 75 5 6% 1 18 1 0
36 Gianluca Sabatino
Lighting Bugs 		155 52 17 25% 3 16 0 0
37 Davide Centin
Decepticon 		154 53 16 23% 1 14 0 0
38 Federico Tibaldi
Hit Bulls 		141 54 11 17% 2 18 0 0
39 Sergio Danese
Decepticon 		140 55 10 15% 1 17 0 0
40 Ivano Reato
Dracarys Chivasso 		134 67 0 0 3 17 0 0
41 Marco Schiaroli
Guardians Chivasso 		123 33 19 37% 0 7 1 0
42 Matteo Barberis
Sporting Team Next Gen 		119 58 1 2% 1 13 0 0
43 Kevin Calvo
Hit Bulls 		102 33 12 27% 1 10 0 0
44 Carlo Del console
Sporting Team Next Gen 		100 44 4 8% 0 16 0 0
45 Yari Tumiatti
Black Knights 		99 21 19 48% 5 14 0 0
46 Luca Cavaglià
Decepticon 		97 35 9 20% 0 10 0 0
47 Andrea Crovagna
Lighting Bugs 		96 33 10 23% 4 18 2 0
48 Fabrizio Olivieri
Lighting Bugs 		96 33 10 23% 1 16 0 0
49 Andrea Garzena
Hitbusters 		93 39 5 11% 1 8 0 0
50 Simone Guglielmetto
Decepticon 		90 36 6 14% 1 15 0 0
51 Gabriele Salerno
Hit Bulls 		90 36 6 14% 2 10 1 0
52 Alessio Marte
Skoppiati 		87 33 7 18% 0 7 0 0
53 Antonio D'Elicio
Dracarys Chivasso 		87 42 1 2% 1 15 0 0
54 Riccardo Gouthier
Skoppiati 		86 31 8 21% 2 14 1 0
55 Gaetano De Vaire
Black Knights 		85 29 9 24% 1 14 0 0
56 Dejan Brilli
Hitbusters 		81 30 7 19% 0 5 0 0
57 Gianfranco Brozzetti
Lighting Bugs 		71 22 9 29% 0 7 0 0
58 Federico Zoccarato
Pellegrini Venaria 		70 35 0 0 3 17 0 0
59 Mattia Rivello
Black Knights 		45 9 9 50% 3 9 2 1
60 Adriano Paribello Grasso
Guardians Chivasso 		32 16 0 0 0 14 0 0
61 Vincenzo Padula
Sporting Team Next Gen 		26 13 0 0 0 12 0 0
62 Carlo Palamini
Hitbusters 		26 13 0 0 1 6 0 0
63 Andrea Pellegrino
Pellegrini Venaria 		22 11 0 0 1 3 0 0
64 Gabriele Cappero
Pellegrini Venaria 		8 4 0 0 1 9 0 0
65 Christian Alescio
Pellegrini Venaria 		4 2 0 0 0 10 0 0
66 Fabrizio Botta
Pellegrini Venaria 		2 1 0 0 0 3 0 0
67 Danilo Blanco
Black Knights 		0 0 0 0 0 0 0 0
68 Federico Gennaro
Guardians Chivasso 		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 Ilaria Mezzatesta
Sporting Team Next Gen 		124 59 2 3% 1 18 0 0
2 Federica Nardacchione
Hitbusters 		111 54 1 2% 0 17 4 0
3 Lucrezia Principato
Decepticon 		68 28 4 13% 0 16 1 0
4 Noemi Castelluccio
Hitbusters 		56 28 0 0 1 17 0 0
5 Barbara Tombolato
Pellegrini Venaria 		52 26 0 0 1 16 0 0
6 Mara Ferraris
Black Knights 		49 17 5 23% 2 18 0 0
7 Adina Catalina Ghimpu
Decepticon 		45 21 1 5% 0 12 0 0
8 Ana-Roberta Stroescu
Hit Bulls 		42 15 4 21% 0 16 0 0
9 Cristina Vaudagna
Black Knights 		29 13 1 7% 1 14 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.44515466690063
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034116.943
            [end] => 1766034116.9432
            [time] => 0.00022697448730469
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '2'
            [start] => 1766034116.9455
            [end] => 1766034116.9458
            [time] => 0.00031304359436035
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '2'
            [start] => 1766034116.946
            [end] => 1766034116.9462
            [time] => 0.00027585029602051
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (1906,1905,1923,1883,1925,1943,1966,1914,1889,1948,1926,1927,1952,1924,1908,1940,1885,1941,1909,1955,1884,1932,1912,1958,1931,1890,1945,1938,1937,1891,1901,1915,1962,1947,1967,1961,1965,1899,1919,1894,1918,1949,1956,1933,1942,1951,1968,1950,1970,1928,1921,1934,1898,1959,1903,1881,1882,1953,1969,1907,1895,1930,1896,1954,1910,1957,1886,1913,1887,1929,1893,1935,1900,1892,1936,1946,1917,1902,1922,1960,1916,1939,1964,1920,1944,1888,1963,1897,1904,1911) order by id ASC
            [start] => 1766034116.9499
            [end] => 1766034116.953
            [time] => 0.003101110458374
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (1906,1905,1923,1883,1925,1943,1966,1914,1889,1948,1926,1927,1952,1924,1908,1940,1885,1941,1909,1955,1884,1932,1912,1958,1931,1890,1945,1938,1937,1891,1901,1915,1962,1947,1967,1961,1965,1899,1919,1894,1918,1949,1956,1933,1942,1951,1968,1950,1970,1928,1921,1934,1898,1959,1903,1881,1882,1953,1969,1907,1895,1930,1896,1954,1910,1957,1886,1913,1887,1929,1893,1935,1900,1892,1936,1946,1917,1902,1922,1960,1916,1939,1964,1920,1944,1888,1963,1897,1904,1911)
            [start] => 1766034117.0893
            [end] => 1766034117.1029
            [time] => 0.01353907585144
        )

    [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 <= 1766034117 OR start >= 1766034117) AND (end >= 1766034117 OR end = 0) AND (start < 1766034117) ORDER BY name ASC
            [start] => 1766034117.1273
            [end] => 1766034117.1283
            [time] => 0.00095415115356445
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '2'
            [start] => 1766034117.1284
            [end] => 1766034117.1285
            [time] => 0.00018501281738281
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '2'
            [start] => 1766034117.1287
            [end] => 1766034117.1289
            [time] => 0.00022792816162109
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (1906,1905,1923,1883,1925,1943,1966,1914,1889,1948,1926,1927,1952,1924,1908,1940,1885,1941,1909,1955,1884,1932,1912,1958,1931,1890,1945,1938,1937,1891,1901,1915,1962,1947,1967,1961,1965,1899,1919,1894,1918,1949,1956,1933,1942,1951,1968,1950,1970,1928,1921,1934,1898,1959,1903,1881,1882,1953,1969,1907,1895,1930,1896,1954,1910,1957,1886,1913,1887,1929,1893,1935,1900,1892,1936,1946,1917,1902,1922,1960,1916,1939,1964,1920,1944,1888,1963,1897,1904,1911) order by id ASC
            [start] => 1766034117.1325
            [end] => 1766034117.1355
            [time] => 0.0029959678649902
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '2'
            [start] => 1766034117.2695
            [end] => 1766034117.2699
            [time] => 0.00040388107299805
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '2'
            [start] => 1766034117.2713
            [end] => 1766034117.2715
            [time] => 0.00021195411682129
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '2'
            [start] => 1766034117.2716
            [end] => 1766034117.2719
            [time] => 0.00023412704467773
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '2'
            [start] => 1766034117.2719
            [end] => 1766034117.2721
            [time] => 0.00020098686218262
        )

    [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 <= 1631884471 OR start >= 1631884471) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (23,5,7,8,12,13,15,14,11,4) ORDER BY lastname,firstname ASC
            [start] => 1766034117.2722
            [end] => 1766034117.2735
            [time] => 0.001331090927124
        )

    [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 = '2') 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] => 1766034117.274
            [end] => 1766034117.286
            [time] => 0.012031078338623
        )

    [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 = '2')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034117.2863
            [end] => 1766034117.5023
            [time] => 0.21608901023865
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '2'
            [start] => 1766034117.5034
            [end] => 1766034117.5037
            [time] => 0.00036001205444336
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '2'
            [start] => 1766034117.5039
            [end] => 1766034117.5041
            [time] => 0.00025105476379395
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '2'
            [start] => 1766034117.5041
            [end] => 1766034117.5043
            [time] => 0.00019192695617676
        )

    [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 <= 1631884471 OR start >= 1631884471) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) AND team_id in (23,5,7,8,12,13,15,14,11,4) ORDER BY lastname,firstname ASC
            [start] => 1766034117.5044
            [end] => 1766034117.5054
            [time] => 0.00098991394042969
        )

    [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 = '2') 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] => 1766034117.5056
            [end] => 1766034117.5175
            [time] => 0.011859893798828
        )

    [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 = '2')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034117.5175
            [end] => 1766034117.6851
            [time] => 0.16756105422974
        )

    [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 <= 1631884471 OR start >= 1631884471) AND (end >= 1664488800 OR end = 0) AND (start < 1664488800) ORDER BY lastname,firstname ASC
            [start] => 1766034117.6854
            [end] => 1766034117.6888
            [time] => 0.0034489631652832
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034117.6919
            [end] => 1766034117.6922
            [time] => 0.00030303001403809
        )

    [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 <= 1766034117 OR start >= 1766034117) AND (end >= 1766034117 OR end = 0) AND (start < 1766034117) ORDER BY name ASC
            [start] => 1766034117.6923
            [end] => 1766034117.693
            [time] => 0.00077199935913086
        )

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

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

)