Referto Partita: Delirium Consulum vs Valhalla
Delirium Consulum
Valhalla
RISULTATO FINALE
75
62
1° Tempo
20
24
2° Tempo
20
26
3° Tempo
35
12
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2025/2026 B2
Giornata: 4
Giornata: 4
Data e Luogo
09-12-2025 21:50 - Cavour
Arbitri
Primo Arbitro
Aquila Giovanni
Secondo Arbitro
Valetti Mattia
Refertista
ASD Polaris
Sorteggio
Sorteggio Vinto Da
Valhalla
Scelta Sorteggio
Palla
Annotazioni
Refertista: Capitolo Sabrina
Progresso
Punteggi Individuali
Delirium Consulum
-
Paolo LambertiTot.35
7
x27
x3
0
x AUTOHIT -
Renato Dalle MuraTot.17
7
x21
x3
1
x AUTOHIT -
Dino PaganoTot.14
7
x20
x3
0
x AUTOHIT -
Alice La VersaTot.0
0
x20
x3
0
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T) -
Pietro ChevallardTot.4
2
x20
x3
0
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T) -
Gianluca MinutoTot.4
2
x20
x3
0
x AUTOHITDivisa di gioco non regolamentare (Minuto: - 1T)
Valhalla
-
Lorenzo Marchitelli
2
x21
x3
1
x AUTOHITTot.7
Luca Rivetti
2
x20
x3
0
x AUTOHITTot.4
Daniele Nemo Busato
2
x22
x3
0
x AUTOHITTot.10
Alessio Noto
0
x20
x3
0
x AUTOHITTot.0
Marco Bassetti
2
x20
x3
0
x AUTOHITTot.4
Yuki Galano
2
x21
x3
0
x AUTOHITTot.7
Divisa di gioco non regolamentare (Minuto: 1 - 1T)Marco Antonucci
1
x21
x3
0
x AUTOHITTot.5
Daniele Ponte
6
x24
x3
0
x AUTOHITTot.24
Divisa di gioco non regolamentare (Minuto: - 1T)Sanzioni Disciplinari
Delirium Consulum
-
21. Alice La VersaDivisa di gioco non regolamentare (Minuto: - 1T)
-
42. Pietro ChevallardDivisa di gioco non regolamentare (Minuto: - 1T)
-
44. Gianluca MinutoDivisa di gioco non regolamentare (Minuto: - 1T)
Valhalla
-
17. Yuki GalanoDivisa di gioco non regolamentare (Minuto: 1 - 1T)
-
28. Daniele PonteDivisa di gioco non regolamentare (Minuto: - 1T)
Total Queries: 55
Total Time: 1.5714783668518
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770972684.8164
[end] => 1770972684.821
[time] => 0.004612922668457
)
[1] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972684.8245
[end] => 1770972684.8249
[time] => 0.00034999847412109
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972684.825
[end] => 1770972684.8379
[time] => 0.012911081314087
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972684.838
[end] => 1770972684.9003
[time] => 0.062329053878784
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972684.9007
[end] => 1770972684.9098
[time] => 0.0090358257293701
)
[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] => 1770972684.91
[end] => 1770972684.9363
[time] => 0.026245832443237
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770972684.9421
[end] => 1770972684.9471
[time] => 0.0049278736114502
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770972684.9475
[end] => 1770972684.9478
[time] => 0.00025796890258789
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770972684.9479
[end] => 1770972684.9486
[time] => 0.00071811676025391
)
[9] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972684.9491
[end] => 1770972684.9507
[time] => 0.0016260147094727
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972684.9508
[end] => 1770972684.9648
[time] => 0.014041185379028
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972684.9649
[end] => 1770972685.0311
[time] => 0.066214084625244
)
[12] => Array
(
[query] => select * from match_roster where match_id = '4332'
[start] => 1770972685.0314
[end] => 1770972685.072
[time] => 0.040587186813354
)
[13] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972685.0721
[end] => 1770972685.0847
[time] => 0.012639045715332
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972685.0848
[end] => 1770972685.097
[time] => 0.012204885482788
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972685.0971
[end] => 1770972685.1627
[time] => 0.065603017807007
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4332' and (point.point = 'P' or point.point = 'E')
[start] => 1770972685.1658
[end] => 1770972685.5476
[time] => 0.38176894187927
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1770972685.5478
[end] => 1770972685.5548
[time] => 0.0070037841796875
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1770972685.5548
[end] => 1770972685.555
[time] => 0.00016999244689941
)
[19] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972685.5551
[end] => 1770972685.5553
[time] => 0.0001828670501709
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972685.5553
[end] => 1770972685.5577
[time] => 0.0024149417877197
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972685.5578
[end] => 1770972685.6263
[time] => 0.068557977676392
)
[22] => Array
(
[query] => select * from match_roster where match_id = '4332'
[start] => 1770972685.6266
[end] => 1770972685.666
[time] => 0.039366006851196
)
[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 = '4332' group by player_id
[start] => 1770972685.666
[end] => 1770972685.8781
[time] => 0.21206092834473
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '4332'
[start] => 1770972685.8782
[end] => 1770972685.8807
[time] => 0.0024929046630859
)
[25] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972685.8808
[end] => 1770972685.881
[time] => 0.00021696090698242
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972685.881
[end] => 1770972685.8911
[time] => 0.010035037994385
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972685.8911
[end] => 1770972685.9494
[time] => 0.058295011520386
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1770972685.9498
[end] => 1770972685.95
[time] => 0.00021576881408691
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1770972685.9501
[end] => 1770972685.953
[time] => 0.0029251575469971
)
[30] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972685.9532
[end] => 1770972685.9534
[time] => 0.00021195411682129
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972685.9534
[end] => 1770972685.9615
[time] => 0.0080440044403076
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972685.9615
[end] => 1770972686.0283
[time] => 0.066730976104736
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '4332'
[start] => 1770972686.0286
[end] => 1770972686.0297
[time] => 0.001176118850708
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1770972686.0299
[end] => 1770972686.0318
[time] => 0.0019838809967041
)
[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 = '4332' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1770972686.0319
[end] => 1770972686.0321
[time] => 0.00020909309387207
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1770972686.0322
[end] => 1770972686.0323
[time] => 0.00016903877258301
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1770972686.0324
[end] => 1770972686.0337
[time] => 0.0013270378112793
)
[38] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972686.0339
[end] => 1770972686.0384
[time] => 0.0045318603515625
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972686.0385
[end] => 1770972686.0405
[time] => 0.0020768642425537
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972686.0406
[end] => 1770972686.1187
[time] => 0.078068971633911
)
[41] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972686.119
[end] => 1770972686.1198
[time] => 0.00072383880615234
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972686.1198
[end] => 1770972686.1308
[time] => 0.011006116867065
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972686.1309
[end] => 1770972686.1761
[time] => 0.045210123062134
)
[44] => Array
(
[query] => select * from match_roster where match_id = '4332'
[start] => 1770972686.1764
[end] => 1770972686.2092
[time] => 0.032784938812256
)
[45] => Array
(
[query] => select * from point where match_id = '4332' order by point_id ASC
[start] => 1770972686.2092
[end] => 1770972686.3576
[time] => 0.14834690093994
)
[46] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972686.3581
[end] => 1770972686.3597
[time] => 0.0016591548919678
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972686.3598
[end] => 1770972686.3639
[time] => 0.0041191577911377
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972686.3639
[end] => 1770972686.3905
[time] => 0.026571035385132
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1770972686.391
[end] => 1770972686.3912
[time] => 0.00022292137145996
)
[50] => Array
(
[query] => select * from matches where match_id = '4332'
[start] => 1770972686.3913
[end] => 1770972686.3915
[time] => 0.00019502639770508
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4332'
[start] => 1770972686.3915
[end] => 1770972686.3939
[time] => 0.002371072769165
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4332'
[start] => 1770972686.3939
[end] => 1770972686.4069
[time] => 0.012943983078003
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770972686.4095
[end] => 1770972686.41
[time] => 0.00050806999206543
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770972686.4108
[end] => 1770972686.411
[time] => 0.00027585029602051
)
)