Referto Partita: Trefferspan vs Iron Lion Tyson
Trefferspan
Iron Lion Tyson
RISULTATO FINALE
77
86
1° Tempo
19
22
2° Tempo
27
28
3° Tempo
31
36
INVASIONI A MURO
0
0
Data e Luogo
Evento
Playout 2024
Data e Luogo
16-05-2024 21:30 - Frassati
Arbitri
Primo Arbitro
Agnelli Filippo
Secondo Arbitro
Agnelli Filippo
Refertista
ASD Sinombre
Sorteggio
Sorteggio Vinto Da
Trefferspan
Scelta Sorteggio
Palla
Annotazioni
refertista: Edoardo Di Noia
addetto media: Stefano Truzzi
Progresso
Punteggi Individuali
Trefferspan
-
Francesco CrociTot.8
4
x20
x3
0
x AUTOHIT -
Davide RivettiTot.8
4
x20
x3
0
x AUTOHIT -
Jacopo MarchitelliTot.37
14
x23
x3
0
x AUTOHIT -
Simone BasanoTot.4
2
x20
x3
0
x AUTOHIT -
Giulio CocirioTot.20
7
x22
x3
0
x AUTOHIT -
Emanuele NigroTot.0
0
x20
x3
0
x AUTOHIT -
Gabriele Di StefanoTot.0
0
x20
x3
0
x AUTOHIT
Iron Lion Tyson
-
Marco Barrasso
8
x21
x3
0
x AUTOHITTot.19
Cristina Vaudagna
1
x20
x3
0
x AUTOHITTot.2
Alberico Franzin
0
x20
x3
0
x AUTOHITTot.0
Mario Franchi
0
x20
x3
0
x AUTOHITTot.0
Paul Mihei
9
x26
x3
0
x AUTOHITTot.36
Francesco Rigoni
1
x21
x3
0
x AUTOHITTot.5
SIlvia Petiti
0
x20
x3
0
x AUTOHITTot.0
Emiliano Travaglini
12
x20
x3
0
x AUTOHITTot.24
Simone Garino
0
x20
x3
0
x AUTOHITTot.0
Total Queries: 55 Total Time: 0.38453125953674 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1786253221.5443 [end] => 1786253221.5446 [time] => 0.00027084350585938 ) [1] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.5469 [end] => 1786253221.5472 [time] => 0.00024104118347168 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.5472 [end] => 1786253221.5496 [time] => 0.0024218559265137 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.5497 [end] => 1786253221.5625 [time] => 0.012793064117432 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.5629 [end] => 1786253221.5654 [time] => 0.0024740695953369 ) [5] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.5655 [end] => 1786253221.5657 [time] => 0.000244140625 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.5657 [end] => 1786253221.5681 [time] => 0.0023300647735596 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.5681 [end] => 1786253221.5808 [time] => 0.012710094451904 ) [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 (27,25) ORDER BY lastname,firstname ASC [start] => 1786253221.5812 [end] => 1786253221.5824 [time] => 0.0012130737304688 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1786253221.5843 [end] => 1786253221.5848 [time] => 0.0005040168762207 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1786253221.5852 [end] => 1786253221.5858 [time] => 0.00052213668823242 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1786253221.5858 [end] => 1786253221.5865 [time] => 0.00062298774719238 ) [12] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.5869 [end] => 1786253221.5872 [time] => 0.00022101402282715 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.5872 [end] => 1786253221.5896 [time] => 0.0023910999298096 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.5896 [end] => 1786253221.6024 [time] => 0.012825965881348 ) [15] => Array ( [query] => select * from match_roster where match_id = '3351' [start] => 1786253221.6028 [end] => 1786253221.6108 [time] => 0.0080740451812744 ) [16] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.611 [end] => 1786253221.6113 [time] => 0.00029706954956055 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.6113 [end] => 1786253221.6137 [time] => 0.0024118423461914 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.6138 [end] => 1786253221.6265 [time] => 0.012777805328369 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '3351' and (point.point = 'P' or point.point = 'E') [start] => 1786253221.629 [end] => 1786253221.7038 [time] => 0.074756145477295 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1786253221.7039 [end] => 1786253221.7042 [time] => 0.00033092498779297 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1786253221.7043 [end] => 1786253221.7044 [time] => 0.00017619132995605 ) [22] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.7045 [end] => 1786253221.7048 [time] => 0.0002291202545166 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.7048 [end] => 1786253221.7072 [time] => 0.0024611949920654 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.7073 [end] => 1786253221.7205 [time] => 0.013156890869141 ) [25] => Array ( [query] => select * from match_roster where match_id = '3351' [start] => 1786253221.7208 [end] => 1786253221.7288 [time] => 0.0080161094665527 ) [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 = '3351' group by player_id [start] => 1786253221.7288 [end] => 1786253221.7764 [time] => 0.047603845596313 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '3351' [start] => 1786253221.7766 [end] => 1786253221.777 [time] => 0.00042104721069336 ) [28] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.7771 [end] => 1786253221.7773 [time] => 0.00024294853210449 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.7773 [end] => 1786253221.7798 [time] => 0.0024209022521973 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.7798 [end] => 1786253221.7926 [time] => 0.012785196304321 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1786253221.793 [end] => 1786253221.7932 [time] => 0.00025606155395508 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1786253221.7933 [end] => 1786253221.7939 [time] => 0.0005800724029541 ) [33] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.7941 [end] => 1786253221.7943 [time] => 0.0002291202545166 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.7943 [end] => 1786253221.7967 [time] => 0.0023670196533203 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.7967 [end] => 1786253221.8101 [time] => 0.013313055038452 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '3351' [start] => 1786253221.8103 [end] => 1786253221.8114 [time] => 0.001025915145874 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1786253221.8115 [end] => 1786253221.8116 [time] => 0.0001671314239502 ) [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 = '3351' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1786253221.8116 [end] => 1786253221.8119 [time] => 0.00022792816162109 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1786253221.8119 [end] => 1786253221.8121 [time] => 0.00015711784362793 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1786253221.8121 [end] => 1786253221.8123 [time] => 0.00013995170593262 ) [41] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.8124 [end] => 1786253221.8126 [time] => 0.00017285346984863 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.8126 [end] => 1786253221.815 [time] => 0.0023889541625977 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.8151 [end] => 1786253221.8278 [time] => 0.012769937515259 ) [44] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.8281 [end] => 1786253221.8284 [time] => 0.00022983551025391 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.8284 [end] => 1786253221.8308 [time] => 0.0024051666259766 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.8309 [end] => 1786253221.8438 [time] => 0.012964010238647 ) [47] => Array ( [query] => select * from match_roster where match_id = '3351' [start] => 1786253221.8441 [end] => 1786253221.8532 [time] => 0.0091321468353271 ) [48] => Array ( [query] => select * from point where match_id = '3351' order by point_id ASC [start] => 1786253221.8533 [end] => 1786253221.9249 [time] => 0.071584939956665 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1786253221.9256 [end] => 1786253221.926 [time] => 0.00035500526428223 ) [50] => Array ( [query] => select * from matches where match_id = '3351' [start] => 1786253221.926 [end] => 1786253221.9262 [time] => 0.0002140998840332 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3351' [start] => 1786253221.9263 [end] => 1786253221.9286 [time] => 0.002377986907959 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3351' [start] => 1786253221.9287 [end] => 1786253221.9415 [time] => 0.012800216674805 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1786253221.9442 [end] => 1786253221.9446 [time] => 0.00045108795166016 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1786253221.9455 [end] => 1786253221.9458 [time] => 0.0002748966217041 ) )