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.39139604568481 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1781159502.5228 [end] => 1781159502.5231 [time] => 0.00027585029602051 ) [1] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.5254 [end] => 1781159502.5257 [time] => 0.00032520294189453 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.5257 [end] => 1781159502.5282 [time] => 0.0024368762969971 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.5282 [end] => 1781159502.5411 [time] => 0.012896060943604 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.5414 [end] => 1781159502.5439 [time] => 0.0025029182434082 ) [5] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.5441 [end] => 1781159502.5443 [time] => 0.0002291202545166 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.5443 [end] => 1781159502.5467 [time] => 0.002446174621582 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.5468 [end] => 1781159502.5597 [time] => 0.012929916381836 ) [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] => 1781159502.5601 [end] => 1781159502.5611 [time] => 0.0010268688201904 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781159502.5625 [end] => 1781159502.5629 [time] => 0.00042891502380371 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781159502.5633 [end] => 1781159502.5637 [time] => 0.00032591819763184 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1781159502.5637 [end] => 1781159502.5644 [time] => 0.00061893463134766 ) [12] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.5648 [end] => 1781159502.565 [time] => 0.00019502639770508 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.565 [end] => 1781159502.5674 [time] => 0.0023880004882812 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.5675 [end] => 1781159502.5803 [time] => 0.012829065322876 ) [15] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1781159502.5806 [end] => 1781159502.5888 [time] => 0.0082840919494629 ) [16] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.589 [end] => 1781159502.5893 [time] => 0.00031614303588867 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.5893 [end] => 1781159502.5918 [time] => 0.0024299621582031 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.5919 [end] => 1781159502.6047 [time] => 0.012831926345825 ) [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] => 1781159502.6071 [end] => 1781159502.683 [time] => 0.075942993164062 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1781159502.6832 [end] => 1781159502.6835 [time] => 0.00032591819763184 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1781159502.6835 [end] => 1781159502.6838 [time] => 0.00021910667419434 ) [22] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.6839 [end] => 1781159502.6841 [time] => 0.00022101402282715 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.6841 [end] => 1781159502.6865 [time] => 0.0024230480194092 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.6866 [end] => 1781159502.6994 [time] => 0.012806177139282 ) [25] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1781159502.6996 [end] => 1781159502.7078 [time] => 0.0081331729888916 ) [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] => 1781159502.7079 [end] => 1781159502.7563 [time] => 0.048425912857056 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2015' [start] => 1781159502.7565 [end] => 1781159502.7568 [time] => 0.00038909912109375 ) [28] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.7569 [end] => 1781159502.7571 [time] => 0.00019288063049316 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.7571 [end] => 1781159502.7595 [time] => 0.0023579597473145 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.7595 [end] => 1781159502.7724 [time] => 0.012837171554565 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1781159502.7727 [end] => 1781159502.7745 [time] => 0.0018208026885986 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1781159502.7746 [end] => 1781159502.7778 [time] => 0.0031919479370117 ) [33] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.778 [end] => 1781159502.7783 [time] => 0.00026607513427734 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.7783 [end] => 1781159502.7808 [time] => 0.0024909973144531 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.7808 [end] => 1781159502.7967 [time] => 0.01583194732666 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2015' [start] => 1781159502.7969 [end] => 1781159502.798 [time] => 0.0010390281677246 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1781159502.7981 [end] => 1781159502.7982 [time] => 0.00016999244689941 ) [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] => 1781159502.7983 [end] => 1781159502.7985 [time] => 0.00020909309387207 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1781159502.7985 [end] => 1781159502.7987 [time] => 0.00013899803161621 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1781159502.7987 [end] => 1781159502.7989 [time] => 0.00012516975402832 ) [41] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.799 [end] => 1781159502.7992 [time] => 0.00015997886657715 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.7992 [end] => 1781159502.8017 [time] => 0.0025138854980469 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.8018 [end] => 1781159502.8146 [time] => 0.012814044952393 ) [44] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.8149 [end] => 1781159502.8152 [time] => 0.0002739429473877 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.8152 [end] => 1781159502.8176 [time] => 0.0024380683898926 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.8177 [end] => 1781159502.8305 [time] => 0.012785196304321 ) [47] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1781159502.8308 [end] => 1781159502.8389 [time] => 0.0081000328063965 ) [48] => Array ( [query] => select * from point where match_id = '2015' order by point_id ASC [start] => 1781159502.8389 [end] => 1781159502.9092 [time] => 0.070303201675415 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1781159502.9098 [end] => 1781159502.9102 [time] => 0.00033116340637207 ) [50] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1781159502.9102 [end] => 1781159502.9104 [time] => 0.00020694732666016 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1781159502.9105 [end] => 1781159502.9129 [time] => 0.0024449825286865 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1781159502.913 [end] => 1781159502.9259 [time] => 0.012982845306396 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781159502.9285 [end] => 1781159502.929 [time] => 0.00048208236694336 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781159502.9298 [end] => 1781159502.9301 [time] => 0.00028419494628906 ) )