Referto Partita: Skoppiati vs Pellegrini Venaria
Skoppiati
Pellegrini Venaria
RISULTATO FINALE
72
64
1° Tempo
17
20
2° Tempo
26
16
3° Tempo
29
28
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 B1
Giornata: 13
Giornata: 13
Data e Luogo
02-04-2022 14:30 - Palazzeschi
Arbitri
Primo Arbitro
Naggi Giulio
Secondo Arbitro
Da Re Francesca
Refertista
Da Re Francesca
Sorteggio
Sorteggio Vinto Da
Skoppiati
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Skoppiati
-
Lennin Jarek GarciaTot.12
3
x22
x3
0
x AUTOHIT -
Matteo BercanTot.32
13
x22
x3
0
x AUTOHIT -
Giovanni MarsicoTot.19
5
x23
x3
0
x AUTOHIT -
Riccardo GouthierTot.2
1
x20
x3
1
x AUTOHIT -
Lorenzo FontanaTot.7
2
x21
x3
1
x AUTOHIT
Pellegrini Venaria
-
Gabriele Cappero
0
x20
x3
0
x AUTOHITTot.0
Domenico Pirozzolo
3
x20
x3
0
x AUTOHITTot.6
Luca Dragna
4
x20
x3
0
x AUTOHITTot.8
Gabriele Barone
8
x20
x3
0
x AUTOHITTot.16
Barbara Tombolato
4
x20
x3
0
x AUTOHITTot.8
Christian Alescio
0
x20
x3
0
x AUTOHITTot.0
Federico Zoccarato
0
x20
x3
0
x AUTOHITTot.0
Alberto Casalegno
3
x21
x3
0
x AUTOHITTot.9
Federico Sisci
6
x21
x3
0
x AUTOHITTot.15
Total Queries: 55 Total Time: 1.459329366684 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1770979856.3272 [end] => 1770979856.3299 [time] => 0.0027170181274414 ) [1] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979856.3341 [end] => 1770979856.3346 [time] => 0.00051593780517578 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979856.3346 [end] => 1770979856.3366 [time] => 0.0020170211791992 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979856.3367 [end] => 1770979856.3658 [time] => 0.029008865356445 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979856.3661 [end] => 1770979856.3734 [time] => 0.0073440074920654 ) [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] => 1770979856.3737 [end] => 1770979856.3891 [time] => 0.015487909317017 ) [6] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770979856.3949 [end] => 1770979856.3971 [time] => 0.0022180080413818 ) [7] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770979856.3975 [end] => 1770979856.3978 [time] => 0.00032401084899902 ) [8] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1770979856.3979 [end] => 1770979856.3986 [time] => 0.00068998336791992 ) [9] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979856.3991 [end] => 1770979856.3993 [time] => 0.00022006034851074 ) [10] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979856.3993 [end] => 1770979856.4026 [time] => 0.0033111572265625 ) [11] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979856.4027 [end] => 1770979856.4268 [time] => 0.024049043655396 ) [12] => Array ( [query] => select * from match_roster where match_id = '1895' [start] => 1770979856.427 [end] => 1770979856.4413 [time] => 0.014286041259766 ) [13] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979856.4414 [end] => 1770979856.4417 [time] => 0.00027799606323242 ) [14] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979856.4417 [end] => 1770979856.4458 [time] => 0.0041191577911377 ) [15] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979856.4459 [end] => 1770979856.4726 [time] => 0.026672124862671 ) [16] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '1895' and (point.point = 'P' or point.point = 'E') [start] => 1770979856.4746 [end] => 1770979856.6531 [time] => 0.17846179008484 ) [17] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1770979856.6532 [end] => 1770979856.6539 [time] => 0.00069499015808105 ) [18] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1770979856.654 [end] => 1770979856.6541 [time] => 0.00018000602722168 ) [19] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979856.6542 [end] => 1770979856.6568 [time] => 0.0025200843811035 ) [20] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979856.6568 [end] => 1770979856.6628 [time] => 0.0060219764709473 ) [21] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979856.6629 [end] => 1770979856.7114 [time] => 0.048507928848267 ) [22] => Array ( [query] => select * from match_roster where match_id = '1895' [start] => 1770979856.7116 [end] => 1770979856.7347 [time] => 0.023120164871216 ) [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 = '1895' group by player_id [start] => 1770979856.7348 [end] => 1770979856.9143 [time] => 0.17956900596619 ) [24] => Array ( [query] => select * from penalty_to_team where match_id = '1895' [start] => 1770979856.9145 [end] => 1770979856.9204 [time] => 0.0059471130371094 ) [25] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979856.9205 [end] => 1770979856.9219 [time] => 0.0013711452484131 ) [26] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979856.9219 [end] => 1770979856.932 [time] => 0.010071039199829 ) [27] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979856.932 [end] => 1770979857.0058 [time] => 0.073718070983887 ) [28] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1770979857.006 [end] => 1770979857.009 [time] => 0.0029339790344238 ) [29] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1770979857.0091 [end] => 1770979857.0104 [time] => 0.0013589859008789 ) [30] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979857.0106 [end] => 1770979857.0109 [time] => 0.00027704238891602 ) [31] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979857.0109 [end] => 1770979857.0187 [time] => 0.0078229904174805 ) [32] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979857.0188 [end] => 1770979857.0978 [time] => 0.079010009765625 ) [33] => Array ( [query] => select * from match_staff_roster where match_id = '1895' [start] => 1770979857.098 [end] => 1770979857.0989 [time] => 0.00082707405090332 ) [34] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1770979857.099 [end] => 1770979857.1077 [time] => 0.0087590217590332 ) [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 = '1895' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1770979857.1078 [end] => 1770979857.1099 [time] => 0.0021669864654541 ) [36] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1770979857.11 [end] => 1770979857.1127 [time] => 0.0027070045471191 ) [37] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1770979857.1128 [end] => 1770979857.113 [time] => 0.00023388862609863 ) [38] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979857.1132 [end] => 1770979857.1149 [time] => 0.0016911029815674 ) [39] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979857.1149 [end] => 1770979857.1277 [time] => 0.012814998626709 ) [40] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979857.1278 [end] => 1770979857.1952 [time] => 0.067420959472656 ) [41] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979857.1955 [end] => 1770979857.1989 [time] => 0.003324031829834 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979857.1989 [end] => 1770979857.2047 [time] => 0.005850076675415 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979857.2048 [end] => 1770979857.2808 [time] => 0.076014041900635 ) [44] => Array ( [query] => select * from match_roster where match_id = '1895' [start] => 1770979857.2811 [end] => 1770979857.3201 [time] => 0.039026021957397 ) [45] => Array ( [query] => select * from point where match_id = '1895' order by point_id ASC [start] => 1770979857.3201 [end] => 1770979857.6392 [time] => 0.31905913352966 ) [46] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979857.6398 [end] => 1770979857.6439 [time] => 0.0041568279266357 ) [47] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979857.644 [end] => 1770979857.6541 [time] => 0.010104179382324 ) [48] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979857.6541 [end] => 1770979857.7271 [time] => 0.072975158691406 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1770979857.7275 [end] => 1770979857.7298 [time] => 0.0022342205047607 ) [50] => Array ( [query] => select * from matches where match_id = '1895' [start] => 1770979857.7298 [end] => 1770979857.7301 [time] => 0.00024104118347168 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '1895' [start] => 1770979857.7301 [end] => 1770979857.7392 [time] => 0.0091030597686768 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '1895' [start] => 1770979857.7393 [end] => 1770979857.7992 [time] => 0.059882879257202 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770979857.8017 [end] => 1770979857.8051 [time] => 0.0034010410308838 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770979857.8059 [end] => 1770979857.8084 [time] => 0.0024919509887695 ) )