Referto Partita: Homeless vs Meatballs
Homeless
Meatballs
RISULTATO FINALE
67
89
1° Tempo
19
26
2° Tempo
32
40
3° Tempo
16
23
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2024/2025 B2
Giornata: 2
Giornata: 2
Data e Luogo
24-10-2024 21:50 - Cavour
Arbitri
Primo Arbitro
Riccio Roberto
Secondo Arbitro
Riccio Roberto
Refertista
ASD Polaris
Sorteggio
Sorteggio Vinto Da
Homeless
Scelta Sorteggio
Palla
Annotazioni
Refertista di società:Thomas Rovetto
Progresso
Punteggi Individuali
Homeless
-
Gaetano RendineTot.16
5
x22
x3
0
x AUTOHIT -
Pierluigi MarchisioTot.3
0
x21
x3
1
x AUTOHIT -
Marta BresselloTot.
6
3
x20
x3
1
x AUTOHIT -
Andrea MerloTot.41
10
x27
x3
0
x AUTOHIT
Meatballs
-
Lisa Portarulo
7
x20
x3
0
x AUTOHITTot.14
Federico Listello
8
x21
x3
0
x AUTOHITTot.19
Rossella De Blasio
2
x20
x3
0
x AUTOHITTot.4
Riccardo Artuffo
4
x20
x3
0
x AUTOHITTot.8
Paolo Guerra
11
x21
x3
1
x AUTOHITTot.25
Mauro Mola
7
x21
x3
0
x AUTOHITTot.17
Sanzioni di Squadra
Homeless
-
Formazione Incompleta
Meatballs
-
Nessuna penalità di squadra.
Total Queries: 55
Total Time: 0.34990382194519
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770972736.3608
[end] => 1770972736.3612
[time] => 0.00037598609924316
)
[1] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.3634
[end] => 1770972736.3637
[time] => 0.00029802322387695
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.3637
[end] => 1770972736.3658
[time] => 0.0020859241485596
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.3659
[end] => 1770972736.3779
[time] => 0.012041091918945
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.3783
[end] => 1770972736.3805
[time] => 0.0021839141845703
)
[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] => 1770972736.3807
[end] => 1770972736.387
[time] => 0.0063478946685791
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770972736.3905
[end] => 1770972736.391
[time] => 0.00048995018005371
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770972736.3913
[end] => 1770972736.3916
[time] => 0.00028777122497559
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770972736.3917
[end] => 1770972736.3923
[time] => 0.00057291984558105
)
[9] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.3928
[end] => 1770972736.393
[time] => 0.00024080276489258
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.393
[end] => 1770972736.3951
[time] => 0.002061128616333
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.3951
[end] => 1770972736.4072
[time] => 0.012094974517822
)
[12] => Array
(
[query] => select * from match_roster where match_id = '3696'
[start] => 1770972736.4075
[end] => 1770972736.4146
[time] => 0.0071239471435547
)
[13] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.4148
[end] => 1770972736.4151
[time] => 0.00028204917907715
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.4151
[end] => 1770972736.4172
[time] => 0.0020890235900879
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.4173
[end] => 1770972736.4295
[time] => 0.012218952178955
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3696' and (point.point = 'P' or point.point = 'E')
[start] => 1770972736.4316
[end] => 1770972736.4981
[time] => 0.066446781158447
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1770972736.4982
[end] => 1770972736.4986
[time] => 0.00033116340637207
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1770972736.4986
[end] => 1770972736.4988
[time] => 0.00019598007202148
)
[19] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.4989
[end] => 1770972736.4991
[time] => 0.00022101402282715
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.4991
[end] => 1770972736.5012
[time] => 0.0020968914031982
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.5013
[end] => 1770972736.5133
[time] => 0.012027978897095
)
[22] => Array
(
[query] => select * from match_roster where match_id = '3696'
[start] => 1770972736.5136
[end] => 1770972736.5205
[time] => 0.0069270133972168
)
[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 = '3696' group by player_id
[start] => 1770972736.5205
[end] => 1770972736.5626
[time] => 0.042031049728394
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '3696'
[start] => 1770972736.5627
[end] => 1770972736.5631
[time] => 0.00037097930908203
)
[25] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.5632
[end] => 1770972736.5634
[time] => 0.0001978874206543
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.5634
[end] => 1770972736.5655
[time] => 0.0020809173583984
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.5655
[end] => 1770972736.5776
[time] => 0.012047052383423
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1770972736.5779
[end] => 1770972736.5782
[time] => 0.00025796890258789
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1770972736.5783
[end] => 1770972736.5788
[time] => 0.00057697296142578
)
[30] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.579
[end] => 1770972736.5793
[time] => 0.0002598762512207
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.5793
[end] => 1770972736.5814
[time] => 0.0020520687103271
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.5814
[end] => 1770972736.5934
[time] => 0.011970996856689
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '3696'
[start] => 1770972736.5936
[end] => 1770972736.5944
[time] => 0.00078988075256348
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1770972736.5945
[end] => 1770972736.5947
[time] => 0.00018501281738281
)
[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 = '3696' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1770972736.5947
[end] => 1770972736.5949
[time] => 0.00020289421081543
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1770972736.595
[end] => 1770972736.5952
[time] => 0.00016689300537109
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1770972736.5952
[end] => 1770972736.5954
[time] => 0.00014805793762207
)
[38] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.5955
[end] => 1770972736.5957
[time] => 0.00020694732666016
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.5957
[end] => 1770972736.5978
[time] => 0.0020592212677002
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.5978
[end] => 1770972736.6101
[time] => 0.012226104736328
)
[41] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.6104
[end] => 1770972736.6107
[time] => 0.00031113624572754
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.6107
[end] => 1770972736.6128
[time] => 0.0020599365234375
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.6128
[end] => 1770972736.6249
[time] => 0.012008905410767
)
[44] => Array
(
[query] => select * from match_roster where match_id = '3696'
[start] => 1770972736.6251
[end] => 1770972736.632
[time] => 0.0068800449371338
)
[45] => Array
(
[query] => select * from point where match_id = '3696' order by point_id ASC
[start] => 1770972736.6321
[end] => 1770972736.6939
[time] => 0.061868906021118
)
[46] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.6945
[end] => 1770972736.6948
[time] => 0.00036001205444336
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.6949
[end] => 1770972736.697
[time] => 0.002094030380249
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.697
[end] => 1770972736.709
[time] => 0.011988878250122
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1770972736.7094
[end] => 1770972736.7098
[time] => 0.00032305717468262
)
[50] => Array
(
[query] => select * from matches where match_id = '3696'
[start] => 1770972736.7098
[end] => 1770972736.71
[time] => 0.0002138614654541
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3696'
[start] => 1770972736.7101
[end] => 1770972736.7121
[time] => 0.0020561218261719
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3696'
[start] => 1770972736.7122
[end] => 1770972736.7242
[time] => 0.012070894241333
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770972736.7267
[end] => 1770972736.7272
[time] => 0.00051999092102051
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770972736.728
[end] => 1770972736.7283
[time] => 0.00027608871459961
)
)