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

Campionati: Campionato Eccellenza 2022/2023 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 Skoppiati 48 18 16 2 1950 1358 592
2 Pellegrini Venaria 42 18 14 4 1869 1498 371
3 Bioghettyson 42 18 14 4 1531 1376 155
4 Decepticon 35 18 12 6 1606 1527 79
5 Dracarys Chivasso 33 18 11 7 1610 1448 162
6 Hit Bulls 24 18 8 10 1669 1661 8
7 Hocheti Pokety 21 18 7 11 1568 1551 17
8 Rising Titans 19 18 6 12 1455 1555 -100
9 Hitbusters 3 18 1 17 1250 1821 -571
10 Together Hit 3 18 1 17 1092 1805 -713
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 Gabriele Barone
Pellegrini Venaria 		634 209 72 26% 2 18 0 0
2 Riccardo Francabandiera
Skoppiati 		633 225 61 21% 0 18 0 0
3 Giuseppe Armanno
Decepticon 		442 119 68 36% 2 17 0 0
4 Andrea Vecchiattini
Rising Titans 		430 101 76 43% 2 18 0 0
5 Alberto Gabriolo
Hit Bulls 		366 111 48 30% 4 18 0 0
6 Kevin Calvo
Hit Bulls 		364 125 38 23% 2 18 0 0
7 Lennin Jarek Garcia
Skoppiati 		363 114 45 28% 2 18 0 0
8 Enrico Testa
Decepticon 		359 103 51 33% 2 14 0 0
9 Emilio Bertello
Hit Bulls 		358 119 40 25% 2 15 0 0
10 Simone De Meo
Hocheti Pokety 		354 135 28 17% 1 16 0 0
11 Ramon Rutigliano
Hocheti Pokety 		330 123 28 19% 0 15 0 0
12 Federico Sisci
Pellegrini Venaria 		328 128 24 16% 1 18 0 0
13 Marcello Saporito
Dracarys Chivasso 		327 129 23 15% 2 18 1 0
14 Giovanni Marsico
Skoppiati 		324 108 36 25% 1 18 0 0
15 Luca Maria Mercurio
Hitbusters 		313 92 43 32% 3 18 0 0
16 Gaetano Rendine
Dracarys Chivasso 		307 110 29 21% 0 14 0 0
17 Andrea Merlo
Dracarys Chivasso 		301 95 37 28% 1 17 1 0
18 Nicolò Bonincontro
Hit Bulls 		296 106 28 21% 1 16 0 0
19 Ivan Biletta
Rising Titans 		294 99 32 24% 1 17 0 0
20 Manuel Spatafora
Dracarys Chivasso 		292 125 14 10% 0 17 0 0
21 Andrea De Blasio
Bioghettyson 		290 115 20 15% 1 15 1 0
22 Andrea Giannitti
Rising Titans 		270 99 24 20% 4 18 0 0
23 Fabio Ingrassia
Bioghettyson 		266 124 6 5% 0 18 1 0
24 Domenico Pirozzolo
Pellegrini Venaria 		261 99 21 18% 1 18 0 0
25 Andrea Crovagna
Together Hit 		250 104 14 12% 0 18 0 0
26 Riccardo Toppan
Decepticon 		247 65 39 38% 0 18 0 0
27 Luca Dragna
Pellegrini Venaria 		234 96 14 13% 2 17 0 0
28 Ivan Dastrù
Hocheti Pokety 		233 79 25 24% 2 18 0 0
29 Federico Suppo
Skoppiati 		227 94 13 12% 2 17 0 0
30 Matteo Bercan
Skoppiati 		224 76 24 24% 0 12 0 0
31 Federico Tibaldi
Hit Bulls 		223 68 29 30% 2 16 0 0
32 Andrea Vitale
Bioghettyson 		218 88 14 14% 0 18 1 0
33 Gianluca Sabatino
Together Hit 		215 73 23 24% 2 17 0 0
34 Riccardo Ajassa
Hitbusters 		213 72 23 24% 1 16 0 0
35 Simone Poser
Hocheti Pokety 		212 70 24 26% 3 16 0 0
36 Federico Perno
Bioghettyson 		197 88 7 7% 0 13 5 0
37 Luca Cavaglià
Decepticon 		196 53 30 36% 4 15 0 0
38 Matteo Paccagnini
Rising Titans 		186 66 18 21% 1 17 1 0
39 Andrea Garzena
Hitbusters 		184 56 24 30% 0 13 0 0
40 Stefano Mazzilli
Together Hit 		183 60 21 26% 1 18 1 0
41 Davide Locatelli
Hocheti Pokety 		183 75 11 13% 1 11 1 0
42 Alessandro Caivano
Hitbusters 		178 77 8 9% 1 14 0 0
43 Gabriele Lepore
Bioghettyson 		169 44 27 38% 1 17 0 0
44 Daniele Ursida
Decepticon 		165 48 23 32% 0 14 0 0
45 Francesco Cissello
Together Hit 		164 67 10 13% 1 13 0 0
46 Vincenzo De Felice
Rising Titans 		159 78 1 1% 1 17 0 0
47 Daniele Tessarin
Hitbusters 		157 62 11 15% 5 18 0 0
48 Luca Curti
Pellegrini Venaria 		155 61 11 15% 0 15 1 0
49 Alberto Casalegno
Pellegrini Venaria 		153 54 15 22% 1 10 0 0
50 Francesco Mongiovì
Bioghettyson 		138 60 6 9% 1 17 0 0
51 Antonio D'Elicio
Dracarys Chivasso 		134 64 2 3% 0 15 0 0
52 Lorenzo Fontana
Skoppiati 		127 32 21 40% 0 13 0 0
53 Davide Baldus
Dracarys Chivasso 		123 54 5 8% 0 16 0 0
54 Ivano Reato
Dracarys Chivasso 		118 56 2 3% 5 15 1 0
55 Sonnj Dall'ara
Rising Titans 		111 36 13 27% 1 12 0 0
56 Alberto Racco
Hocheti Pokety 		106 32 14 30% 0 7 0 0
57 Sergio Laganà
Together Hit 		106 47 4 8% 3 17 1 0
58 Simone Guglielmetto
Decepticon 		105 30 15 33% 0 18 0 0
59 Edoardo Francesco Stefanelli
Hocheti Pokety 		103 41 7 15% 0 12 0 0
60 Andrea Tapella
Bioghettyson 		101 43 5 10% 0 18 0 0
61 Tommaso Baudi Di Vesme Gabutti
Bioghettyson 		99 45 3 6% 2 17 0 0
62 Gabriele Argirò
Together Hit 		88 32 8 20% 3 17 0 0
63 Alessio Marte
Skoppiati 		46 11 8 42% 0 4 0 0
64 Stefano Lavino
Decepticon 		46 20 2 9% 1 16 0 0
65 Simone Gasbarroni
Bioghettyson 		43 20 1 5% 1 11 0 0
66 Daniele Barbato
Decepticon 		33 15 1 6% 1 18 0 0
67 Thomas Rovetto
Hocheti Pokety 		32 16 0 0 1 11 0 0
68 Riccardo Gouthier
Skoppiati 		0 0 0 0 0 0 0 0
69 Riccardo Sacchetto
Hit Bulls 		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 Federica Nardacchione
Hitbusters 		133 62 3 5% 1 16 3 0
2 Barbara Tombolato
Pellegrini Venaria 		95 46 1 2% 1 16 0 0
3 Lucrezia Principato
Together Hit 		65 28 3 10% 1 15 9 0
4 Noemi Castelluccio
Hitbusters 		64 32 0 0 0 15 0 0
5 Ana-Roberta Stroescu
Hit Bulls 		55 17 7 29% 0 13 0 0
6 Rebecca Aurigemma
Together Hit 		14 7 0 0 0 10 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.43425178527832
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034100.471
            [end] => 1766034100.4713
            [time] => 0.00032210350036621
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1766034100.4734
            [end] => 1766034100.4737
            [time] => 0.00025606155395508
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1766034100.4738
            [end] => 1766034100.4741
            [time] => 0.00028204917907715
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2529,2532,2528,2530,2531,2533,2535,2536,2534,2537,2541,2538,2540,2542,2539,2544,2546,2547,2545,2543,2549,2552,2550,2548,2551,2556,2557,2553,2554,2555,2559,2560,2561,2562,2558,2563,2564,2567,2565,2566,2571,2568,2572,2569,2570,2573,2575,2574,2577,2576,2581,2579,2582,2578,2580,2583,2586,2585,2587,2584,2589,2591,2592,2588,2590,2593,2595,2597,2594,2596,2599,2601,2598,2600,2602,2605,2604,2603,2606,2607,2609,2610,2612,2608,2611,2613,2617,2614,2615,2616) order by id ASC
            [start] => 1766034100.4776
            [end] => 1766034100.4806
            [time] => 0.0029630661010742
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2529,2532,2528,2530,2531,2533,2535,2536,2534,2537,2541,2538,2540,2542,2539,2544,2546,2547,2545,2543,2549,2552,2550,2548,2551,2556,2557,2553,2554,2555,2559,2560,2561,2562,2558,2563,2564,2567,2565,2566,2571,2568,2572,2569,2570,2573,2575,2574,2577,2576,2581,2579,2582,2578,2580,2583,2586,2585,2587,2584,2589,2591,2592,2588,2590,2593,2595,2597,2594,2596,2599,2601,2598,2600,2602,2605,2604,2603,2606,2607,2609,2610,2612,2608,2611,2613,2617,2614,2615,2616)
            [start] => 1766034100.6189
            [end] => 1766034100.6321
            [time] => 0.013238906860352
        )

    [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 <= 1766034100 OR start >= 1766034100) AND (end >= 1766034100 OR end = 0) AND (start < 1766034100) ORDER BY name ASC
            [start] => 1766034100.6566
            [end] => 1766034100.6576
            [time] => 0.0010149478912354
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1766034100.6577
            [end] => 1766034100.658
            [time] => 0.00023508071899414
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1766034100.6581
            [end] => 1766034100.6583
            [time] => 0.0002598762512207
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2529,2532,2528,2530,2531,2533,2535,2536,2534,2537,2541,2538,2540,2542,2539,2544,2546,2547,2545,2543,2549,2552,2550,2548,2551,2556,2557,2553,2554,2555,2559,2560,2561,2562,2558,2563,2564,2567,2565,2566,2571,2568,2572,2569,2570,2573,2575,2574,2577,2576,2581,2579,2582,2578,2580,2583,2586,2585,2587,2584,2589,2591,2592,2588,2590,2593,2595,2597,2594,2596,2599,2601,2598,2600,2602,2605,2604,2603,2606,2607,2609,2610,2612,2608,2611,2613,2617,2614,2615,2616) order by id ASC
            [start] => 1766034100.662
            [end] => 1766034100.6651
            [time] => 0.003014087677002
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1766034100.8004
            [end] => 1766034100.8009
            [time] => 0.00045299530029297
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1766034100.8025
            [end] => 1766034100.8027
            [time] => 0.00026297569274902
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1766034100.8028
            [end] => 1766034100.8031
            [time] => 0.00024199485778809
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1766034100.8031
            [end] => 1766034100.8033
            [time] => 0.00019407272338867
        )

    [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 <= 1663340071 OR start >= 1663340071) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (5,7,37,12,13,6,14,3,11,29) ORDER BY lastname,firstname ASC
            [start] => 1766034100.8034
            [end] => 1766034100.8047
            [time] => 0.0013020038604736
        )

    [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 = '11') 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] => 1766034100.8052
            [end] => 1766034100.8171
            [time] => 0.011974096298218
        )

    [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 = '11')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034100.8173
            [end] => 1766034101.023
            [time] => 0.20560693740845
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1766034101.024
            [end] => 1766034101.0243
            [time] => 0.00031018257141113
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1766034101.0244
            [end] => 1766034101.0247
            [time] => 0.00025296211242676
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1766034101.0247
            [end] => 1766034101.0249
            [time] => 0.00025296211242676
        )

    [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 <= 1663340071 OR start >= 1663340071) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (5,7,37,12,13,6,14,3,11,29) ORDER BY lastname,firstname ASC
            [start] => 1766034101.025
            [end] => 1766034101.0261
            [time] => 0.0010991096496582
        )

    [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 = '11') 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] => 1766034101.0263
            [end] => 1766034101.0387
            [time] => 0.012387037277222
        )

    [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 = '11')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034101.0388
            [end] => 1766034101.2053
            [time] => 0.16650104522705
        )

    [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 <= 1663340071 OR start >= 1663340071) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) ORDER BY lastname,firstname ASC
            [start] => 1766034101.2056
            [end] => 1766034101.2093
            [time] => 0.0037140846252441
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034101.2126
            [end] => 1766034101.2129
            [time] => 0.00029706954956055
        )

    [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 <= 1766034101 OR start >= 1766034101) AND (end >= 1766034101 OR end = 0) AND (start < 1766034101) ORDER BY name ASC
            [start] => 1766034101.213
            [end] => 1766034101.2138
            [time] => 0.00078606605529785
        )

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

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

)