Referto Partita: Krakens Chivasso vs Iron Lion Tyson
Krakens Chivasso
Iron Lion Tyson
RISULTATO FINALE
59
69
1° Tempo
15
22
2° Tempo
24
22
3° Tempo
20
25
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 B2
Giornata: 4
Giornata: 4
Data e Luogo
27-11-2021 14:30 - Palazzeschi
Arbitri
Primo Arbitro
Da Re Francesca
Secondo Arbitro
Botosso Daniele
Refertista
Botosso Daniele
Sorteggio
Sorteggio Vinto Da
Iron Lion Tyson
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Krakens Chivasso
-
Davide MartiniTot.16
5
x22
x3
1
x AUTOHIT -
Andrea MerloTot.23
7
x23
x3
0
x AUTOHIT -
Luca TorreanoTot.15
3
x23
x3
0
x AUTOHIT -
Gianluca ParisiTot.
2
1
x20
x3
0
x AUTOHIT -
Francesco GhioTot.0
0
x20
x3
0
x AUTOHIT -
Alessio ArganoTot.3
0
x21
x3
0
x AUTOHITComportamento scorretto o antisportivo (Minuto: 4 - 3T)
Iron Lion Tyson
-
Roberto Amin Abdou Awad
3
x21
x3
0
x AUTOHITTot.9
Federico Perno
6
x23
x3
0
x AUTOHITTot.21
Alberico Franzin
1
x20
x3
0
x AUTOHITTot.2
Mario Franchi
0
x20
x3
0
x AUTOHITTot.0
Paul Mihei
8
x20
x3
0
x AUTOHITTot.16
Francesco Rigoni
4
x20
x3
0
x AUTOHITTot.8
SIlvia Petiti
0
x20
x3
0
x AUTOHITTot.0
Emiliano Travaglini
5
x20
x3
0
x AUTOHITTot.10
Simone Garino
1
x20
x3
0
x AUTOHITTot.2
Sanzioni Disciplinari
Krakens Chivasso
-
90. Alessio ArganoComportamento scorretto o antisportivo (Minuto: 4 - 3T)
Iron Lion Tyson
Total Queries: 55 Total Time: 0.5575692653656 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1786249547.8377 [end] => 1786249547.8379 [time] => 0.0002138614654541 ) [1] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249547.8431 [end] => 1786249547.8434 [time] => 0.00023913383483887 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249547.8434 [end] => 1786249547.8475 [time] => 0.0040910243988037 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249547.8476 [end] => 1786249547.8752 [time] => 0.027580976486206 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249547.8755 [end] => 1786249547.8787 [time] => 0.0032198429107666 ) [5] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249547.8788 [end] => 1786249547.8819 [time] => 0.0031168460845947 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249547.8819 [end] => 1786249547.8863 [time] => 0.004371166229248 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249547.8863 [end] => 1786249547.9214 [time] => 0.035085916519165 ) [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 (9,25) ORDER BY lastname,firstname ASC [start] => 1786249547.9218 [end] => 1786249547.9249 [time] => 0.0030949115753174 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1786249547.9268 [end] => 1786249547.9291 [time] => 0.0023119449615479 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1786249547.9295 [end] => 1786249547.9298 [time] => 0.0002739429473877 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1786249547.9299 [end] => 1786249547.9305 [time] => 0.0006110668182373 ) [12] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249547.931 [end] => 1786249547.9339 [time] => 0.0029618740081787 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249547.9339 [end] => 1786249547.9381 [time] => 0.0042119026184082 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249547.9382 [end] => 1786249547.9685 [time] => 0.030303955078125 ) [15] => Array ( [query] => select * from match_roster where match_id = '2026' [start] => 1786249547.9687 [end] => 1786249547.9858 [time] => 0.017097949981689 ) [16] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249547.986 [end] => 1786249547.9886 [time] => 0.0026659965515137 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249547.9887 [end] => 1786249547.9941 [time] => 0.005483865737915 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249547.9942 [end] => 1786249548.0266 [time] => 0.032376050949097 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2026' and (point.point = 'P' or point.point = 'E') [start] => 1786249548.029 [end] => 1786249548.1458 [time] => 0.11679315567017 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1786249548.1459 [end] => 1786249548.1462 [time] => 0.00029993057250977 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1786249548.1463 [end] => 1786249548.1465 [time] => 0.00018501281738281 ) [22] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249548.1466 [end] => 1786249548.1468 [time] => 0.00026297569274902 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249548.1469 [end] => 1786249548.1493 [time] => 0.0023999214172363 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249548.1493 [end] => 1786249548.1624 [time] => 0.013063907623291 ) [25] => Array ( [query] => select * from match_roster where match_id = '2026' [start] => 1786249548.1626 [end] => 1786249548.1708 [time] => 0.0081789493560791 ) [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 = '2026' group by player_id [start] => 1786249548.1708 [end] => 1786249548.2269 [time] => 0.056041955947876 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2026' [start] => 1786249548.2271 [end] => 1786249548.2275 [time] => 0.00038599967956543 ) [28] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249548.2275 [end] => 1786249548.2286 [time] => 0.0011107921600342 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249548.2287 [end] => 1786249548.2313 [time] => 0.0026321411132812 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249548.2314 [end] => 1786249548.2465 [time] => 0.015093088150024 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1786249548.2468 [end] => 1786249548.247 [time] => 0.00027203559875488 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1786249548.2471 [end] => 1786249548.2478 [time] => 0.0007171630859375 ) [33] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249548.248 [end] => 1786249548.2483 [time] => 0.00028610229492188 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249548.2484 [end] => 1786249548.2508 [time] => 0.0024850368499756 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249548.2509 [end] => 1786249548.2692 [time] => 0.018316030502319 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2026' [start] => 1786249548.2695 [end] => 1786249548.2714 [time] => 0.0019838809967041 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1786249548.2716 [end] => 1786249548.273 [time] => 0.0014040470123291 ) [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 = '2026' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1786249548.273 [end] => 1786249548.2732 [time] => 0.00025796890258789 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1786249548.2733 [end] => 1786249548.2736 [time] => 0.00023698806762695 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1786249548.2736 [end] => 1786249548.2739 [time] => 0.00021600723266602 ) [41] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249548.2741 [end] => 1786249548.2743 [time] => 0.00023007392883301 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249548.2743 [end] => 1786249548.2803 [time] => 0.0060369968414307 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249548.2804 [end] => 1786249548.2974 [time] => 0.017000913619995 ) [44] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249548.2978 [end] => 1786249548.2981 [time] => 0.00031805038452148 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249548.2981 [end] => 1786249548.3005 [time] => 0.0024211406707764 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249548.3006 [end] => 1786249548.3135 [time] => 0.012859106063843 ) [47] => Array ( [query] => select * from match_roster where match_id = '2026' [start] => 1786249548.3138 [end] => 1786249548.3218 [time] => 0.0080599784851074 ) [48] => Array ( [query] => select * from point where match_id = '2026' order by point_id ASC [start] => 1786249548.3219 [end] => 1786249548.3939 [time] => 0.072020053863525 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1786249548.3945 [end] => 1786249548.3948 [time] => 0.00030398368835449 ) [50] => Array ( [query] => select * from matches where match_id = '2026' [start] => 1786249548.3949 [end] => 1786249548.3951 [time] => 0.0002138614654541 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2026' [start] => 1786249548.3951 [end] => 1786249548.3976 [time] => 0.0024130344390869 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2026' [start] => 1786249548.3976 [end] => 1786249548.4105 [time] => 0.012861013412476 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1786249548.4132 [end] => 1786249548.4138 [time] => 0.00056290626525879 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1786249548.4146 [end] => 1786249548.4149 [time] => 0.00033283233642578 ) )