Referto Partita: Hocheti Pokety vs Iron Lion Tyson
Hocheti Pokety
Iron Lion Tyson
RISULTATO FINALE
99
87
1° Tempo
38
34
2° Tempo
30
24
3° Tempo
31
29
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2023/2024 B1
Giornata: 8
Giornata: 8
Data e Luogo
10-01-2024 20:30 - Cavour
Arbitri
Primo Arbitro
Naggi Giulio
Secondo Arbitro
Naggi Giulio
Refertista
ASD Polaris
Sorteggio
Sorteggio Vinto Da
Hocheti Pokety
Scelta Sorteggio
Palla
Annotazioni
Refertista: Lisa Portarulo
Progresso
Punteggi Individuali
Hocheti Pokety
-
Thomas RovettoTot.11
4
x21
x3
0
x AUTOHIT -
Alberto RaccoTot.18
9
x20
x3
0
x AUTOHIT -
Simone De MeoTot.18
6
x22
x3
0
x AUTOHIT -
Simone PoserTot.0
0
x20
x3
0
x AUTOHIT -
Luigi GhirardiTot.8
4
x20
x3
0
x AUTOHIT -
Ramon RutiglianoTot.16
5
x22
x3
0
x AUTOHIT -
Ivan DastrùTot.27
9
x23
x3
1
x AUTOHIT
Iron Lion Tyson
-
Marco Barrasso
7
x22
x3
0
x AUTOHITTot.20
Cristina Vaudagna
1
x20
x3
0
x AUTOHITTot.2
Cherif Balde
0
x20
x3
0
x AUTOHITTot.0
Mario Franchi
0
x20
x3
0
x AUTOHITTot.0
Paul Mihei
3
x26
x3
0
x AUTOHITTot.24
Francesco Rigoni
2
x21
x3
1
x AUTOHITTot.7
SIlvia Petiti
0
x20
x3
0
x AUTOHITTot.0
Emiliano Travaglini
8
x25
x3
0
x AUTOHITTot.31
Simone Garino
1
x20
x3
0
x AUTOHITTot.2
Total Queries: 55 Total Time: 1.9002108573914 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1781164810.5713 [end] => 1781164810.5715 [time] => 0.00023293495178223 ) [1] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164810.5856 [end] => 1781164810.5901 [time] => 0.004533052444458 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164810.5901 [end] => 1781164810.6051 [time] => 0.015002012252808 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164810.6052 [end] => 1781164810.681 [time] => 0.075735807418823 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164810.6813 [end] => 1781164810.6937 [time] => 0.012439966201782 ) [5] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164810.6939 [end] => 1781164810.6999 [time] => 0.0060479640960693 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164810.6999 [end] => 1781164810.7103 [time] => 0.010396003723145 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164810.7104 [end] => 1781164810.7812 [time] => 0.070847988128662 ) [8] => 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 deleted = '0' AND team_id in (6,25) ORDER BY lastname,firstname ASC [start] => 1781164810.7816 [end] => 1781164810.7885 [time] => 0.0069010257720947 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781164810.7901 [end] => 1781164810.7924 [time] => 0.0022380352020264 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781164810.7937 [end] => 1781164810.7945 [time] => 0.00075483322143555 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1781164810.7946 [end] => 1781164810.7996 [time] => 0.0050270557403564 ) [12] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164810.8001 [end] => 1781164810.8028 [time] => 0.002655029296875 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164810.8028 [end] => 1781164810.812 [time] => 0.0092010498046875 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164810.8121 [end] => 1781164810.8634 [time] => 0.051372051239014 ) [15] => Array ( [query] => select * from match_roster where match_id = '3186' [start] => 1781164810.8637 [end] => 1781164810.896 [time] => 0.032315015792847 ) [16] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164810.8962 [end] => 1781164810.8991 [time] => 0.002979040145874 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164810.8992 [end] => 1781164810.9077 [time] => 0.0085639953613281 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164810.9078 [end] => 1781164810.9914 [time] => 0.083618879318237 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '3186' and (point.point = 'P' or point.point = 'E') [start] => 1781164810.9983 [end] => 1781164811.3248 [time] => 0.32649993896484 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1781164811.325 [end] => 1781164811.3258 [time] => 0.00079107284545898 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1781164811.3258 [end] => 1781164811.3289 [time] => 0.0030970573425293 ) [22] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164811.329 [end] => 1781164811.3292 [time] => 0.00021696090698242 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164811.3293 [end] => 1781164811.3367 [time] => 0.0074059963226318 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164811.3367 [end] => 1781164811.4045 [time] => 0.0677809715271 ) [25] => Array ( [query] => select * from match_roster where match_id = '3186' [start] => 1781164811.4048 [end] => 1781164811.4368 [time] => 0.032011985778809 ) [26] => Array ( [query] => SELECT player_id, COALESCE( SUM( CASE WHEN point = '2' THEN point END ) ,0) as attack, COALESCE( SUM( CASE WHEN point = '3' THEN point END ) ,0) as defense, COALESCE( SUM( CASE WHEN point = '2' THEN point WHEN point = '3' THEN point END ) ,0) as total, COALESCE( SUM( CASE WHEN point = '2' THEN 1 END ) ,0) as hit_attack, COALESCE( SUM( CASE WHEN point = '3' THEN 1 END ) ,0) as hit_defense, COALESCE( SUM( CASE WHEN point = '2' THEN 1 WHEN point = '3' THEN 1 END ) ,0) as hit_total, COALESCE( SUM( CASE WHEN point = 'A' THEN 1 END ) ,0) as autohit FROM point where match_id = '3186' group by player_id [start] => 1781164811.4369 [end] => 1781164811.6799 [time] => 0.24304008483887 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '3186' [start] => 1781164811.6801 [end] => 1781164811.6804 [time] => 0.00032496452331543 ) [28] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164811.6805 [end] => 1781164811.6807 [time] => 0.00023198127746582 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164811.6807 [end] => 1781164811.6912 [time] => 0.01043701171875 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164811.6912 [end] => 1781164811.7699 [time] => 0.078644990921021 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1781164811.7708 [end] => 1781164811.7761 [time] => 0.0052962303161621 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1781164811.7762 [end] => 1781164811.7789 [time] => 0.0026888847351074 ) [33] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164811.7791 [end] => 1781164811.7809 [time] => 0.0018520355224609 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164811.781 [end] => 1781164811.8038 [time] => 0.022854089736938 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164811.8039 [end] => 1781164811.8979 [time] => 0.093955993652344 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '3186' [start] => 1781164811.8982 [end] => 1781164811.8992 [time] => 0.0010480880737305 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1781164811.8993 [end] => 1781164811.8995 [time] => 0.00020503997802734 ) [38] => Array ( [query] => select penalty_to_staff.*, staff_penalty.cumulative from penalty_to_staff inner join staff_penalty on (penalty_to_staff.staff_penalty_id = staff_penalty.staff_penalty_id) where penalty_to_staff.match_id = '3186' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1781164811.8995 [end] => 1781164811.9008 [time] => 0.001270055770874 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1781164811.9009 [end] => 1781164811.9029 [time] => 0.0020279884338379 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1781164811.903 [end] => 1781164811.9046 [time] => 0.001539945602417 ) [41] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164811.9048 [end] => 1781164811.905 [time] => 0.00023889541625977 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164811.9051 [end] => 1781164811.9149 [time] => 0.0098819732666016 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164811.915 [end] => 1781164811.9796 [time] => 0.064574003219604 ) [44] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164811.98 [end] => 1781164811.9892 [time] => 0.0092408657073975 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164811.9892 [end] => 1781164812.0006 [time] => 0.011321067810059 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164812.0006 [end] => 1781164812.053 [time] => 0.052364110946655 ) [47] => Array ( [query] => select * from match_roster where match_id = '3186' [start] => 1781164812.0533 [end] => 1781164812.0827 [time] => 0.029423952102661 ) [48] => Array ( [query] => select * from point where match_id = '3186' order by point_id ASC [start] => 1781164812.0827 [end] => 1781164812.4269 [time] => 0.3441801071167 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1781164812.4276 [end] => 1781164812.428 [time] => 0.00034284591674805 ) [50] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1781164812.4281 [end] => 1781164812.4327 [time] => 0.0046939849853516 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1781164812.4328 [end] => 1781164812.4356 [time] => 0.0028669834136963 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1781164812.4357 [end] => 1781164812.4939 [time] => 0.05820894241333 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781164812.501 [end] => 1781164812.5088 [time] => 0.0078589916229248 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781164812.5097 [end] => 1781164812.5106 [time] => 0.0009310245513916 ) )