Referto Partita: Vinsero Battaglie Chivasso vs AS Intomatici
Vinsero Battaglie Chivasso
AS Intomatici
RISULTATO FINALE
34
57
1° Tempo
10
20
2° Tempo
14
19
3° Tempo
10
18
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 B2
Giornata: 13
Giornata: 13
Data e Luogo
29-03-2022 20:30 - Palazzeschi
Arbitri
Primo Arbitro
Rovai Filippo
Secondo Arbitro
Petrosino Alessio
Refertista
Petrosino Alessio
Sorteggio
Sorteggio Vinto Da
AS Intomatici
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Vinsero Battaglie Chivasso
-
Chiara D'AlessandraTot.4
2
x20
x3
0
x AUTOHIT -
Elena PasinoTot.20
10
x20
x3
0
x AUTOHIT -
Claudia MilitelloTot.6
3
x20
x3
0
x AUTOHIT -
Simona IsnardiTot.4
2
x20
x3
0
x AUTOHIT -
Francesca BargelliTot.0
0
x20
x3
0
x AUTOHIT
AS Intomatici
-
Giulio Cocirio
6
x22
x3
0
x AUTOHITTot.18
Jacopo Marchitelli
7
x20
x3
0
x AUTOHITTot.14
Andrea Rossotto
0
x20
x3
0
x AUTOHITTot.0
Edoardo Di Noia
3
x20
x3
0
x AUTOHITTot.6
Francesco Croci
3
x21
x3
0
x AUTOHITTot.9
Simone Basano
1
x20
x3
0
x AUTOHITTot.2
Samuele Carnelli
0
x20
x3
0
x AUTOHITTot.0
Pier Paolo Specchiulli
3
x20
x3
0
x AUTOHITTot.6
Gabriele Di Stefano
1
x20
x3
0
x AUTOHITTot.2
Total Queries: 55 Total Time: 0.34937024116516 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1770972501.769 [end] => 1770972501.7693 [time] => 0.00030303001403809 ) [1] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972501.7715 [end] => 1770972501.7718 [time] => 0.00031685829162598 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972501.7718 [end] => 1770972501.7739 [time] => 0.002108097076416 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972501.774 [end] => 1770972501.786 [time] => 0.012022972106934 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972501.7863 [end] => 1770972501.7895 [time] => 0.0031750202178955 ) [5] => 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' ORDER BY lastname,firstname ASC [start] => 1770972501.7898 [end] => 1770972501.796 [time] => 0.0062639713287354 ) [6] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770972501.7994 [end] => 1770972501.7999 [time] => 0.0005040168762207 ) [7] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770972501.8003 [end] => 1770972501.8006 [time] => 0.00028395652770996 ) [8] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1770972501.8006 [end] => 1770972501.8013 [time] => 0.0006718635559082 ) [9] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972501.8018 [end] => 1770972501.802 [time] => 0.00020313262939453 ) [10] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972501.802 [end] => 1770972501.8041 [time] => 0.0020561218261719 ) [11] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972501.8041 [end] => 1770972501.8161 [time] => 0.012013912200928 ) [12] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1770972501.8164 [end] => 1770972501.8234 [time] => 0.0070400238037109 ) [13] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972501.8236 [end] => 1770972501.8239 [time] => 0.00030684471130371 ) [14] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972501.8239 [end] => 1770972501.826 [time] => 0.0020899772644043 ) [15] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972501.826 [end] => 1770972501.8381 [time] => 0.012037038803101 ) [16] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2015' and (point.point = 'P' or point.point = 'E') [start] => 1770972501.8402 [end] => 1770972501.9061 [time] => 0.065948009490967 ) [17] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1770972501.9063 [end] => 1770972501.9066 [time] => 0.00033712387084961 ) [18] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1770972501.9067 [end] => 1770972501.9069 [time] => 0.00020503997802734 ) [19] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972501.907 [end] => 1770972501.9072 [time] => 0.00023317337036133 ) [20] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972501.9072 [end] => 1770972501.9093 [time] => 0.0021028518676758 ) [21] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972501.9094 [end] => 1770972501.9214 [time] => 0.012070894241333 ) [22] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1770972501.9217 [end] => 1770972501.9287 [time] => 0.0069589614868164 ) [23] => 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 = '2015' group by player_id [start] => 1770972501.9287 [end] => 1770972501.9706 [time] => 0.041898965835571 ) [24] => Array ( [query] => select * from penalty_to_team where match_id = '2015' [start] => 1770972501.9708 [end] => 1770972501.9711 [time] => 0.00032901763916016 ) [25] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972501.9712 [end] => 1770972501.9714 [time] => 0.00019502639770508 ) [26] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972501.9714 [end] => 1770972501.9735 [time] => 0.0020689964294434 ) [27] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972501.9735 [end] => 1770972501.9856 [time] => 0.012032985687256 ) [28] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1770972501.9859 [end] => 1770972501.9861 [time] => 0.00022292137145996 ) [29] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1770972501.9862 [end] => 1770972501.9868 [time] => 0.00058388710021973 ) [30] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972501.987 [end] => 1770972501.9872 [time] => 0.00021982192993164 ) [31] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972501.9872 [end] => 1770972501.9892 [time] => 0.002061128616333 ) [32] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972501.9893 [end] => 1770972502.0013 [time] => 0.011995792388916 ) [33] => Array ( [query] => select * from match_staff_roster where match_id = '2015' [start] => 1770972502.0015 [end] => 1770972502.0023 [time] => 0.00081396102905273 ) [34] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1770972502.0024 [end] => 1770972502.0026 [time] => 0.00017905235290527 ) [35] => 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 = '2015' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1770972502.0026 [end] => 1770972502.0028 [time] => 0.0002140998840332 ) [36] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1770972502.0029 [end] => 1770972502.0031 [time] => 0.00016498565673828 ) [37] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1770972502.0031 [end] => 1770972502.0032 [time] => 0.00011897087097168 ) [38] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972502.0034 [end] => 1770972502.0035 [time] => 0.00016498565673828 ) [39] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972502.0036 [end] => 1770972502.0056 [time] => 0.0020642280578613 ) [40] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972502.0057 [end] => 1770972502.0176 [time] => 0.011931180953979 ) [41] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972502.0179 [end] => 1770972502.0182 [time] => 0.00027799606323242 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972502.0182 [end] => 1770972502.0203 [time] => 0.0020451545715332 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972502.0203 [end] => 1770972502.0323 [time] => 0.012029886245728 ) [44] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1770972502.0326 [end] => 1770972502.0395 [time] => 0.0069580078125 ) [45] => Array ( [query] => select * from point where match_id = '2015' order by point_id ASC [start] => 1770972502.0396 [end] => 1770972502.1012 [time] => 0.061664819717407 ) [46] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972502.1017 [end] => 1770972502.1021 [time] => 0.00030994415283203 ) [47] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972502.1021 [end] => 1770972502.1041 [time] => 0.0020749568939209 ) [48] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972502.1042 [end] => 1770972502.1164 [time] => 0.01217794418335 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1770972502.1168 [end] => 1770972502.1172 [time] => 0.00033211708068848 ) [50] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1770972502.1172 [end] => 1770972502.1174 [time] => 0.00020289421081543 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1770972502.1174 [end] => 1770972502.1195 [time] => 0.00205397605896 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1770972502.1195 [end] => 1770972502.1315 [time] => 0.011983871459961 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770972502.134 [end] => 1770972502.1345 [time] => 0.00048685073852539 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770972502.1353 [end] => 1770972502.1356 [time] => 0.0002589225769043 ) )