Referto Partita: Legio X vs Padawan
Legio X
Padawan
RISULTATO FINALE
39
60
1° Tempo
12
14
2° Tempo
17
27
3° Tempo
10
19
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2022/2023 B2
Giornata: 7
Giornata: 7
Data e Luogo
17-01-2023 21:50 - Frassati
Arbitri
Primo Arbitro
Centin Davide
Secondo Arbitro
Bracesco Martina
Refertista
Bracesco Martina
Sorteggio
Sorteggio Vinto Da
Padawan
Scelta Sorteggio
Palla
Progresso
Punteggi Individuali
Legio X
-
Alessio NotoTot.2
1
x20
x3
0
x AUTOHITComportamento scorretto o antisportivo (Minuto: 13 - 2T) -
Samuele CarnelliTot.2
1
x20
x3
0
x AUTOHIT -
Leonardo SpecchiulliTot.4
2
x20
x3
0
x AUTOHIT -
Edoardo Di NoiaTot.5
1
x21
x3
0
x AUTOHIT -
Pier Paolo SpecchiulliTot.5
1
x21
x3
0
x AUTOHIT -
Simone BasanoTot.13
5
x21
x3
0
x AUTOHIT -
Justin OssaiTot.6
3
x20
x3
0
x AUTOHIT -
Lorenzo MarchitelliTot.0
0
x20
x3
0
x AUTOHIT -
Valerio IannielloTot.0
0
x20
x3
0
x AUTOHIT
Padawan
-
Marco Gramigna
0
x20
x3
0
x AUTOHITTot.0
Roberta Binello
4
x22
x3
0
x AUTOHITTot.14
Giovanni Aquila
6
x21
x3
0
x AUTOHITTot.15
Laura Mongi
0
x20
x3
0
x AUTOHITTot.0
Andrea Lovera
6
x21
x3
0
x AUTOHITTot.15
Elisa Genovese
1
x20
x3
0
x AUTOHITTot.2
Roberto Perrini
1
x20
x3
0
x AUTOHITTot.2
Simone Casale
1
x20
x3
0
x AUTOHITTot.2
Francesco Luigi Scarfò
2
x22
x3
2
x AUTOHITTot.10
Sanzioni Disciplinari
Legio X
-
21. Alessio NotoComportamento scorretto o antisportivo (Minuto: 13 - 2T)
Padawan
Total Queries: 55 Total Time: 0.34843969345093 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1770972863.922 [end] => 1770972863.9223 [time] => 0.00034499168395996 ) [1] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972863.9245 [end] => 1770972863.9248 [time] => 0.00026082992553711 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972863.9248 [end] => 1770972863.9269 [time] => 0.0021309852600098 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972863.927 [end] => 1770972863.939 [time] => 0.011981010437012 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972863.9393 [end] => 1770972863.9414 [time] => 0.0021340847015381 ) [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] => 1770972863.9416 [end] => 1770972863.948 [time] => 0.0064048767089844 ) [6] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770972863.9515 [end] => 1770972863.9519 [time] => 0.00041294097900391 ) [7] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770972863.9523 [end] => 1770972863.9525 [time] => 0.00020694732666016 ) [8] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1770972863.9526 [end] => 1770972863.9533 [time] => 0.00065994262695312 ) [9] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972863.9537 [end] => 1770972863.9539 [time] => 0.00019598007202148 ) [10] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972863.954 [end] => 1770972863.956 [time] => 0.0020549297332764 ) [11] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972863.9561 [end] => 1770972863.9681 [time] => 0.012005090713501 ) [12] => Array ( [query] => select * from match_roster where match_id = '2643' [start] => 1770972863.9683 [end] => 1770972863.9753 [time] => 0.0069489479064941 ) [13] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972863.9754 [end] => 1770972863.9757 [time] => 0.00031399726867676 ) [14] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972863.9757 [end] => 1770972863.9778 [time] => 0.0020580291748047 ) [15] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972863.9778 [end] => 1770972863.9898 [time] => 0.011956930160522 ) [16] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2643' and (point.point = 'P' or point.point = 'E') [start] => 1770972863.9919 [end] => 1770972864.0578 [time] => 0.065916061401367 ) [17] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1770972864.0579 [end] => 1770972864.0583 [time] => 0.00033903121948242 ) [18] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1770972864.0583 [end] => 1770972864.0585 [time] => 0.00019383430480957 ) [19] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972864.0586 [end] => 1770972864.0588 [time] => 0.00023198127746582 ) [20] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972864.0588 [end] => 1770972864.0609 [time] => 0.0020949840545654 ) [21] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972864.061 [end] => 1770972864.0732 [time] => 0.012139081954956 ) [22] => Array ( [query] => select * from match_roster where match_id = '2643' [start] => 1770972864.0734 [end] => 1770972864.0803 [time] => 0.0069069862365723 ) [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 = '2643' group by player_id [start] => 1770972864.0803 [end] => 1770972864.1223 [time] => 0.041910171508789 ) [24] => Array ( [query] => select * from penalty_to_team where match_id = '2643' [start] => 1770972864.1224 [end] => 1770972864.1228 [time] => 0.00037908554077148 ) [25] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972864.1229 [end] => 1770972864.1231 [time] => 0.0001988410949707 ) [26] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972864.1231 [end] => 1770972864.1251 [time] => 0.0020561218261719 ) [27] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972864.1252 [end] => 1770972864.1374 [time] => 0.012192010879517 ) [28] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1770972864.1377 [end] => 1770972864.138 [time] => 0.00026392936706543 ) [29] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1770972864.1381 [end] => 1770972864.1386 [time] => 0.00057101249694824 ) [30] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972864.1388 [end] => 1770972864.1391 [time] => 0.00022101402282715 ) [31] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972864.1391 [end] => 1770972864.1411 [time] => 0.0020689964294434 ) [32] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972864.1412 [end] => 1770972864.1535 [time] => 0.012274026870728 ) [33] => Array ( [query] => select * from match_staff_roster where match_id = '2643' [start] => 1770972864.1537 [end] => 1770972864.1546 [time] => 0.00081515312194824 ) [34] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1770972864.1547 [end] => 1770972864.1548 [time] => 0.00016999244689941 ) [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 = '2643' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1770972864.1548 [end] => 1770972864.1551 [time] => 0.0002140998840332 ) [36] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1770972864.1551 [end] => 1770972864.1553 [time] => 0.0001680850982666 ) [37] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1770972864.1553 [end] => 1770972864.1555 [time] => 0.00011897087097168 ) [38] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972864.1556 [end] => 1770972864.1558 [time] => 0.00018000602722168 ) [39] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972864.1558 [end] => 1770972864.1578 [time] => 0.0020408630371094 ) [40] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972864.1579 [end] => 1770972864.1699 [time] => 0.012048959732056 ) [41] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972864.1702 [end] => 1770972864.1705 [time] => 0.00027298927307129 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972864.1705 [end] => 1770972864.1726 [time] => 0.00205397605896 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972864.1727 [end] => 1770972864.1846 [time] => 0.011994123458862 ) [44] => Array ( [query] => select * from match_roster where match_id = '2643' [start] => 1770972864.1849 [end] => 1770972864.1918 [time] => 0.0068747997283936 ) [45] => Array ( [query] => select * from point where match_id = '2643' order by point_id ASC [start] => 1770972864.1918 [end] => 1770972864.2536 [time] => 0.061774969100952 ) [46] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972864.2541 [end] => 1770972864.2544 [time] => 0.00032591819763184 ) [47] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972864.2545 [end] => 1770972864.2565 [time] => 0.002068042755127 ) [48] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972864.2566 [end] => 1770972864.2685 [time] => 0.01188588142395 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1770972864.2689 [end] => 1770972864.2692 [time] => 0.00026917457580566 ) [50] => Array ( [query] => select * from matches where match_id = '2643' [start] => 1770972864.2693 [end] => 1770972864.2695 [time] => 0.00019097328186035 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2643' [start] => 1770972864.2695 [end] => 1770972864.2715 [time] => 0.0020191669464111 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2643' [start] => 1770972864.2715 [end] => 1770972864.2837 [time] => 0.012167930603027 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1770972864.2862 [end] => 1770972864.2868 [time] => 0.00053501129150391 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1770972864.2875 [end] => 1770972864.2877 [time] => 0.00022292137145996 ) )