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

Campionati: Campionato Misto Start

  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
Ranking Squadra Punti Partite Giocate Vittorie Sconfitte Punti Fatti Punti Subiti Differenza Punti
1 Purple Hit 12 4 4 0 370 229 141
2 Asti KT 12 4 4 0 318 179 139
3 Overhit 12 7 4 3 392 463 -71
4 Golden Hunters 9 7 3 4 451 454 -3
5 OrbaHit 3 2 1 1 140 127 13
6 Giasthit 3 4 1 3 202 250 -48
7 Goliath 3 4 1 3 177 269 -92
8 Orba In Black 0 4 0 4 179 258 -79
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 Alessio Fano
Purple Hit 		266 94 26 0 0 0 0 0
2 Matteo Birolo
Golden Hunters 		166 35 32 0 0 0 0 0
3 Andrea D'Urzo
Overhit 		113 34 15 0 2 0 0 0
4 Simone De Matteo
Purple Hit 		104 49 2 0 0 0 0 0
5 Erik Goi
Asti KT 		99 30 13 0 0 0 0 0
6 Ratthathammanun Toja Phengchop
OrbaHit 		94 17 20 0 0 0 0 0
7 Leonardo Ginosa
Golden Hunters 		92 46 0 0 0 0 0 0
8 Luca Corvino
Overhit 		79 14 17 0 0 0 0 0
9 Simone Rinaldi
Asti KT 		71 25 7 0 0 0 0 0
10 Simone Perri
Golden Hunters 		69 27 5 0 1 0 0 0
11 Carlo Ercole
Overhit 		66 24 6 0 0 0 0 0
12 Daniele Menescotto
Golden Hunters 		60 15 10 0 0 0 0 0
13 Andrea Papalia
Orba In Black 		58 17 8 0 0 0 0 0
14 Manuel Mangino
Overhit 		56 4 16 0 0 0 0 0
15 Francesco Pellitteri
Asti KT 		51 9 11 0 0 0 0 0
16 Alessio Annicchiarico
Goliath 		48 3 14 0 0 0 0 0
17 EDUARD ANDREI ANDRISOAE
OrbaHit 		46 8 10 0 0 0 0 0
18 Claudio Corso
Asti KT 		45 12 7 0 0 0 0 0
19 Lorenzo Marrali
Golden Hunters 		39 6 9 0 1 0 0 0
20 Samuele Solina
Goliath 		38 4 10 0 0 0 0 0
21 Andrea Lo Vetro
Orba In Black 		34 14 2 0 0 0 0 0
22 Andrea Fadda
Overhit 		30 3 8 0 0 0 0 0
23 Stefano Piron
Goliath 		30 3 8 0 0 0 0 0
24 Christina Pede
Orba In Black 		30 9 4 0 0 0 0 0
25 Mauricio Rodrigo Robles Zavaleta
Overhit 		29 1 9 0 0 0 0 0
26 Francesco Roggero
Asti KT 		26 4 6 0 0 0 0 0
27 Ludovico Scali
Golden Hunters 		25 11 1 0 0 0 0 0
28 Roberto Lacopo
Orba In Black 		21 0 7 0 0 0 0 0
29 Tommaso Petitti
Giasthit 		19 2 5 0 0 0 0 0
30 Fabrizio Botta
Asti KT 		19 5 3 0 0 0 0 0
31 Michael Saltarelli
Goliath 		16 2 4 0 0 0 0 0
32 Alessandro Ioverno
Orba In Black 		15 0 5 0 0 0 0 0
33 Lorenzo Soldan
Goliath 		14 4 2 0 0 0 0 0
34 Davide Lecaselle
Giasthit 		12 0 4 0 0 0 0 0
35 Mattia Magliano Boccardo
Overhit 		12 0 4 0 0 0 0 0
36 Mattia Amaro
Orba In Black 		11 1 3 0 0 0 0 0
37 Lorenzo Caglio
Orba In Black 		6 0 2 0 0 0 0 0
38 Nathan Cuellar
Overhit 		6 0 2 0 0 0 0 0
39 Andrea Biletta
Asti KT 		6 3 0 0 0 0 0 0
40 Andrea Emiliano
Orba In Black 		3 0 1 0 0 0 0 0
41 Alessandro Bruno
Purple Hit 		0 0 0 0 0 0 0 0
42 Daniele Dal Zotto
Purple Hit 		0 0 0 0 0 0 0 0
43 Christian Matteo Delgrosso
Purple Hit 		0 0 0 0 0 0 0 0
44 Emanuele Di Piazza
Orba In Black 		0 0 0 0 0 0 0 0
45 Lorenzo Galli
Purple Hit 		0 0 0 0 0 0 0 0
46 Simone Giovinazzo
OrbaHit 		0 0 0 0 0 0 0 0
47 Marco Lepori
OrbaHit 		0 0 0 0 0 0 0 0
48 Marco Luisi
OrbaHit 		0 0 0 0 0 0 0 0
49 Federico Marra
OrbaHit 		0 0 0 0 0 0 0 0
50 Nicolò Meluso
Asti KT 		0 0 0 0 0 0 0 0
51 Francesco Viola
Purple Hit 		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 Isabella Attardi
Giasthit 		49 2 15 0 0 0 0 0
2 Paola Verardi
Giasthit 		35 1 11 0 0 0 0 0
3 Emma Sandretto
Giasthit 		31 2 9 0 0 0 0 0
4 Anita Di Cristina
Goliath 		29 7 5 0 1 0 0 0
5 Angelica Maria Bonomi
Giasthit 		23 1 7 0 0 0 0 0
6 Ginevra Pala
Giasthit 		18 0 6 0 0 0 0 0
7 Giulia D'alessandro
Giasthit 		15 0 5 0 0 0 0 0
8 Giulia Corica
Purple Hit 		0 0 0 0 0 0 0 0
Ranking Giocatore Punti Hit x2 Hit x3 % Hit x3 Autohit Partite Giocate Ammonizioni Espulsioni 
                Total Queries: 30
        Total Time: 1.0166380405426
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770959589.7712
            [end] => 1770959589.7715
            [time] => 0.00033020973205566
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1770959589.7779
            [end] => 1770959589.7783
            [time] => 0.00035405158996582
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1770959589.7784
            [end] => 1770959589.7788
            [time] => 0.00041007995605469
        )

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

    [4] => Array
        (
            [query] => select * from match_time where match_id in (4519,4517,4518,4520,4523,4524,4521,4522,4526,4528,4525,4527,4531,4530,4529,4532,4535,4536,4534,4533,4538,4540,4539,4537,4542,4544,4541,4543,4545,4546,4547,4548,4552,4550,4549,4551,4554,4556,4555,4553,4558,4557,4559,4560,4563,4562,4564,4561,4566,4565,4567,4568,4571,4572,4569,4570) order by id ASC
            [start] => 1770959589.7829
            [end] => 1770959589.7859
            [time] => 0.0030601024627686
        )

    [5] => Array
        (
            [query] => SELECT * FROM match_data where match_id IN (4519,4517,4518,4520,4523,4524,4521,4522,4526,4528,4525,4527,4531,4530,4529,4532,4535,4536,4534,4533,4538,4540,4539,4537,4542,4544,4541,4543,4545,4546,4547,4548,4552,4550,4549,4551,4554,4556,4555,4553,4558,4557,4559,4560,4563,4562,4564,4561,4566,4565,4567,4568,4571,4572,4569,4570)
            [start] => 1770959589.8148
            [end] => 1770959589.8278
            [time] => 0.013059139251709
        )

    [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 <= 1770959589 OR start >= 1770959589) AND (end >= 1770959589 OR end = 0) AND (start < 1770959589) ORDER BY name ASC
            [start] => 1770959589.8573
            [end] => 1770959589.8589
            [time] => 0.0016238689422607
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1770959589.859
            [end] => 1770959589.8592
            [time] => 0.00017595291137695
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1770959589.8593
            [end] => 1770959589.8596
            [time] => 0.00028586387634277
        )

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

    [10] => Array
        (
            [query] => select * from match_time where match_id in (4519,4517,4518,4520,4523,4524,4521,4522,4526,4528,4525,4527,4531,4530,4529,4532,4535,4536,4534,4533,4538,4540,4539,4537,4542,4544,4541,4543,4545,4546,4547,4548,4552,4550,4549,4551,4554,4556,4555,4553,4558,4557,4559,4560,4563,4562,4564,4561,4566,4565,4567,4568,4571,4572,4569,4570) order by id ASC
            [start] => 1770959589.8683
            [end] => 1770959589.8748
            [time] => 0.0065591335296631
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1770959589.9264
            [end] => 1770959589.9289
            [time] => 0.002547025680542
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1770959589.9295
            [end] => 1770959589.9297
            [time] => 0.00020194053649902
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1770959589.9298
            [end] => 1770959589.93
            [time] => 0.00022196769714355
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1770959589.9301
            [end] => 1770959589.9303
            [time] => 0.00019598007202148
        )

    [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 <= 1760963692 OR start >= 1760963692) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (48,57,65,58,64,62,66,42) ORDER BY lastname,firstname ASC
            [start] => 1770959589.9304
            [end] => 1770959589.9315
            [time] => 0.0011429786682129
        )

    [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 = '46') 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] => 1770959589.9319
            [end] => 1770959589.9637
            [time] => 0.031810998916626
        )

    [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 = '46')  and player_id in (select player_id from player where gender = 'male')  group by player_id order by total DESC
            [start] => 1770959589.9638
            [end] => 1770959590.618
            [time] => 0.65417790412903
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1770959590.6186
            [end] => 1770959590.6191
            [time] => 0.00056910514831543
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1770959590.6192
            [end] => 1770959590.6207
            [time] => 0.0014870166778564
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1770959590.6208
            [end] => 1770959590.6219
            [time] => 0.0011699199676514
        )

    [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 <= 1760963692 OR start >= 1760963692) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) AND team_id in (48,57,65,58,64,62,66,42) ORDER BY lastname,firstname ASC
            [start] => 1770959590.622
            [end] => 1770959590.6229
            [time] => 0.00092196464538574
        )

    [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 = '46') 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] => 1770959590.6231
            [end] => 1770959590.6474
            [time] => 0.024266004562378
        )

    [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 = '46')  and player_id in (select player_id from player where gender = 'female')  group by player_id order by total DESC
            [start] => 1770959590.6475
            [end] => 1770959590.9016
            [time] => 0.25418591499329
        )

    [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 <= 1760963692 OR start >= 1760963692) AND (end >= 1790719200 OR end = 0) AND (start < 1790719200) ORDER BY lastname,firstname ASC
            [start] => 1770959590.9019
            [end] => 1770959590.9057
            [time] => 0.0038142204284668
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1770959590.9089
            [end] => 1770959590.9092
            [time] => 0.00039100646972656
        )

    [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 <= 1770959590 OR start >= 1770959590) AND (end >= 1770959590 OR end = 0) AND (start < 1770959590) ORDER BY name ASC
            [start] => 1770959590.9093
            [end] => 1770959590.9101
            [time] => 0.00074887275695801
        )

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

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

)