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

Campionati: Campionato Eccellenza 2022/2023 A2

  1. Home
  2. Campionati
  3. Campionati

Mercoledì 26-10-2022

Sabato 29-10-2022

Domenica 30-10-2022

Sabato 12-11-2022

Domenica 13-11-2022

Venerdì 18-11-2022

Domenica 20-11-2022

Martedì 22-11-2022

Venerdì 25-11-2022

Sabato 26-11-2022

Domenica 27-11-2022

Martedì 29-11-2022

Mercoledì 30-11-2022

Venerdì 02-12-2022

Domenica 04-12-2022

Sabato 14-01-2023

Domenica 15-01-2023

Mercoledì 18-01-2023

Venerdì 20-01-2023

Domenica 22-01-2023

Sabato 28-01-2023

Domenica 29-01-2023

Venerdì 03-02-2023

Domenica 05-02-2023

Sabato 11-02-2023

Domenica 12-02-2023

Venerdì 17-02-2023

Domenica 19-02-2023

Mercoledì 22-02-2023

Venerdì 24-02-2023

Domenica 26-02-2023

Domenica 05-03-2023

Mercoledì 08-03-2023

Venerdì 10-03-2023

Domenica 12-03-2023

Sabato 18-03-2023

Domenica 19-03-2023

Mercoledì 22-03-2023

Venerdì 24-03-2023

Domenica 26-03-2023

Venerdì 31-03-2023

Sabato 01-04-2023

Domenica 02-04-2023

Mercoledì 05-04-2023

Mercoledì 12-04-2023

Venerdì 14-04-2023

Domenica 16-04-2023

Mercoledì 19-04-2023

Venerdì 21-04-2023

Domenica 23-04-2023

Mercoledì 26-04-2023

Venerdì 28-04-2023

Domenica 30-04-2023

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 Furious 19 18 7 11 1665 1856 -191
8 The New Hammers 17 18 6 12 1470 1811 -341
9 I Gadan 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 Furious 		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
The New 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
I Gadan 		346 80 62 44% 1 18 0 0
17 Marco Bernocco
Gunners 		330 105 40 28% 0 16 0 0
18 Giovanni Marino
The New Hammers 		327 135 19 12% 0 18 0 0
19 Alberto Maggia
I Gadan 		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 Furious 		294 60 58 49% 1 9 2 0
23 Davide Castaldo
Gunners 		293 79 45 36% 0 14 0 0
24 Gabriele Gazzetta
I Gadan 		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
The New 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
I Gadan 		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
I Gadan 		207 66 25 27% 2 18 0 0
37 Gianluca Gesualdo
Sporting Team Furious 		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
The New 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
The New 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 Furious 		152 49 18 27% 2 12 0 0
48 Stefano Falvo
Sporting Team Furious 		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
I Gadan 		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 Furious 		63 24 5 17% 0 7 0 0
62 Sergio Danese
The New Hammers 		54 24 2 8% 1 11 0 0
63 Fabrizio Alberto
I Gadan 		53 19 5 21% 1 18 0 0
64 Carlo Del console
Sporting Team Furious 		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 Furious 		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 Furious 		20 7 2 22% 2 3 0 0
70 Daniele Morano
The New 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
I Gadan 		66 27 4 13% 0 17 0 0
3 Sabrina Capitolo
The New 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 Furious 		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.53335022926331
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781154544.0187
            [end] => 1781154544.019
            [time] => 0.00028896331787109
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1781154544.0214
            [end] => 1781154544.0217
            [time] => 0.00024104118347168
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1781154544.0218
            [end] => 1781154544.022
            [time] => 0.00026106834411621
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '10' 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] => 1781154544.0222
            [end] => 1781154544.0252
            [time] => 0.0030379295349121
        )

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

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

    [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 <= 1781154544 OR start >= 1781154544) AND (end >= 1781154544 OR end = 0) AND (start < 1781154544) ORDER BY name ASC
            [start] => 1781154544.2561
            [end] => 1781154544.2573
            [time] => 0.0011627674102783
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1781154544.2574
            [end] => 1781154544.2576
            [time] => 0.00021910667419434
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1781154544.2577
            [end] => 1781154544.258
            [time] => 0.00024294853210449
        )

    [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] => 1781154544.2581
            [end] => 1781154544.2612
            [time] => 0.0031139850616455
        )

    [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] => 1781154544.2618
            [end] => 1781154544.2655
            [time] => 0.0036730766296387
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1781154544.4427
            [end] => 1781154544.4431
            [time] => 0.00046014785766602
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1781154544.4444
            [end] => 1781154544.4446
            [time] => 0.00022602081298828
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1781154544.4447
            [end] => 1781154544.445
            [time] => 0.00022315979003906
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1781154544.445
            [end] => 1781154544.4452
            [time] => 0.00021815299987793
        )

    [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] => 1781154544.4453
            [end] => 1781154544.4468
            [time] => 0.001492977142334
        )

    [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] => 1781154544.4472
            [end] => 1781154544.4625
            [time] => 0.015302896499634
        )

    [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] => 1781154544.4628
            [end] => 1781154544.7183
            [time] => 0.25550889968872
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '10'
            [start] => 1781154544.7195
            [end] => 1781154544.7198
            [time] => 0.00031304359436035
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1781154544.7199
            [end] => 1781154544.7202
            [time] => 0.00032401084899902
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '10'
            [start] => 1781154544.7202
            [end] => 1781154544.7205
            [time] => 0.00022602081298828
        )

    [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] => 1781154544.7205
            [end] => 1781154544.7217
            [time] => 0.0011310577392578
        )

    [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] => 1781154544.7218
            [end] => 1781154544.737
            [time] => 0.01511812210083
        )

    [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] => 1781154544.7371
            [end] => 1781154544.9429
            [time] => 0.20588183403015
        )

    [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] => 1781154544.9432
            [end] => 1781154544.947
            [time] => 0.0037930011749268
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781154544.9501
            [end] => 1781154544.9503
            [time] => 0.00025296211242676
        )

    [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 <= 1781154544 OR start >= 1781154544) AND (end >= 1781154544 OR end = 0) AND (start < 1781154544) ORDER BY name ASC
            [start] => 1781154544.9504
            [end] => 1781154544.9513
            [time] => 0.0009300708770752
        )

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

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

)