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.34423160552979 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1776062373.7651 [end] => 1776062373.7655 [time] => 0.00037503242492676 ) [1] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062373.7677 [end] => 1776062373.768 [time] => 0.00031280517578125 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.768 [end] => 1776062373.7702 [time] => 0.0021162033081055 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062373.7702 [end] => 1776062373.7824 [time] => 0.012123823165894 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.7827 [end] => 1776062373.7849 [time] => 0.0021839141845703 ) [5] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062373.785 [end] => 1776062373.7852 [time] => 0.00022482872009277 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.7852 [end] => 1776062373.7872 [time] => 0.002018928527832 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062373.7873 [end] => 1776062373.7994 [time] => 0.012064933776855 ) [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] => 1776062373.7998 [end] => 1776062373.8007 [time] => 0.00096392631530762 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776062373.8021 [end] => 1776062373.8025 [time] => 0.00040388107299805 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776062373.8029 [end] => 1776062373.8031 [time] => 0.00023102760314941 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1776062373.8032 [end] => 1776062373.8038 [time] => 0.00060296058654785 ) [12] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062373.8043 [end] => 1776062373.8045 [time] => 0.00023794174194336 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.8045 [end] => 1776062373.8066 [time] => 0.0020558834075928 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062373.8066 [end] => 1776062373.8187 [time] => 0.012104034423828 ) [15] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1776062373.819 [end] => 1776062373.826 [time] => 0.0070290565490723 ) [16] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062373.8261 [end] => 1776062373.8264 [time] => 0.00029802322387695 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.8264 [end] => 1776062373.8286 [time] => 0.0021259784698486 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062373.8286 [end] => 1776062373.8407 [time] => 0.012113809585571 ) [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] => 1776062373.8428 [end] => 1776062373.9089 [time] => 0.066060066223145 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1776062373.909 [end] => 1776062373.9094 [time] => 0.00032687187194824 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1776062373.9094 [end] => 1776062373.9096 [time] => 0.00018596649169922 ) [22] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062373.9097 [end] => 1776062373.9099 [time] => 0.00019001960754395 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.9099 [end] => 1776062373.912 [time] => 0.0021188259124756 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062373.9121 [end] => 1776062373.9242 [time] => 0.012094020843506 ) [25] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1776062373.9244 [end] => 1776062373.9314 [time] => 0.007011890411377 ) [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] => 1776062373.9315 [end] => 1776062373.9736 [time] => 0.042099952697754 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2015' [start] => 1776062373.9738 [end] => 1776062373.9741 [time] => 0.00035691261291504 ) [28] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062373.9742 [end] => 1776062373.9744 [time] => 0.00018596649169922 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.9744 [end] => 1776062373.9765 [time] => 0.0020809173583984 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062373.9765 [end] => 1776062373.9886 [time] => 0.012102842330933 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1776062373.9889 [end] => 1776062373.9892 [time] => 0.00024318695068359 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1776062373.9893 [end] => 1776062373.9898 [time] => 0.00054311752319336 ) [33] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062373.99 [end] => 1776062373.9902 [time] => 0.00020408630371094 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062373.9902 [end] => 1776062373.9923 [time] => 0.0020580291748047 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062373.9923 [end] => 1776062374.0044 [time] => 0.012086868286133 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2015' [start] => 1776062374.0046 [end] => 1776062374.0054 [time] => 0.00082015991210938 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1776062374.0055 [end] => 1776062374.0057 [time] => 0.00018811225891113 ) [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] => 1776062374.0057 [end] => 1776062374.0059 [time] => 0.00020003318786621 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1776062374.006 [end] => 1776062374.0062 [time] => 0.00015521049499512 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1776062374.0062 [end] => 1776062374.0063 [time] => 0.00014185905456543 ) [41] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062374.0065 [end] => 1776062374.0067 [time] => 0.00019598007202148 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062374.0067 [end] => 1776062374.0088 [time] => 0.0020759105682373 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062374.0088 [end] => 1776062374.0209 [time] => 0.012080907821655 ) [44] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062374.0212 [end] => 1776062374.0215 [time] => 0.00028491020202637 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062374.0215 [end] => 1776062374.0236 [time] => 0.002047061920166 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062374.0236 [end] => 1776062374.0357 [time] => 0.012084007263184 ) [47] => Array ( [query] => select * from match_roster where match_id = '2015' [start] => 1776062374.0359 [end] => 1776062374.043 [time] => 0.0070338249206543 ) [48] => Array ( [query] => select * from point where match_id = '2015' order by point_id ASC [start] => 1776062374.043 [end] => 1776062374.1048 [time] => 0.06180214881897 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1776062374.1054 [end] => 1776062374.1058 [time] => 0.00036406517028809 ) [50] => Array ( [query] => select * from matches where match_id = '2015' [start] => 1776062374.1059 [end] => 1776062374.1062 [time] => 0.00027203559875488 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2015' [start] => 1776062374.1062 [end] => 1776062374.1083 [time] => 0.00211501121521 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2015' [start] => 1776062374.1083 [end] => 1776062374.1204 [time] => 0.012038946151733 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776062374.1228 [end] => 1776062374.1233 [time] => 0.00051403045654297 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776062374.1242 [end] => 1776062374.1244 [time] => 0.00028085708618164 ) )