Referto Partita: Torino Warriors vs Skoppiati
Torino Warriors
Skoppiati
RISULTATO FINALE
78
94
1° Tempo
18
24
2° Tempo
35
28
3° Tempo
25
42
INVASIONI A MURO
2
4
Data e Luogo
Campionato
Campionato Eccellenza 2024/2025 A2
Giornata: 11
Giornata: 11
Data e Luogo
04-02-2025 20:30 - Frassati
Arbitri
Primo Arbitro
Specchiulli Pier Paolo
Secondo Arbitro
Ianniello Valerio
Refertista
ASD Sinombre
Sorteggio
Sorteggio Vinto Da
Torino Warriors
Scelta Sorteggio
Palla
Annotazioni
Refertista: Lisa Portarulo
Progresso
Punteggi Individuali
Torino Warriors
-
Stefano BorelliTot.10
5
x20
x3
0
x AUTOHIT -
Federico SolinasTot.22
8
x22
x3
0
x AUTOHIT -
Giacomo GuarratoTot.8
4
x20
x3
0
x AUTOHIT -
Marco GambaTot.8
4
x20
x3
0
x AUTOHITComportamento scorretto o antisportivo (Minuto: 9 - 1T) -
Carlotta AmodeoTot.0
0
x20
x3
0
x AUTOHIT -
Jacopo SanfilippoTot.24
6
x24
x3
0
x AUTOHIT -
Antonio D'ElicioTot.6
3
x20
x3
0
x AUTOHIT
Skoppiati
-
Andrea Cacioli
4
x24
x3
0
x AUTOHITTot.20
Ion Soroceanu
6
x20
x3
0
x AUTOHITTot.12
Riccardo Francabandiera
7
x24
x3
0
x AUTOHITTot.26
Federico Suppo
9
x20
x3
0
x AUTOHITTot.18
Giovanni Marsico
1
x24
x3
0
x AUTOHITTot.14
Lennin Jarek Garcia
2
x20
x3
0
x AUTOHITTot.4
Sanzioni Disciplinari
Torino Warriors
-
15. Marco GambaComportamento scorretto o antisportivo (Minuto: 9 - 1T)
Skoppiati
Total Queries: 55
Total Time: 1.7730071544647
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1766072155.398
[end] => 1766072155.4077
[time] => 0.0097038745880127
)
[1] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072155.4201
[end] => 1766072155.4204
[time] => 0.00023698806762695
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072155.4204
[end] => 1766072155.4239
[time] => 0.0034728050231934
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072155.424
[end] => 1766072155.4822
[time] => 0.058233976364136
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072155.4826
[end] => 1766072155.4905
[time] => 0.0078699588775635
)
[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] => 1766072155.4907
[end] => 1766072155.5187
[time] => 0.027991056442261
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1766072155.5264
[end] => 1766072155.5295
[time] => 0.003176212310791
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1766072155.53
[end] => 1766072155.5305
[time] => 0.00042605400085449
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1766072155.5306
[end] => 1766072155.5332
[time] => 0.0026230812072754
)
[9] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072155.5346
[end] => 1766072155.5428
[time] => 0.0081419944763184
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072155.5429
[end] => 1766072155.5487
[time] => 0.005789041519165
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072155.5488
[end] => 1766072155.6168
[time] => 0.068011999130249
)
[12] => Array
(
[query] => select * from match_roster where match_id = '3565'
[start] => 1766072155.617
[end] => 1766072155.6464
[time] => 0.029329061508179
)
[13] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072155.6465
[end] => 1766072155.6509
[time] => 0.0043849945068359
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072155.6509
[end] => 1766072155.6565
[time] => 0.0055758953094482
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072155.6566
[end] => 1766072155.7105
[time] => 0.053907871246338
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3565' and (point.point = 'P' or point.point = 'E')
[start] => 1766072155.7125
[end] => 1766072156.0333
[time] => 0.32077217102051
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1766072156.0334
[end] => 1766072156.0347
[time] => 0.0013139247894287
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1766072156.0348
[end] => 1766072156.0359
[time] => 0.0010790824890137
)
[19] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072156.036
[end] => 1766072156.0362
[time] => 0.00020384788513184
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072156.0362
[end] => 1766072156.0459
[time] => 0.0096321105957031
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072156.046
[end] => 1766072156.1046
[time] => 0.058581829071045
)
[22] => Array
(
[query] => select * from match_roster where match_id = '3565'
[start] => 1766072156.1048
[end] => 1766072156.1326
[time] => 0.02780294418335
)
[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 = '3565' group by player_id
[start] => 1766072156.1327
[end] => 1766072156.3772
[time] => 0.24449300765991
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '3565'
[start] => 1766072156.3774
[end] => 1766072156.3778
[time] => 0.00039505958557129
)
[25] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072156.3779
[end] => 1766072156.3781
[time] => 0.0001990795135498
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072156.3781
[end] => 1766072156.394
[time] => 0.015931129455566
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072156.3941
[end] => 1766072156.4521
[time] => 0.057965993881226
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1766072156.4524
[end] => 1766072156.4568
[time] => 0.0043511390686035
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1766072156.4569
[end] => 1766072156.4634
[time] => 0.006464958190918
)
[30] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072156.4636
[end] => 1766072156.4639
[time] => 0.00028800964355469
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072156.4639
[end] => 1766072156.4771
[time] => 0.01322078704834
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072156.4772
[end] => 1766072156.5448
[time] => 0.067568063735962
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '3565'
[start] => 1766072156.545
[end] => 1766072156.5458
[time] => 0.0007472038269043
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1766072156.5459
[end] => 1766072156.5517
[time] => 0.0058238506317139
)
[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 = '3565' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1766072156.5518
[end] => 1766072156.5549
[time] => 0.0031671524047852
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1766072156.555
[end] => 1766072156.5552
[time] => 0.00019192695617676
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1766072156.5553
[end] => 1766072156.5555
[time] => 0.00016403198242188
)
[38] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072156.5557
[end] => 1766072156.5559
[time] => 0.00023198127746582
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072156.5559
[end] => 1766072156.5658
[time] => 0.0099458694458008
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072156.5659
[end] => 1766072156.6256
[time] => 0.059623956680298
)
[41] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072156.626
[end] => 1766072156.6278
[time] => 0.0017919540405273
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072156.6278
[end] => 1766072156.6313
[time] => 0.0034899711608887
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072156.6313
[end] => 1766072156.6926
[time] => 0.061267137527466
)
[44] => Array
(
[query] => select * from match_roster where match_id = '3565'
[start] => 1766072156.6929
[end] => 1766072156.7305
[time] => 0.037570953369141
)
[45] => Array
(
[query] => select * from point where match_id = '3565' order by point_id ASC
[start] => 1766072156.7305
[end] => 1766072157.0466
[time] => 0.31607103347778
)
[46] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072157.0472
[end] => 1766072157.0578
[time] => 0.010547876358032
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072157.0578
[end] => 1766072157.0636
[time] => 0.005742073059082
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072157.0637
[end] => 1766072157.1207
[time] => 0.057016134262085
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1766072157.1211
[end] => 1766072157.1305
[time] => 0.0093190670013428
)
[50] => Array
(
[query] => select * from matches where match_id = '3565'
[start] => 1766072157.1306
[end] => 1766072157.1308
[time] => 0.00021910667419434
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3565'
[start] => 1766072157.1308
[end] => 1766072157.1327
[time] => 0.0018479824066162
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3565'
[start] => 1766072157.1327
[end] => 1766072157.1936
[time] => 0.060901880264282
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1766072157.1978
[end] => 1766072157.2051
[time] => 0.0072948932647705
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1766072157.2058
[end] => 1766072157.2067
[time] => 0.00089311599731445
)
)