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

Campionati: Campionato Eccellenza 2022/2023 B1

  1. Home
  2. Campionati
  3. Campionati

Venerdì 28-10-2022

Sabato 29-10-2022

Mercoledì 02-11-2022

Venerdì 04-11-2022

Sabato 19-11-2022

Domenica 20-11-2022

Martedì 22-11-2022

Sabato 26-11-2022

Domenica 27-11-2022

Venerdì 02-12-2022

Sabato 03-12-2022

Domenica 04-12-2022

Mercoledì 14-12-2022

Venerdì 16-12-2022

Sabato 17-12-2022

Mercoledì 11-01-2023

Venerdì 13-01-2023

Sabato 14-01-2023

Sabato 21-01-2023

Domenica 22-01-2023

Martedì 24-01-2023

Mercoledì 25-01-2023

Venerdì 27-01-2023

Domenica 29-01-2023

Mercoledì 01-02-2023

Sabato 04-02-2023

Domenica 05-02-2023

Venerdì 10-02-2023

Domenica 12-02-2023

Mercoledì 15-02-2023

Sabato 18-02-2023

Domenica 19-02-2023

Mercoledì 22-02-2023

Venerdì 24-02-2023

Sabato 25-02-2023

Venerdì 03-03-2023

Sabato 04-03-2023

Domenica 05-03-2023

Venerdì 10-03-2023

Sabato 11-03-2023

Domenica 12-03-2023

Martedì 14-03-2023

Venerdì 17-03-2023

Domenica 19-03-2023

Martedì 21-03-2023

Venerdì 24-03-2023

Sabato 25-03-2023

Domenica 26-03-2023

Mercoledì 29-03-2023

Venerdì 31-03-2023

Sabato 01-04-2023

Domenica 02-04-2023

Mercoledì 05-04-2023

Venerdì 14-04-2023

Sabato 15-04-2023

Domenica 16-04-2023

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 Get To Hit 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
Get To Hit 		290 115 20 15% 1 15 1 0
22 Andrea Giannitti
Rising Titans 		270 99 24 20% 4 18 0 0
23 Fabio Ingrassia
Get To Hit 		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
Get To Hit 		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
Get To Hit 		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
Get To Hit 		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ì
Get To Hit 		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
Get To Hit 		101 43 5 10% 0 18 0 0
61 Tommaso Baudi Di Vesme Gabutti
Get To Hit 		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
Get To Hit 		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.52776408195496
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781150466.9287
            [end] => 1781150466.9291
            [time] => 0.00031089782714844
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1781150466.9314
            [end] => 1781150466.9316
            [time] => 0.0002138614654541
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1781150466.9318
            [end] => 1781150466.9321
            [time] => 0.00030112266540527
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '11' 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] => 1781150466.9322
            [end] => 1781150466.9353
            [time] => 0.0030670166015625
        )

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2529,2532,2528,2530,2531,2533,2535,2536,2534,2541,2538,2540,2542,2539,2544,2546,2547,2545,2549,2552,2550,2548,2556,2557,2553,2554,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,2543,2551,2537,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,2555,2613,2617,2614,2615,2616) order by id ASC
            [start] => 1781150466.9359
            [end] => 1781150466.9396
            [time] => 0.0036752223968506
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2529,2532,2528,2530,2531,2533,2535,2536,2534,2541,2538,2540,2542,2539,2544,2546,2547,2545,2549,2552,2550,2548,2556,2557,2553,2554,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,2543,2551,2537,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,2555,2613,2617,2614,2615,2616)
            [start] => 1781150467.1347
            [end] => 1781150467.1493
            [time] => 0.014657974243164
        )

    [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 <= 1781150467 OR start >= 1781150467) AND (end >= 1781150467 OR end = 0) AND (start < 1781150467) ORDER BY name ASC
            [start] => 1781150467.1825
            [end] => 1781150467.1836
            [time] => 0.0011119842529297
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1781150467.1838
            [end] => 1781150467.1841
            [time] => 0.00029587745666504
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1781150467.1841
            [end] => 1781150467.1844
            [time] => 0.00025391578674316
        )

    [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] => 1781150467.1845
            [end] => 1781150467.1875
            [time] => 0.0029520988464355
        )

    [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] => 1781150467.1881
            [end] => 1781150467.1918
            [time] => 0.0036530494689941
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1781150467.3685
            [end] => 1781150467.369
            [time] => 0.00045609474182129
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1781150467.3705
            [end] => 1781150467.3708
            [time] => 0.0002281665802002
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1781150467.3708
            [end] => 1781150467.3711
            [time] => 0.00023603439331055
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1781150467.3711
            [end] => 1781150467.3713
            [time] => 0.00021100044250488
        )

    [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] => 1781150467.3714
            [end] => 1781150467.3729
            [time] => 0.0014572143554688
        )

    [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] => 1781150467.3733
            [end] => 1781150467.3884
            [time] => 0.015140056610107
        )

    [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] => 1781150467.3887
            [end] => 1781150467.6375
            [time] => 0.24888110160828
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '11'
            [start] => 1781150467.6386
            [end] => 1781150467.6389
            [time] => 0.00029802322387695
        )

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

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '11'
            [start] => 1781150467.6393
            [end] => 1781150467.6395
            [time] => 0.00021195411682129
        )

    [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] => 1781150467.6396
            [end] => 1781150467.6406
            [time] => 0.0010910034179688
        )

    [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] => 1781150467.6408
            [end] => 1781150467.6559
            [time] => 0.015131950378418
        )

    [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] => 1781150467.656
            [end] => 1781150467.8634
            [time] => 0.20737791061401
        )

    [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] => 1781150467.8637
            [end] => 1781150467.8673
            [time] => 0.0036759376525879
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781150467.8704
            [end] => 1781150467.8706
            [time] => 0.00027084350585938
        )

    [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 <= 1781150467 OR start >= 1781150467) AND (end >= 1781150467 OR end = 0) AND (start < 1781150467) ORDER BY name ASC
            [start] => 1781150467.8707
            [end] => 1781150467.8716
            [time] => 0.00089597702026367
        )

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

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

)