Referto Partita: Sporting Team vs Pellegrini Venaria
Sporting Team
Pellegrini Venaria
RISULTATO FINALE
91
78
1° Tempo
33
22
2° Tempo
32
27
3° Tempo
26
29
INVASIONI A MURO
1
1
Data e Luogo
Evento
Playout 2025
Data e Luogo
06-06-2025 20:45 - Cavour
Arbitri
Primo Arbitro
Botosso Daniele
Secondo Arbitro
Aquila Giovanni
Refertista
ASD Polaris
Sorteggio
Sorteggio Vinto Da
Pellegrini Venaria
Scelta Sorteggio
Palla
Annotazioni
Refertista: Capitolo Sabrina
Progresso
Punteggi Individuali
Sporting Team
-
Franco GiambancoTot.6
3
x20
x3
1
x AUTOHIT -
Giacomo GarzaroTot.2
1
x20
x3
0
x AUTOHIT -
Gaetano Di NataleTot.8
4
x20
x3
0
x AUTOHIT -
Federico GarroneTot.61
14
x211
x3
0
x AUTOHIT -
Alex SerratoreTot.2
1
x20
x3
0
x AUTOHIT -
Riccardo Pajno FerraraTot.12
6
x20
x3
0
x AUTOHIT -
Francesco BrunoTot.0
0
x20
x3
0
x AUTOHIT
Pellegrini Venaria
-
Davide Casalegno
0
x20
x3
0
x AUTOHITTot.0
Domenico Pirozzolo
5
x20
x3
0
x AUTOHITTot.10
Luca Dragna
7
x21
x3
0
x AUTOHITTot.17
Gabriele Barone
9
x21
x3
0
x AUTOHITTot.21
Luca Mocciaro
10
x21
x3
0
x AUTOHITTot.23
Alberto Casalegno
3
x20
x3
0
x AUTOHITTot.6
Total Queries: 55
Total Time: 2.0251784324646
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781160743.8216
[end] => 1781160743.8219
[time] => 0.00031876564025879
)
[1] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160743.8251
[end] => 1781160743.8284
[time] => 0.0033111572265625
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160743.8284
[end] => 1781160743.8399
[time] => 0.011445045471191
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160743.8401
[end] => 1781160743.8779
[time] => 0.037814140319824
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160743.8782
[end] => 1781160743.9028
[time] => 0.024620056152344
)
[5] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160743.9029
[end] => 1781160743.9088
[time] => 0.0058150291442871
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160743.9088
[end] => 1781160743.9158
[time] => 0.0069649219512939
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160743.9158
[end] => 1781160743.986
[time] => 0.070138931274414
)
[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 (35,14) ORDER BY lastname,firstname ASC
[start] => 1781160743.9864
[end] => 1781160743.9963
[time] => 0.0098869800567627
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781160743.9998
[end] => 1781160744.0004
[time] => 0.00067281723022461
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781160744.0009
[end] => 1781160744.0012
[time] => 0.00028204917907715
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1781160744.0013
[end] => 1781160744.0039
[time] => 0.0026719570159912
)
[12] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160744.0044
[end] => 1781160744.0057
[time] => 0.0012872219085693
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160744.0058
[end] => 1781160744.0201
[time] => 0.014322996139526
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160744.0201
[end] => 1781160744.0903
[time] => 0.070146083831787
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3933'
[start] => 1781160744.0906
[end] => 1781160744.1568
[time] => 0.066215991973877
)
[16] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160744.1569
[end] => 1781160744.1578
[time] => 0.00082206726074219
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160744.1578
[end] => 1781160744.1742
[time] => 0.016401052474976
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160744.1743
[end] => 1781160744.2536
[time] => 0.07933497428894
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3933' and (point.point = 'P' or point.point = 'E')
[start] => 1781160744.2581
[end] => 1781160744.6836
[time] => 0.42543792724609
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1781160744.6838
[end] => 1781160744.688
[time] => 0.004223108291626
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1781160744.6881
[end] => 1781160744.6891
[time] => 0.00099492073059082
)
[22] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160744.6893
[end] => 1781160744.6903
[time] => 0.0010008811950684
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160744.6903
[end] => 1781160744.7037
[time] => 0.013366937637329
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160744.7038
[end] => 1781160744.7796
[time] => 0.075839996337891
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3933'
[start] => 1781160744.7799
[end] => 1781160744.827
[time] => 0.047079086303711
)
[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 = '3933' group by player_id
[start] => 1781160744.8271
[end] => 1781160745.0807
[time] => 0.25359487533569
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3933'
[start] => 1781160745.0808
[end] => 1781160745.0877
[time] => 0.0069060325622559
)
[28] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160745.0878
[end] => 1781160745.0881
[time] => 0.00027012825012207
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160745.0881
[end] => 1781160745.0956
[time] => 0.0075218677520752
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160745.0957
[end] => 1781160745.1676
[time] => 0.071815013885498
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1781160745.1679
[end] => 1781160745.1757
[time] => 0.0078361034393311
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1781160745.1759
[end] => 1781160745.1765
[time] => 0.00064802169799805
)
[33] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160745.1767
[end] => 1781160745.177
[time] => 0.00023317337036133
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160745.177
[end] => 1781160745.1886
[time] => 0.01155686378479
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160745.1886
[end] => 1781160745.2676
[time] => 0.078974008560181
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3933'
[start] => 1781160745.2679
[end] => 1781160745.2697
[time] => 0.0018270015716553
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1781160745.2699
[end] => 1781160745.2703
[time] => 0.00040602684020996
)
[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 = '3933' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1781160745.2703
[end] => 1781160745.2718
[time] => 0.001568078994751
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1781160745.2719
[end] => 1781160745.2722
[time] => 0.00026512145996094
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1781160745.2722
[end] => 1781160745.2725
[time] => 0.00026488304138184
)
[41] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160745.2727
[end] => 1781160745.2769
[time] => 0.0042369365692139
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160745.277
[end] => 1781160745.2857
[time] => 0.0087740421295166
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160745.2858
[end] => 1781160745.3512
[time] => 0.065417051315308
)
[44] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160745.3516
[end] => 1781160745.3557
[time] => 0.0041420459747314
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160745.3557
[end] => 1781160745.3682
[time] => 0.012466907501221
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160745.3683
[end] => 1781160745.4353
[time] => 0.067054033279419
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3933'
[start] => 1781160745.4356
[end] => 1781160745.4677
[time] => 0.03209400177002
)
[48] => Array
(
[query] => select * from point where match_id = '3933' order by point_id ASC
[start] => 1781160745.4678
[end] => 1781160745.8439
[time] => 0.37609815597534
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1781160745.8446
[end] => 1781160745.8468
[time] => 0.0021960735321045
)
[50] => Array
(
[query] => select * from matches where match_id = '3933'
[start] => 1781160745.8469
[end] => 1781160745.8471
[time] => 0.00025796890258789
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3933'
[start] => 1781160745.8472
[end] => 1781160745.8516
[time] => 0.0044748783111572
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3933'
[start] => 1781160745.8517
[end] => 1781160745.8647
[time] => 0.012948989868164
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781160745.8672
[end] => 1781160745.8677
[time] => 0.00052595138549805
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781160745.8686
[end] => 1781160745.869
[time] => 0.00038909912109375
)
)