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: 0.95924878120422 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1776067179.6108 [end] => 1776067179.6127 [time] => 0.001943826675415 ) [1] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067179.615 [end] => 1776067179.6153 [time] => 0.00030398368835449 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067179.6153 [end] => 1776067179.6267 [time] => 0.011415958404541 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067179.6269 [end] => 1776067179.6532 [time] => 0.026309013366699 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067179.6536 [end] => 1776067179.6578 [time] => 0.0042538642883301 ) [5] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067179.658 [end] => 1776067179.6582 [time] => 0.00025582313537598 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067179.6582 [end] => 1776067179.6627 [time] => 0.0045030117034912 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067179.6628 [end] => 1776067179.6888 [time] => 0.025996923446655 ) [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] => 1776067179.6893 [end] => 1776067179.6911 [time] => 0.0018508434295654 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776067179.694 [end] => 1776067179.6945 [time] => 0.00042295455932617 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776067179.6949 [end] => 1776067179.6964 [time] => 0.0015401840209961 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1776067179.6965 [end] => 1776067179.6973 [time] => 0.00073790550231934 ) [12] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067179.6978 [end] => 1776067179.6997 [time] => 0.0019729137420654 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067179.6998 [end] => 1776067179.7058 [time] => 0.0060000419616699 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067179.7058 [end] => 1776067179.73 [time] => 0.024172067642212 ) [15] => Array ( [query] => select * from match_roster where match_id = '3186' [start] => 1776067179.7303 [end] => 1776067179.7421 [time] => 0.011802911758423 ) [16] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067179.7422 [end] => 1776067179.745 [time] => 0.0027139186859131 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067179.745 [end] => 1776067179.7493 [time] => 0.0042669773101807 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067179.7493 [end] => 1776067179.7781 [time] => 0.028787851333618 ) [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] => 1776067179.7813 [end] => 1776067179.9877 [time] => 0.20635509490967 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1776067179.9879 [end] => 1776067179.9882 [time] => 0.00028800964355469 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1776067179.9882 [end] => 1776067179.9909 [time] => 0.0027120113372803 ) [22] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067179.9911 [end] => 1776067179.9913 [time] => 0.00023198127746582 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067179.9913 [end] => 1776067179.9978 [time] => 0.0064811706542969 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067179.9979 [end] => 1776067180.0378 [time] => 0.039972066879272 ) [25] => Array ( [query] => select * from match_roster where match_id = '3186' [start] => 1776067180.0381 [end] => 1776067180.0551 [time] => 0.016963005065918 ) [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] => 1776067180.0551 [end] => 1776067180.1892 [time] => 0.13408899307251 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '3186' [start] => 1776067180.1894 [end] => 1776067180.192 [time] => 0.0026421546936035 ) [28] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067180.1921 [end] => 1776067180.1928 [time] => 0.00068306922912598 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067180.1928 [end] => 1776067180.1988 [time] => 0.0060350894927979 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067180.1989 [end] => 1776067180.2372 [time] => 0.038331031799316 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1776067180.2375 [end] => 1776067180.2378 [time] => 0.00026392936706543 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1776067180.2379 [end] => 1776067180.2385 [time] => 0.00059080123901367 ) [33] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067180.2387 [end] => 1776067180.2397 [time] => 0.0010049343109131 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067180.2397 [end] => 1776067180.2486 [time] => 0.0088942050933838 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067180.2487 [end] => 1776067180.2816 [time] => 0.032902956008911 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '3186' [start] => 1776067180.2819 [end] => 1776067180.2865 [time] => 0.0045690536499023 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1776067180.2866 [end] => 1776067180.2868 [time] => 0.00022292137145996 ) [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] => 1776067180.2868 [end] => 1776067180.2871 [time] => 0.00030684471130371 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1776067180.2872 [end] => 1776067180.2879 [time] => 0.00069999694824219 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1776067180.288 [end] => 1776067180.2885 [time] => 0.00049805641174316 ) [41] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067180.2887 [end] => 1776067180.2899 [time] => 0.001237154006958 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067180.2899 [end] => 1776067180.2992 [time] => 0.0092599391937256 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067180.2993 [end] => 1776067180.3378 [time] => 0.038496017456055 ) [44] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067180.3381 [end] => 1776067180.34 [time] => 0.0018420219421387 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067180.34 [end] => 1776067180.3461 [time] => 0.0060899257659912 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067180.3461 [end] => 1776067180.3796 [time] => 0.033416986465454 ) [47] => Array ( [query] => select * from match_roster where match_id = '3186' [start] => 1776067180.3799 [end] => 1776067180.3997 [time] => 0.019775867462158 ) [48] => Array ( [query] => select * from point where match_id = '3186' order by point_id ASC [start] => 1776067180.3998 [end] => 1776067180.5684 [time] => 0.16864585876465 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1776067180.5702 [end] => 1776067180.5705 [time] => 0.00029492378234863 ) [50] => Array ( [query] => select * from matches where match_id = '3186' [start] => 1776067180.5706 [end] => 1776067180.5714 [time] => 0.00077414512634277 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3186' [start] => 1776067180.5714 [end] => 1776067180.5735 [time] => 0.0021529197692871 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3186' [start] => 1776067180.5736 [end] => 1776067180.5862 [time] => 0.012544870376587 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776067180.5887 [end] => 1776067180.5892 [time] => 0.00046777725219727 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776067180.59 [end] => 1776067180.5902 [time] => 0.00026202201843262 ) )