Referto Partita: Milano Kush vs Delirium Consulum HC
Milano Kush
Delirium Consulum HC
RISULTATO FINALE
31
53
1° Tempo
17
23
2° Tempo
6
13
3° Tempo
8
17
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Torneo C1 Girone A 2023
Giornata: 1
Giornata: 1
Data e Luogo
02-04-2023 14:30 - Maritano
Arbitri
Primo Arbitro
Da Re Francesca
Secondo Arbitro
Da Re Francesca
Refertista
ASD Almara
Sorteggio
Sorteggio Vinto Da
Delirium Consulum HC
Scelta Sorteggio
Palla
Annotazioni
Federalista Almara: Tommaso Tomasina
Progresso
Punteggi Individuali
Milano Kush
-
Edoardo CoriglianoTot.10
5
x20
x3
1
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T) -
Matteo GalantiTot.0
0
x20
x3
0
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T) -
Lorenzo TomasinaTot.7
2
x21
x3
0
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T) -
Giacomo RovedaTot.4
2
x20
x3
0
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T) -
Edoardo SpinnlerTot.10
5
x20
x3
1
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T)
Delirium Consulum HC
-
Paolo Lamberti
3
x20
x3
0
x AUTOHITTot.6
Renato Dalle Mura
3
x20
x3
0
x AUTOHITTot.6
Andrea Matys
4
x22
x3
0
x AUTOHITTot.14
Dino Pagano
1
x20
x3
0
x AUTOHITTot.2
Bogdan Andrei Stancu
9
x21
x3
0
x AUTOHITTot.21
Pietro Chevallard
1
x20
x3
0
x AUTOHITTot.2
Sanzioni Disciplinari
Milano Kush
-
69. Edoardo CoriglianoDivisa di gioco non regolamentare (Minuto: - 1T)
-
23. Matteo GalantiDivisa di gioco non regolamentare (Minuto: - 1T)
-
8. Lorenzo TomasinaDivisa di gioco non regolamentare (Minuto: - 1T)
-
7. Giacomo RovedaDivisa di gioco non regolamentare (Minuto: - 1T)
-
24. Edoardo SpinnlerDivisa di gioco non regolamentare (Minuto: - 1T)
Delirium Consulum HC
Total Queries: 55
Total Time: 1.4786403179169
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781160866.2265
[end] => 1781160866.2268
[time] => 0.00029206275939941
)
[1] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160866.2335
[end] => 1781160866.2391
[time] => 0.0056028366088867
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160866.2391
[end] => 1781160866.2538
[time] => 0.014669895172119
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160866.2539
[end] => 1781160866.3016
[time] => 0.047690868377686
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160866.302
[end] => 1781160866.3159
[time] => 0.013967990875244
)
[5] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160866.3161
[end] => 1781160866.3218
[time] => 0.0056581497192383
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160866.3218
[end] => 1781160866.3351
[time] => 0.013357877731323
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160866.3352
[end] => 1781160866.3891
[time] => 0.053887844085693
)
[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 (44,49) ORDER BY lastname,firstname ASC
[start] => 1781160866.3895
[end] => 1781160866.3972
[time] => 0.0076780319213867
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781160866.4004
[end] => 1781160866.4068
[time] => 0.0064160823822021
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781160866.4073
[end] => 1781160866.4098
[time] => 0.0024940967559814
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781160866.4099
[end] => 1781160866.4136
[time] => 0.0037171840667725
)
[12] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160866.4141
[end] => 1781160866.4158
[time] => 0.0016610622406006
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160866.4158
[end] => 1781160866.4259
[time] => 0.010126113891602
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160866.426
[end] => 1781160866.4928
[time] => 0.066805839538574
)
[15] => Array
(
[query] => select * from match_roster where match_id = '2859'
[start] => 1781160866.493
[end] => 1781160866.5314
[time] => 0.038365125656128
)
[16] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160866.5315
[end] => 1781160866.54
[time] => 0.0084190368652344
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160866.54
[end] => 1781160866.5535
[time] => 0.013447999954224
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160866.5536
[end] => 1781160866.6274
[time] => 0.073819160461426
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2859' and (point.point = 'P' or point.point = 'E')
[start] => 1781160866.6339
[end] => 1781160867.0127
[time] => 0.37880897521973
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781160867.0129
[end] => 1781160867.0135
[time] => 0.00060915946960449
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781160867.0135
[end] => 1781160867.0161
[time] => 0.0025358200073242
)
[22] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160867.0161
[end] => 1781160867.0163
[time] => 0.00020289421081543
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160867.0164
[end] => 1781160867.0217
[time] => 0.005357027053833
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160867.0218
[end] => 1781160867.062
[time] => 0.040225982666016
)
[25] => Array
(
[query] => select * from match_roster where match_id = '2859'
[start] => 1781160867.0622
[end] => 1781160867.0916
[time] => 0.029338121414185
)
[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 = '2859' group by player_id
[start] => 1781160867.0916
[end] => 1781160867.2423
[time] => 0.15072798728943
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '2859'
[start] => 1781160867.2425
[end] => 1781160867.2429
[time] => 0.0003819465637207
)
[28] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160867.243
[end] => 1781160867.2449
[time] => 0.0019519329071045
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160867.2449
[end] => 1781160867.2493
[time] => 0.0043880939483643
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160867.2494
[end] => 1781160867.291
[time] => 0.041635036468506
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781160867.2913
[end] => 1781160867.294
[time] => 0.0026619434356689
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781160867.2941
[end] => 1781160867.297
[time] => 0.0028591156005859
)
[33] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160867.2972
[end] => 1781160867.2974
[time] => 0.00026106834411621
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160867.2975
[end] => 1781160867.3039
[time] => 0.006397008895874
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160867.3039
[end] => 1781160867.3459
[time] => 0.042011976242065
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '2859'
[start] => 1781160867.3462
[end] => 1781160867.3492
[time] => 0.0029971599578857
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781160867.3493
[end] => 1781160867.3495
[time] => 0.00018501281738281
)
[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 = '2859' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781160867.3495
[end] => 1781160867.3497
[time] => 0.00024700164794922
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781160867.3498
[end] => 1781160867.35
[time] => 0.00018215179443359
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781160867.35
[end] => 1781160867.3502
[time] => 0.00016999244689941
)
[41] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160867.3504
[end] => 1781160867.3529
[time] => 0.0024909973144531
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160867.3529
[end] => 1781160867.3573
[time] => 0.004396915435791
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160867.3574
[end] => 1781160867.3971
[time] => 0.039769172668457
)
[44] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160867.3974
[end] => 1781160867.4008
[time] => 0.0033431053161621
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160867.4008
[end] => 1781160867.4082
[time] => 0.0073928833007812
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160867.4082
[end] => 1781160867.4466
[time] => 0.038393974304199
)
[47] => Array
(
[query] => select * from match_roster where match_id = '2859'
[start] => 1781160867.4469
[end] => 1781160867.4761
[time] => 0.029201030731201
)
[48] => Array
(
[query] => select * from point where match_id = '2859' order by point_id ASC
[start] => 1781160867.4761
[end] => 1781160867.6921
[time] => 0.2159411907196
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781160867.6926
[end] => 1781160867.6947
[time] => 0.0021178722381592
)
[50] => Array
(
[query] => select * from matches where match_id = '2859'
[start] => 1781160867.6948
[end] => 1781160867.695
[time] => 0.00021791458129883
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2859'
[start] => 1781160867.6951
[end] => 1781160867.6995
[time] => 0.0044238567352295
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2859'
[start] => 1781160867.6995
[end] => 1781160867.7242
[time] => 0.024700880050659
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781160867.7268
[end] => 1781160867.7291
[time] => 0.0022878646850586
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781160867.73
[end] => 1781160867.7317
[time] => 0.0017499923706055
)
)