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

Campionati: Campionato Eccellenza 2024/2025 A2

  1. Home
  2. Campionati
  3. Campionati

Giovedì 17-10-2024

Venerdì 18-10-2024

Domenica 20-10-2024

Martedì 22-10-2024

Mercoledì 23-10-2024

Giovedì 24-10-2024

Venerdì 25-10-2024

Mercoledì 30-10-2024

Martedì 05-11-2024

Mercoledì 06-11-2024

Venerdì 08-11-2024

Martedì 12-11-2024

Venerdì 15-11-2024

Domenica 17-11-2024

Mercoledì 20-11-2024

Giovedì 21-11-2024

Domenica 24-11-2024

Martedì 26-11-2024

Giovedì 28-11-2024

Domenica 01-12-2024

Mercoledì 04-12-2024

Giovedì 05-12-2024

Martedì 10-12-2024

Martedì 17-12-2024

Venerdì 20-12-2024

Domenica 22-12-2024

Mercoledì 08-01-2025

Giovedì 09-01-2025

Domenica 12-01-2025

Venerdì 17-01-2025

Martedì 21-01-2025

Venerdì 24-01-2025

Domenica 26-01-2025

Martedì 28-01-2025

Venerdì 31-01-2025

Martedì 04-02-2025

Giovedì 06-02-2025

Venerdì 07-02-2025

Mercoledì 12-02-2025

Venerdì 14-02-2025

Domenica 16-02-2025

Martedì 18-02-2025

Martedì 25-02-2025

Giovedì 27-02-2025

Giovedì 06-03-2025

Martedì 11-03-2025

Giovedì 13-03-2025

Venerdì 14-03-2025

Domenica 16-03-2025

Martedì 18-03-2025

Giovedì 20-03-2025

Venerdì 21-03-2025

Domenica 23-03-2025

Mercoledì 26-03-2025

Giovedì 27-03-2025

Venerdì 28-03-2025

Domenica 30-03-2025

Martedì 01-04-2025

Mercoledì 02-04-2025

Giovedì 03-04-2025

Venerdì 04-04-2025

Domenica 06-04-2025

Martedì 08-04-2025

Mercoledì 09-04-2025

Domenica 13-04-2025

Martedì 15-04-2025

Giovedì 17-04-2025

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.52963995933533
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781150334.4822
            [end] => 1781150334.4825
            [time] => 0.00031089782714844
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1781150334.4849
            [end] => 1781150334.4852
            [time] => 0.00023198127746582
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1781150334.4853
            [end] => 1781150334.4855
            [time] => 0.00025486946105957
        )

    [3] => Array
        (
            [query] => select * from matches where championship_id = '26' 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] => 1781150334.4857
            [end] => 1781150334.4887
            [time] => 0.0030732154846191
        )

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

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

    [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 <= 1781150334 OR start >= 1781150334) AND (end >= 1781150334 OR end = 0) AND (start < 1781150334) ORDER BY name ASC
            [start] => 1781150334.7229
            [end] => 1781150334.7241
            [time] => 0.0012168884277344
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1781150334.7242
            [end] => 1781150334.7244
            [time] => 0.00020885467529297
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1781150334.7245
            [end] => 1781150334.7248
            [time] => 0.00025320053100586
        )

    [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] => 1781150334.7249
            [end] => 1781150334.728
            [time] => 0.0031468868255615
        )

    [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] => 1781150334.7286
            [end] => 1781150334.7323
            [time] => 0.0036659240722656
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1781150334.9094
            [end] => 1781150334.9099
            [time] => 0.00045990943908691
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1781150334.9113
            [end] => 1781150334.9116
            [time] => 0.00021195411682129
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1781150334.9116
            [end] => 1781150334.9119
            [time] => 0.00029206275939941
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1781150334.912
            [end] => 1781150334.9122
            [time] => 0.00022482872009277
        )

    [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] => 1781150334.9123
            [end] => 1781150334.9137
            [time] => 0.0014379024505615
        )

    [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] => 1781150334.9142
            [end] => 1781150334.9294
            [time] => 0.015259027481079
        )

    [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] => 1781150334.9297
            [end] => 1781150335.1799
            [time] => 0.25024795532227
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '26'
            [start] => 1781150335.1809
            [end] => 1781150335.1813
            [time] => 0.00032520294189453
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1781150335.1814
            [end] => 1781150335.1816
            [time] => 0.00024890899658203
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '26'
            [start] => 1781150335.1816
            [end] => 1781150335.1819
            [time] => 0.00023889541625977
        )

    [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] => 1781150335.1819
            [end] => 1781150335.183
            [time] => 0.0010509490966797
        )

    [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] => 1781150335.1831
            [end] => 1781150335.1983
            [time] => 0.015142917633057
        )

    [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] => 1781150335.1983
            [end] => 1781150335.4057
            [time] => 0.20739889144897
        )

    [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] => 1781150335.4059
            [end] => 1781150335.4096
            [time] => 0.003713846206665
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1781150335.4128
            [end] => 1781150335.413
            [time] => 0.00023198127746582
        )

    [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 <= 1781150335 OR start >= 1781150335) AND (end >= 1781150335 OR end = 0) AND (start < 1781150335) ORDER BY name ASC
            [start] => 1781150335.4131
            [end] => 1781150335.414
            [time] => 0.0009610652923584
        )

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

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

)