Referto Partita: Padawan vs AS Intomatici
Padawan
AS Intomatici
RISULTATO FINALE
43
30
1° Tempo
6
12
2° Tempo
21
10
3° Tempo
16
8
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 B2
Giornata: 3
Giornata: 3
Data e Luogo
20-11-2021 17:00 - Palazzeschi
Arbitri
Primo Arbitro
Da Re Francesca
Secondo Arbitro
Spina Gabriele
Refertista
Spina Gabriele
Sorteggio
Sorteggio Vinto Da
Padawan
Scelta Sorteggio
Campo
Progresso
Punteggi Individuali
Padawan
-
Marco GramignaTot.4
2
x20
x3
0
x AUTOHIT -
Roberta BinelloTot.6
3
x20
x3
0
x AUTOHIT -
Giovanni AquilaTot.7
2
x21
x3
0
x AUTOHIT -
Elisa GenoveseTot.2
1
x20
x3
0
x AUTOHIT -
Patrick MarzanoTot.12
3
x22
x3
0
x AUTOHIT -
Simone CasaleTot.9
3
x21
x3
0
x AUTOHIT -
Marco MisilmeriTot.2
1
x20
x3
0
x AUTOHIT
AS Intomatici
-
Giulio Cocirio
1
x20
x3
1
x AUTOHITTot.2
Jacopo Marchitelli
5
x20
x3
0
x AUTOHITTot.10
Francesco Croci
2
x20
x3
0
x AUTOHITTot.4
Simone Basano
1
x20
x3
0
x AUTOHITTot.2
Samuele Carnelli
0
x20
x3
0
x AUTOHITTot.0
Justin Ossai
1
x20
x3
0
x AUTOHITTot.2
Gioco antisportivo (Minuto: 12 - 2T)Marco Antonucci
1
x20
x3
0
x AUTOHITTot.2
Davide Rivetti
2
x20
x3
0
x AUTOHITTot.4
Gabriele Di Stefano
2
x20
x3
0
x AUTOHITTot.4
Sanzioni Disciplinari
Padawan
AS Intomatici
-
5. Justin OssaiGioco antisportivo (Minuto: 12 - 2T)
Total Queries: 55 Total Time: 1.4926569461823 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1776062609.8408 [end] => 1776062609.8415 [time] => 0.0006260871887207 ) [1] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062609.8455 [end] => 1776062609.8457 [time] => 0.00026082992553711 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062609.8458 [end] => 1776062609.8579 [time] => 0.012120008468628 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062609.8581 [end] => 1776062609.9073 [time] => 0.049133062362671 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062609.9076 [end] => 1776062609.9177 [time] => 0.0101158618927 ) [5] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062609.9179 [end] => 1776062609.9186 [time] => 0.00077605247497559 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062609.9187 [end] => 1776062609.9319 [time] => 0.013203859329224 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062609.9319 [end] => 1776062609.9885 [time] => 0.056596994400024 ) [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 (26,27) ORDER BY lastname,firstname ASC [start] => 1776062609.989 [end] => 1776062609.9989 [time] => 0.009955883026123 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776062610.0025 [end] => 1776062610.0031 [time] => 0.00057291984558105 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776062610.0035 [end] => 1776062610.0038 [time] => 0.00030207633972168 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1776062610.0039 [end] => 1776062610.0046 [time] => 0.00075507164001465 ) [12] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062610.0051 [end] => 1776062610.0058 [time] => 0.00063300132751465 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062610.0058 [end] => 1776062610.0094 [time] => 0.0036020278930664 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062610.0094 [end] => 1776062610.0653 [time] => 0.055858135223389 ) [15] => Array ( [query] => select * from match_roster where match_id = '2023' [start] => 1776062610.0655 [end] => 1776062610.0945 [time] => 0.02898907661438 ) [16] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062610.0947 [end] => 1776062610.0949 [time] => 0.00024700164794922 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062610.0949 [end] => 1776062610.1032 [time] => 0.0083119869232178 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062610.1033 [end] => 1776062610.1723 [time] => 0.068969011306763 ) [19] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '2023' and (point.point = 'P' or point.point = 'E') [start] => 1776062610.1744 [end] => 1776062610.4619 [time] => 0.2875018119812 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1776062610.462 [end] => 1776062610.4632 [time] => 0.0011420249938965 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1776062610.4632 [end] => 1776062610.4642 [time] => 0.0009300708770752 ) [22] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062610.4643 [end] => 1776062610.4645 [time] => 0.00020194053649902 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062610.4645 [end] => 1776062610.4723 [time] => 0.0078699588775635 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062610.4724 [end] => 1776062610.5273 [time] => 0.054848909378052 ) [25] => Array ( [query] => select * from match_roster where match_id = '2023' [start] => 1776062610.5275 [end] => 1776062610.5507 [time] => 0.023217916488647 ) [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 = '2023' group by player_id [start] => 1776062610.5508 [end] => 1776062610.7287 [time] => 0.17794990539551 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '2023' [start] => 1776062610.7289 [end] => 1776062610.7341 [time] => 0.0051698684692383 ) [28] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062610.7341 [end] => 1776062610.7344 [time] => 0.00021505355834961 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062610.7344 [end] => 1776062610.7431 [time] => 0.0087618827819824 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062610.7432 [end] => 1776062610.8081 [time] => 0.064912080764771 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1776062610.8085 [end] => 1776062610.813 [time] => 0.0045201778411865 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1776062610.8131 [end] => 1776062610.8141 [time] => 0.0010159015655518 ) [33] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062610.8143 [end] => 1776062610.8149 [time] => 0.00059008598327637 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062610.8149 [end] => 1776062610.8252 [time] => 0.010263919830322 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062610.8252 [end] => 1776062610.8872 [time] => 0.06194806098938 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '2023' [start] => 1776062610.8874 [end] => 1776062610.8888 [time] => 0.0013670921325684 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1776062610.8889 [end] => 1776062610.8909 [time] => 0.0019428730010986 ) [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 = '2023' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1776062610.8909 [end] => 1776062610.8911 [time] => 0.00022482872009277 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1776062610.8912 [end] => 1776062610.8914 [time] => 0.00018310546875 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1776062610.8914 [end] => 1776062610.8939 [time] => 0.0024290084838867 ) [41] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062610.894 [end] => 1776062610.8957 [time] => 0.0016930103302002 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062610.8958 [end] => 1776062610.9128 [time] => 0.017052173614502 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062610.9129 [end] => 1776062610.9595 [time] => 0.046586990356445 ) [44] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062610.9598 [end] => 1776062610.9602 [time] => 0.00035810470581055 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062610.9602 [end] => 1776062610.9644 [time] => 0.0041840076446533 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062610.9645 [end] => 1776062610.9918 [time] => 0.027376890182495 ) [47] => Array ( [query] => select * from match_roster where match_id = '2023' [start] => 1776062610.9921 [end] => 1776062611.0051 [time] => 0.012933969497681 ) [48] => Array ( [query] => select * from point where match_id = '2023' order by point_id ASC [start] => 1776062611.0051 [end] => 1776062611.2888 [time] => 0.28370308876038 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1776062611.2894 [end] => 1776062611.2967 [time] => 0.0073361396789551 ) [50] => Array ( [query] => select * from matches where match_id = '2023' [start] => 1776062611.2968 [end] => 1776062611.2989 [time] => 0.0020878314971924 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '2023' [start] => 1776062611.2989 [end] => 1776062611.3122 [time] => 0.013245105743408 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '2023' [start] => 1776062611.3123 [end] => 1776062611.3493 [time] => 0.037019014358521 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776062611.3536 [end] => 1776062611.3542 [time] => 0.00053620338439941 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776062611.355 [end] => 1776062611.3553 [time] => 0.00030899047851562 ) )