Referto Partita: Iron Lion Tyson vs Together Hit
Iron Lion Tyson
Together Hit
RISULTATO FINALE
67
70
1° Tempo
17
18
2° Tempo
16
28
3° Tempo
34
24
INVASIONI A MURO
4
3
Data e Luogo
Campionato
Campionato Eccellenza 2024/2025 B2
Giornata: 1
Giornata: 1
Data e Luogo
20-10-2024 14:00 - Frassati
Arbitri
Primo Arbitro
Specchiulli Pier Paolo
Secondo Arbitro
Specchiulli Pier Paolo
Refertista
Ianniello Valerio
Sorteggio
Sorteggio Vinto Da
Together Hit
Scelta Sorteggio
Palla
Annotazioni
*Numero 3 dei Together Hit ammonito per divisa irregolare
Refertista ASD Sinombre: Ianniello Valerio
Progresso
Punteggi Individuali
Iron Lion Tyson
-
Angelo Lorenzo EliantonioTot.7
2
x21
x3
0
x AUTOHIT -
Marco RizzoTot.
4
2
x20
x3
0
x AUTOHIT -
John Gonzalo Robles ZavaletaTot.
0
0
x20
x3
0
x AUTOHIT -
Tommaso FalettiTot.
14
4
x22
x3
0
x AUTOHIT -
Alessandro BrunoTot.
2
1
x20
x3
0
x AUTOHIT -
Matteo AmideoTot.
5
1
x21
x3
0
x AUTOHIT -
Edoardo BrunoTot.
26
13
x20
x3
0
x AUTOHIT -
Mattia AllemanoTot.9
3
x21
x3
0
x AUTOHIT
Together Hit
-
Stefano Mazzilli
7
x24
x3
0
x AUTOHITTot.26
Gabriele Argirò
2
x20
x3
0
x AUTOHITTot.4
Mauro Maria Pittavino
0
x20
x3
0
x AUTOHITTot.0
Comportamento scorretto o antisportivo (Minuto: 9 - 4T)Francesco Cissello
8
x23
x3
0
x AUTOHITTot.25
Gianluca Sabatino
6
x21
x3
0
x AUTOHITTot.15
Sanzioni Disciplinari
Iron Lion Tyson
Together Hit
-
8. Mauro Maria PittavinoComportamento scorretto o antisportivo (Minuto: 9 - 4T)
Total Queries: 55
Total Time: 0.59487414360046
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776062282.5567
[end] => 1776062282.5579
[time] => 0.0012409687042236
)
[1] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062282.5622
[end] => 1776062282.5629
[time] => 0.00077009201049805
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062282.563
[end] => 1776062282.5691
[time] => 0.0061469078063965
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062282.5692
[end] => 1776062282.6042
[time] => 0.034959077835083
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062282.6045
[end] => 1776062282.6087
[time] => 0.0041460990905762
)
[5] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062282.6088
[end] => 1776062282.613
[time] => 0.004188060760498
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062282.613
[end] => 1776062282.6191
[time] => 0.0061030387878418
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062282.6192
[end] => 1776062282.6459
[time] => 0.026712894439697
)
[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 (25,29) ORDER BY lastname,firstname ASC
[start] => 1776062282.6463
[end] => 1776062282.6499
[time] => 0.0035419464111328
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062282.652
[end] => 1776062282.6528
[time] => 0.00077986717224121
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062282.6532
[end] => 1776062282.6535
[time] => 0.0002598762512207
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1776062282.6536
[end] => 1776062282.6565
[time] => 0.0028789043426514
)
[12] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062282.657
[end] => 1776062282.6588
[time] => 0.0017859935760498
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062282.6588
[end] => 1776062282.6629
[time] => 0.0040929317474365
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062282.6629
[end] => 1776062282.688
[time] => 0.025100946426392
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3694'
[start] => 1776062282.6883
[end] => 1776062282.7033
[time] => 0.014998912811279
)
[16] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062282.7035
[end] => 1776062282.7037
[time] => 0.00024509429931641
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062282.7037
[end] => 1776062282.7071
[time] => 0.0033798217773438
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062282.7072
[end] => 1776062282.7325
[time] => 0.025361061096191
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3694' and (point.point = 'P' or point.point = 'E')
[start] => 1776062282.7367
[end] => 1776062282.8723
[time] => 0.13559818267822
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1776062282.8725
[end] => 1776062282.8748
[time] => 0.0023040771484375
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1776062282.8748
[end] => 1776062282.875
[time] => 0.00018405914306641
)
[22] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062282.8751
[end] => 1776062282.8753
[time] => 0.00020599365234375
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062282.8753
[end] => 1776062282.8787
[time] => 0.0034091472625732
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062282.8788
[end] => 1776062282.9041
[time] => 0.025293827056885
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3694'
[start] => 1776062282.9044
[end] => 1776062282.9193
[time] => 0.01488208770752
)
[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 = '3694' group by player_id
[start] => 1776062282.9193
[end] => 1776062283.0034
[time] => 0.084089994430542
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3694'
[start] => 1776062283.0036
[end] => 1776062283.006
[time] => 0.002479076385498
)
[28] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062283.0061
[end] => 1776062283.0063
[time] => 0.00021815299987793
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062283.0064
[end] => 1776062283.0102
[time] => 0.0038020610809326
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062283.0102
[end] => 1776062283.0334
[time] => 0.02320408821106
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1776062283.0338
[end] => 1776062283.0341
[time] => 0.00028800964355469
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1776062283.0342
[end] => 1776062283.0348
[time] => 0.00060892105102539
)
[33] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062283.035
[end] => 1776062283.0352
[time] => 0.00022196769714355
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062283.0352
[end] => 1776062283.0374
[time] => 0.00211501121521
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062283.0374
[end] => 1776062283.0497
[time] => 0.01230001449585
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3694'
[start] => 1776062283.05
[end] => 1776062283.0509
[time] => 0.00088214874267578
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1776062283.051
[end] => 1776062283.0512
[time] => 0.00018310546875
)
[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 = '3694' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1776062283.0512
[end] => 1776062283.0514
[time] => 0.00021600723266602
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1776062283.0515
[end] => 1776062283.0518
[time] => 0.00027108192443848
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1776062283.0519
[end] => 1776062283.0522
[time] => 0.00026106834411621
)
[41] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062283.0524
[end] => 1776062283.0526
[time] => 0.00020909309387207
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062283.0526
[end] => 1776062283.0549
[time] => 0.0023429393768311
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062283.055
[end] => 1776062283.0675
[time] => 0.012533187866211
)
[44] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062283.0679
[end] => 1776062283.0682
[time] => 0.0002741813659668
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062283.0682
[end] => 1776062283.0702
[time] => 0.0020558834075928
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062283.0703
[end] => 1776062283.0825
[time] => 0.012244939804077
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3694'
[start] => 1776062283.0828
[end] => 1776062283.0898
[time] => 0.0069320201873779
)
[48] => Array
(
[query] => select * from point where match_id = '3694' order by point_id ASC
[start] => 1776062283.0898
[end] => 1776062283.1529
[time] => 0.063095092773438
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1776062283.1537
[end] => 1776062283.154
[time] => 0.00034999847412109
)
[50] => Array
(
[query] => select * from matches where match_id = '3694'
[start] => 1776062283.1541
[end] => 1776062283.1543
[time] => 0.00020217895507812
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3694'
[start] => 1776062283.1543
[end] => 1776062283.1564
[time] => 0.0021259784698486
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3694'
[start] => 1776062283.1565
[end] => 1776062283.1686
[time] => 0.012089967727661
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062283.1711
[end] => 1776062283.1716
[time] => 0.00046110153198242
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062283.1724
[end] => 1776062283.1726
[time] => 0.00024700164794922
)
)