Referto Partita: Black Knights vs Igadan
Black Knights
Igadan
RISULTATO FINALE
84
57
1° Tempo
26
16
2° Tempo
29
16
3° Tempo
29
25
INVASIONI A MURO
3
0
Data e Luogo
Campionato
Campionato Eccellenza 2025/2026 A2
Giornata: 2
Giornata: 2
Data e Luogo
09-11-2025 15:35 - HitBall Arena
Arbitri
Primo Arbitro
Mondo Gianluca
Secondo Arbitro
Soroceanu Nelo
Sorteggio
Sorteggio Vinto Da
Black Knights
Scelta Sorteggio
Campo
Annotazioni
Refertista: Filippo Venturini
Progresso
Punteggi Individuali
Black Knights
-
Alessandro VarettoTot.24
6
x24
x3
0
x AUTOHIT -
Fabio BragagnoloTot.14
7
x20
x3
0
x AUTOHIT -
Massimiliano CasigliTot.6
3
x20
x3
0
x AUTOHIT -
Gianluca VarettoTot.9
3
x21
x3
0
x AUTOHIT -
Lorenzo De Nicola CivitareseTot.10
5
x20
x3
0
x AUTOHIT -
Marco AntinoroTot.13
5
x21
x3
0
x AUTOHIT -
Matteo VanniTot.8
1
x22
x3
0
x AUTOHIT
Igadan
-
Gianluca Zanetti
4
x21
x3
0
x AUTOHITTot.11
Alessandro Maniscalco
3
x20
x3
0
x AUTOHITTot.6
Gabriele Spina
3
x20
x3
0
x AUTOHITTot.6
Andrea Giannitti
4
x20
x3
0
x AUTOHITTot.8
Alberto Maggia
2
x22
x3
0
x AUTOHITTot.10
Andrea Vecchiattini
5
x20
x3
0
x AUTOHITTot.10
Enrico Truffa
3
x20
x3
0
x AUTOHITTot.6
Total Queries: 55
Total Time: 1.6297624111176
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770972593.97
[end] => 1770972593.9729
[time] => 0.0028080940246582
)
[1] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972593.9782
[end] => 1770972593.9807
[time] => 0.0025410652160645
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972593.9808
[end] => 1770972593.9835
[time] => 0.0026969909667969
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972593.9836
[end] => 1770972594.0706
[time] => 0.087090969085693
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972594.071
[end] => 1770972594.0878
[time] => 0.016860961914062
)
[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] => 1770972594.0881
[end] => 1770972594.1082
[time] => 0.020136117935181
)
[6] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770972594.113
[end] => 1770972594.122
[time] => 0.0090188980102539
)
[7] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770972594.1225
[end] => 1770972594.1281
[time] => 0.0055818557739258
)
[8] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1770972594.1282
[end] => 1770972594.1341
[time] => 0.0059001445770264
)
[9] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972594.1346
[end] => 1770972594.1378
[time] => 0.0031797885894775
)
[10] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972594.1378
[end] => 1770972594.1436
[time] => 0.0057671070098877
)
[11] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972594.1436
[end] => 1770972594.2199
[time] => 0.07632303237915
)
[12] => Array
(
[query] => select * from match_roster where match_id = '4141'
[start] => 1770972594.2202
[end] => 1770972594.2565
[time] => 0.036286115646362
)
[13] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972594.2567
[end] => 1770972594.259
[time] => 0.0023419857025146
)
[14] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972594.259
[end] => 1770972594.2693
[time] => 0.010311126708984
)
[15] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972594.2694
[end] => 1770972594.3356
[time] => 0.066202878952026
)
[16] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '4141' and (point.point = 'P' or point.point = 'E')
[start] => 1770972594.3388
[end] => 1770972594.6766
[time] => 0.33780384063721
)
[17] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1770972594.6768
[end] => 1770972594.6819
[time] => 0.0051369667053223
)
[18] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1770972594.682
[end] => 1770972594.6834
[time] => 0.0014369487762451
)
[19] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972594.6835
[end] => 1770972594.6859
[time] => 0.0024070739746094
)
[20] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972594.6859
[end] => 1770972594.6897
[time] => 0.0038330554962158
)
[21] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972594.6898
[end] => 1770972594.754
[time] => 0.064189910888672
)
[22] => Array
(
[query] => select * from match_roster where match_id = '4141'
[start] => 1770972594.7543
[end] => 1770972594.7888
[time] => 0.034510135650635
)
[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 = '4141' group by player_id
[start] => 1770972594.7888
[end] => 1770972595.0049
[time] => 0.21605205535889
)
[24] => Array
(
[query] => select * from penalty_to_team where match_id = '4141'
[start] => 1770972595.0051
[end] => 1770972595.0091
[time] => 0.0039770603179932
)
[25] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972595.0092
[end] => 1770972595.0094
[time] => 0.00023508071899414
)
[26] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972595.0094
[end] => 1770972595.0115
[time] => 0.002047061920166
)
[27] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972595.0115
[end] => 1770972595.0734
[time] => 0.06187915802002
)
[28] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1770972595.0738
[end] => 1770972595.0808
[time] => 0.007004976272583
)
[29] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1770972595.0809
[end] => 1770972595.0843
[time] => 0.0034389495849609
)
[30] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972595.0845
[end] => 1770972595.0898
[time] => 0.0053138732910156
)
[31] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972595.0898
[end] => 1770972595.0999
[time] => 0.010020017623901
)
[32] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972595.0999
[end] => 1770972595.1696
[time] => 0.069642066955566
)
[33] => Array
(
[query] => select * from match_staff_roster where match_id = '4141'
[start] => 1770972595.1699
[end] => 1770972595.1706
[time] => 0.00078797340393066
)
[34] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1770972595.1707
[end] => 1770972595.1797
[time] => 0.0089898109436035
)
[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 = '4141' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1770972595.1798
[end] => 1770972595.18
[time] => 0.00027179718017578
)
[36] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1770972595.1801
[end] => 1770972595.1819
[time] => 0.0017340183258057
)
[37] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1770972595.1819
[end] => 1770972595.1838
[time] => 0.0019140243530273
)
[38] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972595.184
[end] => 1770972595.1842
[time] => 0.00020503997802734
)
[39] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972595.1842
[end] => 1770972595.1864
[time] => 0.0021209716796875
)
[40] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972595.1864
[end] => 1770972595.2525
[time] => 0.066125869750977
)
[41] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972595.253
[end] => 1770972595.2549
[time] => 0.0019421577453613
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972595.2549
[end] => 1770972595.2678
[time] => 0.012842178344727
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972595.2678
[end] => 1770972595.3257
[time] => 0.057884931564331
)
[44] => Array
(
[query] => select * from match_roster where match_id = '4141'
[start] => 1770972595.326
[end] => 1770972595.3532
[time] => 0.027168035507202
)
[45] => Array
(
[query] => select * from point where match_id = '4141' order by point_id ASC
[start] => 1770972595.3532
[end] => 1770972595.5548
[time] => 0.20159101486206
)
[46] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972595.5553
[end] => 1770972595.5567
[time] => 0.0014231204986572
)
[47] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972595.5568
[end] => 1770972595.5618
[time] => 0.0050451755523682
)
[48] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972595.5619
[end] => 1770972595.5834
[time] => 0.021577119827271
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1770972595.5839
[end] => 1770972595.5897
[time] => 0.0058870315551758
)
[50] => Array
(
[query] => select * from matches where match_id = '4141'
[start] => 1770972595.5898
[end] => 1770972595.5901
[time] => 0.00022792816162109
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '4141'
[start] => 1770972595.5901
[end] => 1770972595.5936
[time] => 0.0035350322723389
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '4141'
[start] => 1770972595.5937
[end] => 1770972595.6179
[time] => 0.024156808853149
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770972595.6239
[end] => 1770972595.6244
[time] => 0.00042986869812012
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770972595.6252
[end] => 1770972595.6271
[time] => 0.0019271373748779
)
)