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.34590554237366 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1776066845.7835 [end] => 1776066845.7837 [time] => 0.0002751350402832 ) [1] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066845.786 [end] => 1776066845.7862 [time] => 0.00021004676818848 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066845.7862 [end] => 1776066845.7883 [time] => 0.0021069049835205 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066845.7884 [end] => 1776066845.8005 [time] => 0.01210618019104 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066845.8008 [end] => 1776066845.8029 [time] => 0.0021169185638428 ) [5] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066845.803 [end] => 1776066845.8032 [time] => 0.0001988410949707 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066845.8032 [end] => 1776066845.8053 [time] => 0.0020461082458496 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066845.8053 [end] => 1776066845.8175 [time] => 0.012211799621582 ) [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 (10,27) ORDER BY lastname,firstname ASC [start] => 1776066845.818 [end] => 1776066845.8189 [time] => 0.00095701217651367 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776066845.8204 [end] => 1776066845.8208 [time] => 0.00046491622924805 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776066845.8212 [end] => 1776066845.8215 [time] => 0.00026297569274902 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1776066845.8215 [end] => 1776066845.8222 [time] => 0.0006248950958252 ) [12] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066845.8226 [end] => 1776066845.8228 [time] => 0.00023603439331055 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066845.8229 [end] => 1776066845.825 [time] => 0.0021111965179443 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066845.825 [end] => 1776066845.8372 [time] => 0.012140035629272 ) [15] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1776066845.8374 [end] => 1776066845.8444 [time] => 0.0069789886474609 ) [16] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066845.8445 [end] => 1776066845.8456 [time] => 0.0010941028594971 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066845.8457 [end] => 1776066845.8479 [time] => 0.0021810531616211 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066845.848 [end] => 1776066845.8601 [time] => 0.012160062789917 ) [19] => 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] => 1776066845.8623 [end] => 1776066845.9287 [time] => 0.066449165344238 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1776066845.9289 [end] => 1776066845.9292 [time] => 0.00031304359436035 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1776066845.9293 [end] => 1776066845.9295 [time] => 0.00018000602722168 ) [22] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066845.9295 [end] => 1776066845.9298 [time] => 0.00022220611572266 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066845.9298 [end] => 1776066845.9319 [time] => 0.002094030380249 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066845.9319 [end] => 1776066845.9441 [time] => 0.012119054794312 ) [25] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1776066845.9443 [end] => 1776066845.9512 [time] => 0.0068998336791992 ) [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 = '2015' group by player_id [start] => 1776066845.9513 [end] => 1776066845.9934 [time] => 0.042135953903198 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2015' [start] => 1776066845.9936 [end] => 1776066845.994 [time] => 0.0003819465637207 ) [28] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066845.994 [end] => 1776066845.9942 [time] => 0.00019407272338867 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066845.9942 [end] => 1776066845.9963 [time] => 0.0020759105682373 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066845.9964 [end] => 1776066846.0084 [time] => 0.012014150619507 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1776066846.0086 [end] => 1776066846.0089 [time] => 0.00024604797363281 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1776066846.009 [end] => 1776066846.0095 [time] => 0.00054311752319336 ) [33] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066846.0097 [end] => 1776066846.01 [time] => 0.00022506713867188 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066846.01 [end] => 1776066846.0121 [time] => 0.0020811557769775 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066846.0121 [end] => 1776066846.0241 [time] => 0.012006998062134 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2015' [start] => 1776066846.0243 [end] => 1776066846.0251 [time] => 0.00079703330993652 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1776066846.0252 [end] => 1776066846.0254 [time] => 0.00016880035400391 ) [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 = '2015' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1776066846.0254 [end] => 1776066846.0256 [time] => 0.00020980834960938 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1776066846.0257 [end] => 1776066846.0258 [time] => 0.00017189979553223 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1776066846.0259 [end] => 1776066846.026 [time] => 0.00012898445129395 ) [41] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066846.0262 [end] => 1776066846.0263 [time] => 0.00016283988952637 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066846.0263 [end] => 1776066846.0284 [time] => 0.0020828247070312 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066846.0285 [end] => 1776066846.0405 [time] => 0.012067079544067 ) [44] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066846.0409 [end] => 1776066846.0411 [time] => 0.00021719932556152 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066846.0411 [end] => 1776066846.0437 [time] => 0.0025801658630371 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066846.0438 [end] => 1776066846.0559 [time] => 0.012110948562622 ) [47] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1776066846.0562 [end] => 1776066846.0631 [time] => 0.0069169998168945 ) [48] => Array ( [query] => select * from point where match_id = '2015' order by point_id ASC [start] => 1776066846.0632 [end] => 1776066846.1254 [time] => 0.062233924865723 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1776066846.1261 [end] => 1776066846.1264 [time] => 0.00032496452331543 ) [50] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776066846.1265 [end] => 1776066846.1266 [time] => 0.00019502639770508 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776066846.1267 [end] => 1776066846.1288 [time] => 0.002100944519043 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776066846.1288 [end] => 1776066846.1409 [time] => 0.012062072753906 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776066846.1433 [end] => 1776066846.1437 [time] => 0.00045204162597656 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776066846.1445 [end] => 1776066846.1448 [time] => 0.00025701522827148 ) )