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

Campionati: Campionato Eccellenza 2022/2023 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 Rdj 51 18 17 1 2203 1534 669
2 Genova Hit Ball 48 18 16 2 1719 1176 543
3 All Blacks 36 18 12 6 1772 1562 210
4 Flamurtari 31 18 10 8 1715 1593 122
5 Guardians Chivasso 24 18 8 10 1716 1808 -92
6 Sheet 21 18 7 11 1639 1792 -153
7 Sporting Team Next Gen 19 18 7 11 1665 1856 -191
8 Hammers 17 18 6 12 1470 1811 -341
9 Igadan 15 18 5 13 1641 1901 -260
10 Gunners 5 18 2 16 1333 1840 -507
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 Filippo Agnelli
Sporting Team Next Gen 		706 134 146 52% 2 15 0 0
2 Pietro Evangelista
Flamurtari 		680 19 214 92% 4 15 0 0
3 Daniele Agnello
Rdj 		509 160 63 28% 1 16 0 0
4 Riccardo Marello
Rdj 		504 162 60 27% 2 18 0 0
5 Gabriel Alessandro Delgrosso
All Blacks 		458 118 74 39% 3 18 0 0
6 Luca Fagherazzi
Genova Hit Ball 		452 157 46 23% 1 18 0 0
7 Roberto Carrer
Hammers 		428 91 82 47% 1 15 0 0
8 Luca Siciliano
Genova Hit Ball 		412 176 20 10% 0 18 0 0
9 Marcello Bacchini
All Blacks 		409 113 61 35% 2 18 1 0
10 Matteo Turigliatto
Flamurtari 		401 154 31 17% 1 18 0 0
11 Alessandro Varetto
All Blacks 		400 116 56 33% 0 18 0 0
12 Marco Broggini
Guardians Chivasso 		399 156 29 16% 1 18 1 0
13 Andrea Rigoni
Rdj 		395 118 53 31% 2 17 0 0
14 Stefano Benedetti
Sheet 		390 105 60 36% 0 16 0 0
15 Davide Salvaggio
Sheet 		373 119 45 27% 2 18 0 0
16 Enrico Truffa
Igadan 		346 80 62 44% 1 18 0 0
17 Marco Bernocco
Gunners 		330 105 40 28% 0 16 0 0
18 Giovanni Marino
Hammers 		327 135 19 12% 0 18 0 0
19 Alberto Maggia
Igadan 		320 70 60 46% 1 17 0 0
20 Benito Manuel Marino
Guardians Chivasso 		306 105 32 23% 2 18 0 0
21 Paolo Testa
Rdj 		297 93 37 28% 0 13 0 0
22 Fabio Sinicco
Sporting Team Next Gen 		294 60 58 49% 1 9 2 0
23 Davide Castaldo
Gunners 		293 79 45 36% 0 14 0 0
24 Gabriele Gazzetta
Igadan 		289 77 45 37% 3 15 0 0
25 Gabriele Spina
Rdj 		288 87 38 30% 1 17 0 0
26 Andrea Lavalle
Sheet 		287 112 21 16% 0 18 0 0
27 Enrico Salari
Flamurtari 		274 119 12 9% 0 16 0 0
28 Rosso Paolo
Guardians Chivasso 		252 87 26 23% 1 17 0 0
29 Ion Soroceanu
Gunners 		237 90 19 17% 2 15 0 0
30 Dario Ravera
Genova Hit Ball 		232 92 16 15% 1 15 0 0
31 Lorenzo Novara
Hammers 		226 95 12 11% 0 15 0 0
32 Davide Centin
Gunners 		223 86 17 17% 4 15 1 0
33 Francesco De Gaetano
Igadan 		221 61 33 35% 0 17 0 0
34 Marco Schiaroli
Guardians Chivasso 		221 85 17 17% 2 17 0 0
35 Angelo D'Alessandra
Guardians Chivasso 		211 95 7 7% 1 18 0 0
36 Alessandro Maniscalco
Igadan 		207 66 25 27% 2 18 0 0
37 Gianluca Gesualdo
Sporting Team Next Gen 		204 69 22 24% 2 12 0 0
38 Gianluca L'Intrepido
Rdj 		201 81 13 14% 1 17 0 0
39 Salvatore Lo Monaco
Hammers 		199 86 9 9% 1 15 0 0
40 Mauro Pompili
Guardians Chivasso 		197 76 15 16% 1 17 0 0
41 Ivan Russo
Hammers 		192 87 6 6% 1 17 1 0
42 Diego Leonardi
All Blacks 		178 56 22 28% 1 16 0 0
43 Antonio Marincola
Flamurtari 		176 58 20 26% 2 15 0 0
44 Riccardo Merlo
Genova Hit Ball 		169 83 1 1% 0 17 0 0
45 Marco Salusso
Sheet 		161 25 37 60% 0 6 0 0
46 Giacomo Guarrato
Gunners 		156 60 12 17% 2 14 0 0
47 Massimiliano Casigli
Sporting Team Next Gen 		152 49 18 27% 2 12 0 0
48 Stefano Falvo
Sporting Team Next Gen 		147 39 23 37% 2 10 0 0
49 Andrea Giustetti
Sheet 		145 44 19 30% 2 18 1 0
50 Davide Ciancio
Genova Hit Ball 		132 60 4 6% 0 17 1 0
51 Stefano Santangelo
Igadan 		130 53 8 13% 3 17 0 0
52 Gianluca Zingarelli
All Blacks 		128 46 12 21% 2 16 0 0
53 Francesco Dughera
Guardians Chivasso 		125 58 3 5% 1 18 0 0
54 Arturo Pero
Genova Hit Ball 		122 55 4 7% 0 16 0 0
55 Carlo Pangallo
Sheet 		119 43 11 20% 0 10 0 0
56 Gianluca Varetto
All Blacks 		113 49 5 9% 0 18 0 0
57 Marco Zanatta
Flamurtari 		96 33 10 23% 0 16 0 0
58 Daniele Demarchi
Sheet 		80 31 6 16% 0 18 0 0
59 Alessandro Bosa
All Blacks 		79 26 9 26% 0 13 1 0
60 Stefano Truzzi
Sheet 		77 25 9 26% 0 13 1 0
61 Matteo Barberis
Sporting Team Next Gen 		63 24 5 17% 0 7 0 0
62 Sergio Danese
Hammers 		54 24 2 8% 1 11 0 0
63 Fabrizio Alberto
Igadan 		53 19 5 21% 1 18 0 0
64 Carlo Del console
Sporting Team Next Gen 		47 16 5 24% 1 16 0 0
65 Matteo La Tegola
Genova Hit Ball 		36 15 2 12% 1 4 0 0
66 Giorgio Recalcati
Genova Hit Ball 		36 18 0 0 0 15 0 0
67 Vincenzo Padula
Sporting Team Next Gen 		22 11 0 0 0 16 0 0
68 Daniele Managò
Flamurtari 		20 4 4 50% 2 12 0 0
69 Andrea Petrilli
Sporting Team Next Gen 		20 7 2 22% 2 3 0 0
70 Daniele Morano
Hammers 		15 6 1 14% 0 3 1 0
71 Enrico Brunello
Gunners 		8 4 0 0 0 2 0 0
72 Adriano Paribello Grasso
Guardians Chivasso 		0 0 0 0 0 0 0 0
73 Alessandro Romano
Flamurtari 		0 0 0 0 0 0 0 0
74 Davide Senatore
Sheet 		0 0 0 0 0 0 0 0
75 Massimiliano Taglianetti
Sheet 		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 		79 38 1 3% 0 14 0 0
2 Carlotta Amodeo
Igadan 		66 27 4 13% 0 17 0 0
3 Sabrina Capitolo
Hammers 		20 10 0 0 1 16 1 0
4 Federica Funnone
Flamurtari 		2 1 0 0 1 17 0 0
5 Francesca Da Re
Rdj 		0 0 0 0 0 10 0 0
6 Ilaria Mezzatesta
Sporting Team Next Gen 		0 0 0 0 0 0 0 0
7 Cristina Rijillo
Sheet 		0 0 0 0 0 2 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.43113851547241
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034101.2278
            [end] => 1766034101.2282
            [time] => 0.00038409233093262
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1766034101.2304
            [end] => 1766034101.2307
            [time] => 0.00032997131347656
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1766034101.2308
            [end] => 1766034101.2311
            [time] => 0.00026917457580566
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (2441,2439,2440,2442,2438,2443,2446,2445,2447,2444,2451,2450,2448,2452,2449,2453,2456,2457,2454,2455,2458,2461,2459,2462,2460,2463,2467,2465,2464,2466,2470,2468,2469,2472,2471,2476,2477,2474,2475,2473,2478,2479,2480,2481,2482,2484,2487,2483,2486,2485,2492,2488,2491,2489,2490,2494,2495,2497,2496,2493,2500,2501,2502,2499,2498,2503,2506,2504,2505,2507,2508,2512,2509,2510,2511,2515,2514,2513,2516,2517,2519,2520,2521,2518,2522,2523,2527,2524,2526,2525) order by id ASC
            [start] => 1766034101.2346
            [end] => 1766034101.2376
            [time] => 0.0030078887939453
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (2441,2439,2440,2442,2438,2443,2446,2445,2447,2444,2451,2450,2448,2452,2449,2453,2456,2457,2454,2455,2458,2461,2459,2462,2460,2463,2467,2465,2464,2466,2470,2468,2469,2472,2471,2476,2477,2474,2475,2473,2478,2479,2480,2481,2482,2484,2487,2483,2486,2485,2492,2488,2491,2489,2490,2494,2495,2497,2496,2493,2500,2501,2502,2499,2498,2503,2506,2504,2505,2507,2508,2512,2509,2510,2511,2515,2514,2513,2516,2517,2519,2520,2521,2518,2522,2523,2527,2524,2526,2525)
            [start] => 1766034101.3727
            [end] => 1766034101.3861
            [time] => 0.013401985168457
        )

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

    [7] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1766034101.4114
            [end] => 1766034101.4117
            [time] => 0.00025320053100586
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1766034101.4118
            [end] => 1766034101.412
            [time] => 0.00023913383483887
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (2441,2439,2440,2442,2438,2443,2446,2445,2447,2444,2451,2450,2448,2452,2449,2453,2456,2457,2454,2455,2458,2461,2459,2462,2460,2463,2467,2465,2464,2466,2470,2468,2469,2472,2471,2476,2477,2474,2475,2473,2478,2479,2480,2481,2482,2484,2487,2483,2486,2485,2492,2488,2491,2489,2490,2494,2495,2497,2496,2493,2500,2501,2502,2499,2498,2503,2506,2504,2505,2507,2508,2512,2509,2510,2511,2515,2514,2513,2516,2517,2519,2520,2521,2518,2522,2523,2527,2524,2526,2525) order by id ASC
            [start] => 1766034101.4156
            [end] => 1766034101.4186
            [time] => 0.0030179023742676
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1766034101.5536
            [end] => 1766034101.554
            [time] => 0.00044107437133789
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1766034101.5553
            [end] => 1766034101.5556
            [time] => 0.00027704238891602
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1766034101.5557
            [end] => 1766034101.5559
            [time] => 0.00025296211242676
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1766034101.5559
            [end] => 1766034101.5561
            [time] => 0.00021600723266602
        )

    [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 <= 1663339940 OR start >= 1663339940) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (31,36,38,8,30,28,20,32,4,34) ORDER BY lastname,firstname ASC
            [start] => 1766034101.5563
            [end] => 1766034101.5577
            [time] => 0.0014128684997559
        )

    [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 = '10') 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.5582
            [end] => 1766034101.5705
            [time] => 0.012254953384399
        )

    [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 = '10')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034101.5708
            [end] => 1766034101.773
            [time] => 0.20226407051086
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1766034101.7742
            [end] => 1766034101.7745
            [time] => 0.00031900405883789
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1766034101.7746
            [end] => 1766034101.7749
            [time] => 0.00027894973754883
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1766034101.7749
            [end] => 1766034101.7751
            [time] => 0.00021219253540039
        )

    [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 <= 1663339940 OR start >= 1663339940) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) AND team_id in (31,36,38,8,30,28,20,32,4,34) ORDER BY lastname,firstname ASC
            [start] => 1766034101.7752
            [end] => 1766034101.7762
            [time] => 0.0010180473327637
        )

    [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 = '10') 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.7764
            [end] => 1766034101.7884
            [time] => 0.011994123458862
        )

    [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 = '10')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034101.7885
            [end] => 1766034101.9548
            [time] => 0.16631984710693
        )

    [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 <= 1663339940 OR start >= 1663339940) AND (end >= 1696024800 OR end = 0) AND (start < 1696024800) ORDER BY lastname,firstname ASC
            [start] => 1766034101.9551
            [end] => 1766034101.9588
            [time] => 0.0037040710449219
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034101.962
            [end] => 1766034101.9624
            [time] => 0.00039887428283691
        )

    [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.9625
            [end] => 1766034101.9633
            [time] => 0.0007789134979248
        )

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

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

)