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

Campionati: Campionato Eccellenza 2024/2025 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 Flamurtari 50 18 17 1 1903 1444 459
2 Pellegrini Venaria 43 18 14 4 1777 1440 337
3 Skoppiati 39 18 13 5 1702 1502 200
4 Sheet 36 18 12 6 1631 1465 166
5 Black Knights 30 18 10 8 1548 1493 55
6 All Blacks 27 18 9 9 1374 1372 2
7 Citmabun 24 18 8 10 1665 1796 -131
8 Torino Warriors 9 18 3 15 1456 1833 -377
9 Guardians Chivasso 9 18 3 15 1439 1763 -324
10 Hit Bulls 3 18 1 17 1379 1766 -387
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 Pietro Evangelista
Flamurtari 		861 33 265 89% 1 18 2 0
2 Gabriele Barone
Pellegrini Venaria 		515 205 35 15% 2 18 0 0
3 Matteo Turigliatto
Flamurtari 		425 181 21 10% 2 17 0 0
4 Riccardo Francabandiera
Skoppiati 		414 144 42 23% 4 18 0 0
5 Rosso Paolo
Guardians Chivasso 		379 116 49 30% 3 18 0 0
6 Gianluca Zanetti
Citmabun 		373 152 23 13% 0 18 0 0
7 Stefano Benedetti
Sheet 		366 90 62 41% 1 17 1 0
8 Marco Salusso
Sheet 		353 82 63 43% 1 16 3 0
9 Alberto Maggia
Citmabun 		351 102 49 32% 1 17 0 0
10 Ion Soroceanu
Skoppiati 		340 125 30 19% 2 18 0 0
11 Luca Mocciaro
Pellegrini Venaria 		337 89 53 37% 0 17 0 0
12 Lorenzo De Nicola Civitarese
Black Knights 		336 96 48 33% 1 17 0 0
13 Marcello Bacchini
All Blacks 		335 85 55 39% 1 16 0 0
14 Federico Solinas
Torino Warriors 		334 113 36 24% 0 15 0 0
15 Enrico Truffa
Citmabun 		325 116 31 21% 0 18 1 0
16 Nicolò Bonincontro
Hit Bulls 		302 91 40 31% 6 18 0 0
17 Alberto Casalegno
Pellegrini Venaria 		301 119 21 15% 4 15 1 0
18 Angelo D'Alessandra
Guardians Chivasso 		296 124 16 11% 1 18 0 0
19 Stefano Borelli
Torino Warriors 		261 87 29 25% 1 15 0 0
20 Alessandro Varetto
Black Knights 		261 96 23 19% 0 17 1 0
21 Riccardo Damiano
Flamurtari 		249 99 17 15% 7 17 0 0
22 Gabriele Spina
Citmabun 		241 71 33 32% 0 14 0 0
23 Marcello Saporito
Guardians Chivasso 		237 78 27 26% 1 18 0 0
24 Domenico Pirozzolo
Pellegrini Venaria 		237 99 13 12% 2 17 0 0
25 Andrea Cacioli
Skoppiati 		228 66 32 33% 1 16 0 0
26 Lennin Jarek Garcia
Skoppiati 		217 83 17 17% 2 18 0 0
27 Matteo Vanni
Black Knights 		216 57 34 37% 0 18 0 0
28 Luca Dragna
Pellegrini Venaria 		216 96 8 8% 3 18 0 0
29 Alberto Gabriolo
Hit Bulls 		206 58 30 34% 2 16 0 0
30 Federico Suppo
Skoppiati 		198 75 16 18% 1 16 0 0
31 Giovanni Marsico
Skoppiati 		197 61 25 29% 0 18 0 0
32 Marco Antinoro
Black Knights 		189 54 27 33% 1 18 0 0
33 Marco Gamba
Torino Warriors 		189 81 9 10% 0 16 2 0
34 Patrick Marzano
All Blacks 		176 46 28 38% 2 18 0 0
35 Davide Pivato
Torino Warriors 		171 54 21 28% 1 8 1 0
36 Gianluca Varetto
Black Knights 		163 47 23 33% 0 17 0 0
37 Fabio Bragagnolo
Black Knights 		162 57 16 22% 1 18 1 0
38 Mauro Pompili
Torino Warriors 		162 57 16 22% 0 11 0 0
39 Kevin Calvo
Hit Bulls 		160 59 14 19% 3 17 0 0
40 Federico Gennaro
Guardians Chivasso 		156 69 6 8% 1 18 0 0
41 Stefano Truzzi
Sheet 		155 49 19 28% 1 18 1 0
42 Enrico Salari
Flamurtari 		148 59 10 14% 0 11 0 0
43 Fabio Ingrassia
Sheet 		139 56 9 14% 0 16 1 0
44 Pier Paolo Specchiulli
Hit Bulls 		136 44 16 27% 0 17 0 0
45 Federico Tibaldi
Hit Bulls 		130 38 18 32% 2 15 0 0
46 Gianluca Zingarelli
All Blacks 		125 46 11 19% 1 17 1 0
47 Jacopo Sanfilippo
Torino Warriors 		117 33 17 34% 0 8 0 0
48 Federico Sisci
Pellegrini Venaria 		116 52 4 7% 0 8 0 0
49 Ivano Reato
Guardians Chivasso 		112 50 4 7% 3 17 0 0
50 Lorenzo Fontana
Skoppiati 		103 35 11 24% 2 15 0 0
51 Andrea Giustetti
Sheet 		96 30 12 29% 1 11 0 0
52 Nicolò Negrini
Hit Bulls 		94 35 8 19% 3 18 0 0
53 Massimiliano Casigli
Black Knights 		89 28 11 28% 0 13 1 0
54 Fabrizio Alberto
Torino Warriors 		82 35 4 10% 0 9 1 0
55 Marco Zanatta
Flamurtari 		64 20 8 29% 4 15 0 0
56 Antonio D'Elicio
Torino Warriors 		61 29 1 3% 0 13 0 0
57 Angelo Zito
Flamurtari 		34 11 4 27% 0 13 0 0
58 Daniele Managò
Flamurtari 		8 4 0 0 0 7 0 0
59 Francesco Caligaris
All Blacks 		0 0 0 0 0 0 0 0
60 Francesco De Gaetano
Torino Warriors 		0 0 0 0 0 0 0 0
61 Daniele Demarchi
Sheet 		0 0 0 0 0 0 0 0
62 Fabrizio Gennaro
All Blacks 		0 0 0 0 0 0 0 0
63 Andrea Giannitti
Citmabun 		0 0 0 0 0 0 0 0
64 Alessandro Maniscalco
Citmabun 		0 0 0 0 0 0 0 0
65 Benito Manuel Marino
Guardians Chivasso 		0 0 0 0 0 0 0 0
66 Stefano Santangelo
Torino Warriors 		0 0 0 0 0 0 0 0
67 Nicol Sciretta
Pellegrini Venaria 		0 0 0 0 0 0 0 0
68 Manuel Spatafora
Guardians Chivasso 		0 0 0 0 0 0 0 0
69 Andrea Vecchiattini
Citmabun 		0 0 0 0 0 0 0 0
70 Lorenzo Zezza
Pellegrini Venaria 		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 Funnone
Flamurtari 		4 2 0 0 0 16 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 0.4312846660614
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1766034191.072
            [end] => 1766034191.0724
            [time] => 0.00034999847412109
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1766034191.0746
            [end] => 1766034191.0749
            [time] => 0.0002589225769043
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1766034191.075
            [end] => 1766034191.0752
            [time] => 0.00026297569274902
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (3512,3514,3511,3513,3515,3518,3516,3520,3517,3519,3525,3521,3524,3523,3522,3530,3528,3526,3529,3527,3535,3533,3534,3531,3532,3539,3538,3537,3540,3536,3544,3543,3545,3541,3542,3547,3546,3548,3549,3550,3554,3552,3555,3553,3551,3556,3559,3560,3557,3558,3564,3562,3563,3565,3561,3568,3566,3567,3570,3569,3572,3574,3571,3573,3575,3578,3576,3580,3579,3577,3585,3582,3583,3581,3584,3590,3589,3587,3586,3588,3593,3595,3592,3594,3591,3596,3598,3600,3599,3597) order by id ASC
            [start] => 1766034191.0788
            [end] => 1766034191.0818
            [time] => 0.0029590129852295
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (3512,3514,3511,3513,3515,3518,3516,3520,3517,3519,3525,3521,3524,3523,3522,3530,3528,3526,3529,3527,3535,3533,3534,3531,3532,3539,3538,3537,3540,3536,3544,3543,3545,3541,3542,3547,3546,3548,3549,3550,3554,3552,3555,3553,3551,3556,3559,3560,3557,3558,3564,3562,3563,3565,3561,3568,3566,3567,3570,3569,3572,3574,3571,3573,3575,3578,3576,3580,3579,3577,3585,3582,3583,3581,3584,3590,3589,3587,3586,3588,3593,3595,3592,3594,3591,3596,3598,3600,3599,3597)
            [start] => 1766034191.2169
            [end] => 1766034191.2302
            [time] => 0.013273000717163
        )

    [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 <= 1766034191 OR start >= 1766034191) AND (end >= 1766034191 OR end = 0) AND (start < 1766034191) ORDER BY name ASC
            [start] => 1766034191.258
            [end] => 1766034191.2589
            [time] => 0.00093984603881836
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1766034191.259
            [end] => 1766034191.2592
            [time] => 0.00023317337036133
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1766034191.2593
            [end] => 1766034191.2596
            [time] => 0.00024795532226562
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (3512,3514,3511,3513,3515,3518,3516,3520,3517,3519,3525,3521,3524,3523,3522,3530,3528,3526,3529,3527,3535,3533,3534,3531,3532,3539,3538,3537,3540,3536,3544,3543,3545,3541,3542,3547,3546,3548,3549,3550,3554,3552,3555,3553,3551,3556,3559,3560,3557,3558,3564,3562,3563,3565,3561,3568,3566,3567,3570,3569,3572,3574,3571,3573,3575,3578,3576,3580,3579,3577,3585,3582,3583,3581,3584,3590,3589,3587,3586,3588,3593,3595,3592,3594,3591,3596,3598,3600,3599,3597) order by id ASC
            [start] => 1766034191.2632
            [end] => 1766034191.2661
            [time] => 0.0029599666595459
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1766034191.401
            [end] => 1766034191.4015
            [time] => 0.00047707557678223
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1766034191.403
            [end] => 1766034191.4032
            [time] => 0.0002598762512207
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1766034191.4033
            [end] => 1766034191.4036
            [time] => 0.00024795532226562
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1766034191.4036
            [end] => 1766034191.4038
            [time] => 0.00021982192993164
        )

    [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 <= 1724582649 OR start >= 1724582649) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) AND team_id in (31,23,2,36,8,12,14,32,11,33) ORDER BY lastname,firstname ASC
            [start] => 1766034191.4039
            [end] => 1766034191.4052
            [time] => 0.0013110637664795
        )

    [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 = '26') 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] => 1766034191.4057
            [end] => 1766034191.4176
            [time] => 0.011908054351807
        )

    [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 = '26')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1766034191.4179
            [end] => 1766034191.6203
            [time] => 0.2024450302124
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1766034191.6214
            [end] => 1766034191.6218
            [time] => 0.00037193298339844
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1766034191.6219
            [end] => 1766034191.6221
            [time] => 0.00024294853210449
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1766034191.6221
            [end] => 1766034191.6223
            [time] => 0.00019407272338867
        )

    [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 <= 1724582649 OR start >= 1724582649) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) AND team_id in (31,23,2,36,8,12,14,32,11,33) ORDER BY lastname,firstname ASC
            [start] => 1766034191.6224
            [end] => 1766034191.6233
            [time] => 0.00093412399291992
        )

    [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 = '26') 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] => 1766034191.6235
            [end] => 1766034191.6356
            [time] => 0.012086868286133
        )

    [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 = '26')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1766034191.6357
            [end] => 1766034191.803
            [time] => 0.16733407974243
        )

    [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 <= 1724582649 OR start >= 1724582649) AND (end >= 1759183200 OR end = 0) AND (start < 1759183200) ORDER BY lastname,firstname ASC
            [start] => 1766034191.8032
            [end] => 1766034191.8068
            [time] => 0.0036280155181885
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1766034191.8101
            [end] => 1766034191.8104
            [time] => 0.00032186508178711
        )

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

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

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

)