Referto Partita: Flamurtari vs Hammers
Flamurtari
Hammers
RISULTATO FINALE
74
72
1° Tempo
21
18
2° Tempo
23
30
3° Tempo
30
24
INVASIONI A MURO
0
0
Data e Luogo
Campionato
Campionato Eccellenza 2021/2022 A2
Giornata: 5
Giornata: 5
Data e Luogo
12-12-2021 15:45 - Palazzeschi
Arbitri
Primo Arbitro
Botosso Daniele
Secondo Arbitro
Principato Lucrezia
Refertista
Da Re Francesca
Sorteggio
Sorteggio Vinto Da
Flamurtari
Scelta Sorteggio
Campo
Progresso
Punteggi Individuali
Flamurtari
-
Daniele ManagòTot.2
1
x20
x3
0
x AUTOHITDivisa di gioco non regolamentare (Minuto: 1 - 1T) -
Alessandro RomanoTot.10
5
x20
x3
0
x AUTOHIT -
Matteo TurigliattoTot.20
7
x22
x3
0
x AUTOHIT -
Antonio MarincolaTot.10
5
x20
x3
0
x AUTOHIT -
Fabrizio CaddeoTot.
4
2
x20
x3
0
x AUTOHIT -
Enrico SalariTot.12
6
x20
x3
0
x AUTOHIT -
Pietro EvangelistaTot.16
2
x24
x3
0
x AUTOHIT -
Federica FunnoneTot.0
0
x20
x3
0
x AUTOHIT -
Marco ZanattaTot.0
0
x20
x3
0
x AUTOHIT
Hammers
-
Sabrina Capitolo
0
x20
x3
0
x AUTOHITTot.0
Lorenzo Novara
4
x20
x3
0
x AUTOHITTot.8
Roberto Carrer
11
x24
x3
0
x AUTOHITTot.34
Ivan Russo
4
x20
x3
0
x AUTOHITTot.8
Rebecca Aurigemma
0
x20
x3
0
x AUTOHITTot.0
Giovanni Marino
11
x20
x3
0
x AUTOHITTot.22
Sanzioni Disciplinari
Flamurtari
-
14. Daniele ManagòDivisa di gioco non regolamentare (Minuto: 1 - 1T)
Hammers
Total Queries: 55
Total Time: 0.39942240715027
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1786253010.2784
[end] => 1786253010.2789
[time] => 0.00050115585327148
)
[1] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.2813
[end] => 1786253010.2815
[time] => 0.00026988983154297
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.2816
[end] => 1786253010.284
[time] => 0.0024030208587646
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.2841
[end] => 1786253010.2968
[time] => 0.01275897026062
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.2971
[end] => 1786253010.2996
[time] => 0.0024828910827637
)
[5] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.2997
[end] => 1786253010.2999
[time] => 0.00021600723266602
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.3
[end] => 1786253010.3024
[time] => 0.0023980140686035
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.3024
[end] => 1786253010.3153
[time] => 0.012837171554565
)
[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 (36,34) ORDER BY lastname,firstname ASC
[start] => 1786253010.3156
[end] => 1786253010.3168
[time] => 0.0011370182037354
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786253010.3184
[end] => 1786253010.3188
[time] => 0.0004279613494873
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786253010.3192
[end] => 1786253010.3195
[time] => 0.00026893615722656
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1786253010.3196
[end] => 1786253010.3203
[time] => 0.00068807601928711
)
[12] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.3208
[end] => 1786253010.321
[time] => 0.00021696090698242
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.321
[end] => 1786253010.3234
[time] => 0.00242018699646
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.3235
[end] => 1786253010.3365
[time] => 0.013059139251709
)
[15] => Array
(
[query] => select * from match_roster where match_id = '2065'
[start] => 1786253010.3368
[end] => 1786253010.3449
[time] => 0.008080005645752
)
[16] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.345
[end] => 1786253010.3452
[time] => 0.00022602081298828
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.3452
[end] => 1786253010.3477
[time] => 0.0024089813232422
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.3477
[end] => 1786253010.3605
[time] => 0.012727975845337
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '2065' and (point.point = 'P' or point.point = 'E')
[start] => 1786253010.3629
[end] => 1786253010.4381
[time] => 0.075186967849731
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1786253010.4382
[end] => 1786253010.4385
[time] => 0.00028109550476074
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1786253010.4386
[end] => 1786253010.4388
[time] => 0.00022196769714355
)
[22] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.4389
[end] => 1786253010.4391
[time] => 0.00021576881408691
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.4391
[end] => 1786253010.4415
[time] => 0.0024158954620361
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.4416
[end] => 1786253010.4544
[time] => 0.012829065322876
)
[25] => Array
(
[query] => select * from match_roster where match_id = '2065'
[start] => 1786253010.4547
[end] => 1786253010.4627
[time] => 0.0080640316009521
)
[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 = '2065' group by player_id
[start] => 1786253010.4628
[end] => 1786253010.5105
[time] => 0.047776222229004
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '2065'
[start] => 1786253010.5107
[end] => 1786253010.5111
[time] => 0.00036978721618652
)
[28] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.5112
[end] => 1786253010.5114
[time] => 0.00021004676818848
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.5114
[end] => 1786253010.5138
[time] => 0.0024209022521973
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.5139
[end] => 1786253010.5267
[time] => 0.012799024581909
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1786253010.527
[end] => 1786253010.5272
[time] => 0.00023317337036133
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1786253010.5273
[end] => 1786253010.5279
[time] => 0.00060892105102539
)
[33] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.5281
[end] => 1786253010.5283
[time] => 0.00021696090698242
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.5284
[end] => 1786253010.5308
[time] => 0.0024158954620361
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.5308
[end] => 1786253010.5453
[time] => 0.014432907104492
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '2065'
[start] => 1786253010.5455
[end] => 1786253010.5466
[time] => 0.0010221004486084
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1786253010.5467
[end] => 1786253010.5469
[time] => 0.00021791458129883
)
[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 = '2065' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1786253010.5469
[end] => 1786253010.5471
[time] => 0.00023198127746582
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1786253010.5472
[end] => 1786253010.5474
[time] => 0.00019097328186035
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1786253010.5475
[end] => 1786253010.5477
[time] => 0.00017619132995605
)
[41] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.5479
[end] => 1786253010.5481
[time] => 0.00022196769714355
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.5481
[end] => 1786253010.5505
[time] => 0.002410888671875
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.5506
[end] => 1786253010.5634
[time] => 0.012791872024536
)
[44] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.5636
[end] => 1786253010.5639
[time] => 0.00025010108947754
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.5639
[end] => 1786253010.5663
[time] => 0.0024299621582031
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.5664
[end] => 1786253010.5792
[time] => 0.012763977050781
)
[47] => Array
(
[query] => select * from match_roster where match_id = '2065'
[start] => 1786253010.5794
[end] => 1786253010.5874
[time] => 0.0080468654632568
)
[48] => Array
(
[query] => select * from point where match_id = '2065' order by point_id ASC
[start] => 1786253010.5875
[end] => 1786253010.6733
[time] => 0.085806846618652
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1786253010.6741
[end] => 1786253010.6744
[time] => 0.00033998489379883
)
[50] => Array
(
[query] => select * from matches where match_id = '2065'
[start] => 1786253010.6745
[end] => 1786253010.6747
[time] => 0.00024199485778809
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '2065'
[start] => 1786253010.6747
[end] => 1786253010.6773
[time] => 0.0025310516357422
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '2065'
[start] => 1786253010.6773
[end] => 1786253010.6901
[time] => 0.012820959091187
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1786253010.6927
[end] => 1786253010.6932
[time] => 0.00043487548828125
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1786253010.694
[end] => 1786253010.6943
[time] => 0.00026488304138184
)
)