Referto Partita: Black Knights vs Iron Lion Tyson
Black Knights
Iron Lion Tyson
RISULTATO FINALE
112
89
1° Tempo
40
34
2° Tempo
42
20
3° Tempo
30
35
INVASIONI A MURO
1
1
Data e Luogo
Campionato
Campionato Eccellenza 2023/2024 B1
Giornata: 7
Giornata: 7
Data e Luogo
15-12-2023 21:35 - Frassati
Arbitri
Primo Arbitro
Pirozzolo Domenico
Secondo Arbitro
Tombolato Barbara
Refertista
ASD Sinombre
Sorteggio
Sorteggio Vinto Da
Iron Lion Tyson
Scelta Sorteggio
Palla
Annotazioni
Refertista: Edoardo Di Noia
Progresso
Punteggi Individuali
Black Knights
-
Daniele CarboneTot.32
13
x22
x3
0
x AUTOHIT -
Fabio BragagnoloTot.13
2
x23
x3
0
x AUTOHIT -
Gianluca VarettoTot.9
3
x21
x3
0
x AUTOHIT -
Lorenzo De Nicola CivitareseTot.21
6
x23
x3
0
x AUTOHIT -
Marco AntinoroTot.9
3
x21
x3
1
x AUTOHIT -
Paolo GazzolaTot.11
4
x21
x3
0
x AUTOHIT -
Giacomo GuarratoTot.16
8
x20
x3
0
x AUTOHIT
Iron Lion Tyson
-
Marco Barrasso
4
x24
x3
0
x AUTOHITTot.20
Divisa di gioco non regolamentare (Minuto: - 1T)Cristina Vaudagna
0
x20
x3
0
x AUTOHITTot.0
Cherif Balde
2
x22
x3
1
x AUTOHITTot.10
Mario Franchi
0
x20
x3
0
x AUTOHITTot.0
Paul Mihei
6
x24
x3
0
x AUTOHITTot.24
SIlvia Petiti
0
x20
x3
0
x AUTOHITTot.0
Roberto Amin Abdou Awad
0
x20
x3
0
x AUTOHITTot.0
Emiliano Travaglini
9
x24
x3
0
x AUTOHITTot.30
Simone Garino
2
x20
x3
0
x AUTOHITTot.4
Sanzioni Disciplinari
Black Knights
Iron Lion Tyson
-
8. Marco BarrassoDivisa di gioco non regolamentare (Minuto: - 1T)
Total Queries: 55 Total Time: 0.38290786743164 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1781155831.1662 [end] => 1781155831.1665 [time] => 0.00027298927307129 ) [1] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.1688 [end] => 1781155831.1691 [time] => 0.00026607513427734 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.1691 [end] => 1781155831.1716 [time] => 0.0024302005767822 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.1717 [end] => 1781155831.1847 [time] => 0.013018131256104 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.1851 [end] => 1781155831.1875 [time] => 0.0024480819702148 ) [5] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.1876 [end] => 1781155831.1878 [time] => 0.00023293495178223 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.1879 [end] => 1781155831.1902 [time] => 0.0023698806762695 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.1903 [end] => 1781155831.2032 [time] => 0.01296591758728 ) [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 (23,25) ORDER BY lastname,firstname ASC [start] => 1781155831.2036 [end] => 1781155831.205 [time] => 0.0013160705566406 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781155831.2069 [end] => 1781155831.2073 [time] => 0.0004279613494873 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781155831.2077 [end] => 1781155831.2081 [time] => 0.00034618377685547 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1781155831.2081 [end] => 1781155831.2088 [time] => 0.00062203407287598 ) [12] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.2092 [end] => 1781155831.2094 [time] => 0.00021696090698242 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.2094 [end] => 1781155831.2119 [time] => 0.0024149417877197 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.212 [end] => 1781155831.2251 [time] => 0.013118982315063 ) [15] => Array ( [query] => select * from match_roster where match_id = '3180' [start] => 1781155831.2254 [end] => 1781155831.2335 [time] => 0.0081231594085693 ) [16] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.2336 [end] => 1781155831.2339 [time] => 0.00029397010803223 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.2339 [end] => 1781155831.2363 [time] => 0.0024359226226807 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.2364 [end] => 1781155831.2493 [time] => 0.012917995452881 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '3180' and (point.point = 'P' or point.point = 'E') [start] => 1781155831.2518 [end] => 1781155831.3265 [time] => 0.074779033660889 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1781155831.3267 [end] => 1781155831.327 [time] => 0.00030994415283203 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1781155831.3271 [end] => 1781155831.3273 [time] => 0.00018501281738281 ) [22] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.3273 [end] => 1781155831.3276 [time] => 0.00021886825561523 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.3276 [end] => 1781155831.33 [time] => 0.0024189949035645 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.33 [end] => 1781155831.343 [time] => 0.012986898422241 ) [25] => Array ( [query] => select * from match_roster where match_id = '3180' [start] => 1781155831.3433 [end] => 1781155831.3513 [time] => 0.0080451965332031 ) [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 = '3180' group by player_id [start] => 1781155831.3514 [end] => 1781155831.3991 [time] => 0.047759056091309 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '3180' [start] => 1781155831.3993 [end] => 1781155831.3997 [time] => 0.00036215782165527 ) [28] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.3997 [end] => 1781155831.4 [time] => 0.00022101402282715 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.4 [end] => 1781155831.4024 [time] => 0.0023701190948486 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.4025 [end] => 1781155831.4155 [time] => 0.01300311088562 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1781155831.4158 [end] => 1781155831.4161 [time] => 0.0002601146697998 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1781155831.4162 [end] => 1781155831.4167 [time] => 0.00055408477783203 ) [33] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.4169 [end] => 1781155831.4171 [time] => 0.00019717216491699 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.4171 [end] => 1781155831.4195 [time] => 0.0023550987243652 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.4195 [end] => 1781155831.4324 [time] => 0.012871980667114 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '3180' [start] => 1781155831.4327 [end] => 1781155831.4337 [time] => 0.00097990036010742 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1781155831.4338 [end] => 1781155831.434 [time] => 0.00017094612121582 ) [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 = '3180' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1781155831.434 [end] => 1781155831.4342 [time] => 0.00020503997802734 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1781155831.4343 [end] => 1781155831.4344 [time] => 0.00015401840209961 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1781155831.4345 [end] => 1781155831.4346 [time] => 0.00013995170593262 ) [41] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.4348 [end] => 1781155831.435 [time] => 0.0001828670501709 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.435 [end] => 1781155831.4374 [time] => 0.0024411678314209 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.4375 [end] => 1781155831.4503 [time] => 0.01286506652832 ) [44] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.4507 [end] => 1781155831.4509 [time] => 0.00024104118347168 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.4509 [end] => 1781155831.4533 [time] => 0.002410888671875 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.4534 [end] => 1781155831.4662 [time] => 0.012870073318481 ) [47] => Array ( [query] => select * from match_roster where match_id = '3180' [start] => 1781155831.4665 [end] => 1781155831.4745 [time] => 0.0080299377441406 ) [48] => Array ( [query] => select * from point where match_id = '3180' order by point_id ASC [start] => 1781155831.4746 [end] => 1781155831.5449 [time] => 0.070338010787964 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1781155831.5457 [end] => 1781155831.546 [time] => 0.00032210350036621 ) [50] => Array ( [query] => select * from matches where match_id = '3180' [start] => 1781155831.546 [end] => 1781155831.5463 [time] => 0.00021100044250488 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3180' [start] => 1781155831.5463 [end] => 1781155831.5487 [time] => 0.0024309158325195 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3180' [start] => 1781155831.5488 [end] => 1781155831.5618 [time] => 0.01305079460144 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781155831.5644 [end] => 1781155831.5649 [time] => 0.00047588348388672 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781155831.5657 [end] => 1781155831.566 [time] => 0.00025200843811035 ) )