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 Asti KT 15 5 5 0 325 184 141
2 Purple Hit 12 4 4 0 370 229 141
3 Overhit 12 7 4 3 392 463 -71
4 Golden Hunter 9 7 3 4 451 454 -3
5 OrbaHit 3 3 1 2 145 134 11
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 Hunter 		166 35 32 0 0 0 0 0
3 Andrea D'Urzo
Overhit 		113 34 15 0 2 0 0 0
4 Erik Goi
Asti KT 		110 31 16 0 0 0 0 0
5 Simone De Matteo
Purple Hit 		104 49 2 0 0 0 0 0
6 Ratthathammanun Toja Phengchop
OrbaHit 		98 19 20 0 0 0 0 0
7 Leonardo Ginosa
Golden Hunter 		92 46 0 0 0 0 0 0
8 Simone Rinaldi
Asti KT 		80 25 10 0 1 0 0 0
9 Luca Corvino
Overhit 		79 14 17 0 0 0 0 0
10 Simone Perri
Golden Hunter 		69 27 5 0 1 0 0 0
11 Carlo Ercole
Overhit 		66 24 6 0 0 0 0 0
12 Daniele Menescotto
Golden Hunter 		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 		56 10 12 0 0 0 0 0
16 Alessio Annicchiarico
Goliath 		54 6 14 0 0 0 0 0
17 Claudio Corso
Asti KT 		50 13 8 0 0 0 0 0
18 EDUARD ANDREI ANDRISOAE
OrbaHit 		46 8 10 0 0 0 2 0
19 Lorenzo Marrali
Golden Hunter 		39 6 9 0 1 0 0 0
20 Francesco Roggero
Asti KT 		39 9 7 0 0 0 0 0
21 Samuele Solina
Goliath 		38 4 10 0 0 0 0 0
22 Andrea Lo Vetro
Orba In Black 		34 14 2 0 0 0 0 0
23 Andrea Fadda
Overhit 		30 3 8 0 0 0 0 0
24 Stefano Piron
Goliath 		30 3 8 0 0 0 0 1
25 Christina Pede
Orba In Black 		30 9 4 0 0 0 0 0
26 Mauricio Rodrigo Robles Zavaleta
Overhit 		29 1 9 0 0 0 0 0
27 Ludovico Scali
Golden Hunter 		25 11 1 0 0 0 0 0
28 Roberto Lacopo
Orba In Black 		21 0 7 0 0 0 0 0
29 Fabrizio Botta
Asti KT 		21 6 3 0 0 0 0 0
30 Tommaso Petitti
Giasthit 		19 2 5 0 0 0 0 0
31 Michael Saltarelli
Goliath 		19 2 5 0 0 0 0 0
32 Lorenzo Soldan
Goliath 		18 6 2 0 0 0 0 0
33 Alessandro Ioverno
Orba In Black 		15 0 5 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 Anita Di Cristina
Goliath 		43 11 7 0 1 0 0 0
3 Paola Verardi
Giasthit 		35 1 11 0 0 0 0 0
4 Emma Sandretto
Giasthit 		31 2 9 0 0 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: 3.4146406650543
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776056244.3602
            [end] => 1776056244.3758
            [time] => 0.015633821487427
        )

    [1] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1776056244.3855
            [end] => 1776056244.3914
            [time] => 0.0059459209442139
        )

    [2] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1776056244.3916
            [end] => 1776056244.3923
            [time] => 0.0007178783416748
        )

    [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] => 1776056244.3924
            [end] => 1776056244.4069
            [time] => 0.014497995376587
        )

    [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] => 1776056244.4072
            [end] => 1776056244.4365
            [time] => 0.029299020767212
        )

    [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] => 1776056244.682
            [end] => 1776056244.7766
            [time] => 0.094567060470581
        )

    [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 <= 1776056244 OR start >= 1776056244) AND (end >= 1776056244 OR end = 0) AND (start < 1776056244) ORDER BY name ASC
            [start] => 1776056244.8616
            [end] => 1776056244.8655
            [time] => 0.0039570331573486
        )

    [7] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1776056244.8656
            [end] => 1776056244.8697
            [time] => 0.0040910243988037
        )

    [8] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1776056244.8698
            [end] => 1776056244.874
            [time] => 0.0041549205780029
        )

    [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] => 1776056244.8741
            [end] => 1776056244.8926
            [time] => 0.018467903137207
        )

    [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] => 1776056244.893
            [end] => 1776056244.9186
            [time] => 0.025650024414062
        )

    [11] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1776056244.9964
            [end] => 1776056245.0007
            [time] => 0.004396915435791
        )

    [12] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1776056245.0014
            [end] => 1776056245.0038
            [time] => 0.002363920211792
        )

    [13] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1776056245.0039
            [end] => 1776056245.0081
            [time] => 0.0042188167572021
        )

    [14] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1776056245.0081
            [end] => 1776056245.0099
            [time] => 0.0018229484558105
        )

    [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] => 1776056245.0101
            [end] => 1776056245.0169
            [time] => 0.0068340301513672
        )

    [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] => 1776056245.0181
            [end] => 1776056245.1445
            [time] => 0.12642383575439
        )

    [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] => 1776056245.1447
            [end] => 1776056246.9015
            [time] => 1.7568778991699
        )

    [18] => Array
        (
            [query] => select * from championship where championship_id = '46'
            [start] => 1776056246.9022
            [end] => 1776056246.9128
            [time] => 0.010571002960205
        )

    [19] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1776056246.9129
            [end] => 1776056246.9132
            [time] => 0.00028586387634277
        )

    [20] => Array
        (
            [query] => select * from team_to_championship where championship_id = '46'
            [start] => 1776056246.9132
            [end] => 1776056246.9134
            [time] => 0.0002140998840332
        )

    [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] => 1776056246.9135
            [end] => 1776056246.9147
            [time] => 0.0011501312255859
        )

    [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] => 1776056246.9149
            [end] => 1776056246.9891
            [time] => 0.074244976043701
        )

    [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] => 1776056246.9892
            [end] => 1776056248.1832
            [time] => 1.193962097168
        )

    [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] => 1776056248.1834
            [end] => 1776056248.1912
            [time] => 0.007774829864502
        )

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

    [26] => Array
        (
            [query] => select * from location where deleted = '0'
            [start] => 1776056248.1975
            [end] => 1776056248.2
            [time] => 0.0025289058685303
        )

    [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 <= 1776056248 OR start >= 1776056248) AND (end >= 1776056248 OR end = 0) AND (start < 1776056248) ORDER BY name ASC
            [start] => 1776056248.2001
            [end] => 1776056248.2009
            [time] => 0.00079202651977539
        )

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

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

)