Referto Partita: Nomadi Venaria vs Meatballs
Nomadi Venaria
Meatballs
RISULTATO FINALE
51
91
1° Tempo
17
34
2° Tempo
21
34
3° Tempo
13
23
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2023/2024 B2
Giornata: 13
Giornata: 13
Data e Luogo
17-03-2024 11:05 - Verolengo
Arbitri
Primo Arbitro
Agnelli Filippo
Secondo Arbitro
Mezzatesta Ilaria
Refertista
ASD PolisportivaVenaria
Sorteggio
Sorteggio Vinto Da
Nomadi Venaria
Scelta Sorteggio
Palla
Annotazioni
Refertista Nomadi: Tombolato Barbara
Progresso
Punteggi Individuali
Nomadi Venaria
-
Jacopo GattiTot.2
1
x20
x3
0
x AUTOHIT -
Simone ContiTot.12
6
x20
x3
0
x AUTOHIT -
Gabriele CapperoTot.16
5
x22
x3
1
x AUTOHIT -
Federico ZoccaratoTot.19
8
x21
x3
0
x AUTOHIT
Meatballs
-
Federico Listello
5
x23
x3
0
x AUTOHITTot.19
Gabriele Bonaldo
2
x20
x3
0
x AUTOHITTot.4
Sara Sottolano
2
x21
x3
2
x AUTOHITTot.7
Rossella De Blasio
0
x20
x3
0
x AUTOHITTot.0
Arianna Vismara
4
x20
x3
0
x AUTOHITTot.8
Riccardo Artuffo
4
x20
x3
0
x AUTOHITTot.8
Paolo Guerra
10
x23
x3
0
x AUTOHITTot.29
Pier Paolo Specchiulli
3
x20
x3
0
x AUTOHITTot.6
Mauro Mola
3
x21
x3
0
x AUTOHITTot.9
Sanzioni di Squadra
Nomadi Venaria
-
Formazione Incompleta
Meatballs
-
Nessuna penalità di squadra.
Total Queries: 55 Total Time: 0.38122391700745 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1781159692.2281 [end] => 1781159692.2284 [time] => 0.00025820732116699 ) [1] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.2307 [end] => 1781159692.2309 [time] => 0.00022697448730469 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.2309 [end] => 1781159692.2333 [time] => 0.0023970603942871 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.2334 [end] => 1781159692.2462 [time] => 0.012840986251831 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.2465 [end] => 1781159692.249 [time] => 0.0024750232696533 ) [5] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.2491 [end] => 1781159692.2493 [time] => 0.00023388862609863 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.2493 [end] => 1781159692.2517 [time] => 0.0023579597473145 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.2517 [end] => 1781159692.2646 [time] => 0.012877941131592 ) [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 (47,24) ORDER BY lastname,firstname ASC [start] => 1781159692.2651 [end] => 1781159692.2662 [time] => 0.0011129379272461 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781159692.2678 [end] => 1781159692.2682 [time] => 0.00043606758117676 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781159692.2686 [end] => 1781159692.2689 [time] => 0.00025200843811035 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1781159692.2689 [end] => 1781159692.2695 [time] => 0.00060582160949707 ) [12] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.27 [end] => 1781159692.2702 [time] => 0.00019407272338867 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.2702 [end] => 1781159692.2726 [time] => 0.00235915184021 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.2726 [end] => 1781159692.2855 [time] => 0.012845993041992 ) [15] => Array ( [query] => select * from match_roster where match_id = '3290' [start] => 1781159692.2857 [end] => 1781159692.2938 [time] => 0.008073091506958 ) [16] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.2939 [end] => 1781159692.2942 [time] => 0.00025105476379395 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.2942 [end] => 1781159692.2966 [time] => 0.0023679733276367 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.2966 [end] => 1781159692.3094 [time] => 0.012825965881348 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '3290' and (point.point = 'P' or point.point = 'E') [start] => 1781159692.3119 [end] => 1781159692.387 [time] => 0.075037002563477 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1781159692.3871 [end] => 1781159692.3874 [time] => 0.00033211708068848 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1781159692.3875 [end] => 1781159692.3877 [time] => 0.0001828670501709 ) [22] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.3878 [end] => 1781159692.388 [time] => 0.00024104118347168 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.388 [end] => 1781159692.3904 [time] => 0.0023469924926758 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.3904 [end] => 1781159692.4032 [time] => 0.012820959091187 ) [25] => Array ( [query] => select * from match_roster where match_id = '3290' [start] => 1781159692.4035 [end] => 1781159692.4116 [time] => 0.0080771446228027 ) [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 = '3290' group by player_id [start] => 1781159692.4116 [end] => 1781159692.4594 [time] => 0.047778844833374 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '3290' [start] => 1781159692.4596 [end] => 1781159692.46 [time] => 0.00045108795166016 ) [28] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.4601 [end] => 1781159692.4603 [time] => 0.00018906593322754 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.4603 [end] => 1781159692.4626 [time] => 0.0023488998413086 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.4627 [end] => 1781159692.4756 [time] => 0.012855052947998 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1781159692.4759 [end] => 1781159692.4762 [time] => 0.00023412704467773 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1781159692.4763 [end] => 1781159692.4768 [time] => 0.00055098533630371 ) [33] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.477 [end] => 1781159692.4772 [time] => 0.00024509429931641 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.4773 [end] => 1781159692.4796 [time] => 0.0023360252380371 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.4796 [end] => 1781159692.4924 [time] => 0.012795925140381 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '3290' [start] => 1781159692.4927 [end] => 1781159692.4937 [time] => 0.00098609924316406 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1781159692.4938 [end] => 1781159692.494 [time] => 0.0001671314239502 ) [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 = '3290' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1781159692.494 [end] => 1781159692.4942 [time] => 0.00020885467529297 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1781159692.4942 [end] => 1781159692.4944 [time] => 0.00016093254089355 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1781159692.4945 [end] => 1781159692.4946 [time] => 0.00013899803161621 ) [41] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.4948 [end] => 1781159692.495 [time] => 0.00018310546875 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.495 [end] => 1781159692.4974 [time] => 0.0023870468139648 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.4974 [end] => 1781159692.5102 [time] => 0.012794971466064 ) [44] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.5105 [end] => 1781159692.5108 [time] => 0.00025010108947754 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.5108 [end] => 1781159692.5132 [time] => 0.0024030208587646 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.5133 [end] => 1781159692.5261 [time] => 0.012793064117432 ) [47] => Array ( [query] => select * from match_roster where match_id = '3290' [start] => 1781159692.5263 [end] => 1781159692.5344 [time] => 0.0080630779266357 ) [48] => Array ( [query] => select * from point where match_id = '3290' order by point_id ASC [start] => 1781159692.5344 [end] => 1781159692.6046 [time] => 0.070148944854736 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1781159692.6053 [end] => 1781159692.6056 [time] => 0.00035214424133301 ) [50] => Array ( [query] => select * from matches where match_id = '3290' [start] => 1781159692.6057 [end] => 1781159692.6059 [time] => 0.00022411346435547 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3290' [start] => 1781159692.6059 [end] => 1781159692.6084 [time] => 0.0024261474609375 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3290' [start] => 1781159692.6084 [end] => 1781159692.6214 [time] => 0.012929916381836 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1781159692.6241 [end] => 1781159692.6246 [time] => 0.00050997734069824 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1781159692.6255 [end] => 1781159692.6257 [time] => 0.00028085708618164 ) )