Referto Partita: Poska vs Levuoiqueikiwi
Poska
Levuoiqueikiwi
RISULTATO FINALE
20
68
1° Tempo
8
22
2° Tempo
5
22
3° Tempo
7
24
INVASIONI A MURO
1
0
Data e Luogo
Campionato
Torneo Femminile 2025
Giornata: 10
Giornata: 10
Data e Luogo
11-05-2025 15:35 - Frassati
Arbitri
Primo Arbitro
Agnelli Filippo
Secondo Arbitro
Soroceanu Nelo
Refertista
ASD Sinombre
Sorteggio
Sorteggio Vinto Da
Poska
Scelta Sorteggio
Palla
Annotazioni
Refertista sinombre: Francesco Libero Busato
Progresso
Punteggi Individuali
Poska
-
Angelica Maria BonomiTot.0
0
x20
x3
0
x AUTOHIT -
Ginevra PalaTot.2
1
x20
x3
0
x AUTOHIT -
Nina QuarantaTot.2
1
x20
x3
0
x AUTOHIT -
Camilla RealeTot.0
0
x20
x3
0
x AUTOHIT -
Emma SandrettoTot.0
0
x20
x3
0
x AUTOHIT -
Paola VerardiTot.16
5
x22
x3
0
x AUTOHIT -
Giulia D'alessandroTot.0
0
x20
x3
0
x AUTOHIT
Levuoiqueikiwi
-
Ilaria Mezzatesta
8
x21
x3
0
x AUTOHITTot.19
Arianna Vismara
10
x21
x3
0
x AUTOHITTot.23
Sabrina Zanfretta
6
x21
x3
0
x AUTOHITTot.15
Veronica Beria
4
x21
x3
0
x AUTOHITTot.11
Sanzioni di Squadra
Poska
-
Nessuna penalità di squadra.
Levuoiqueikiwi
-
Formazione Incompleta
Total Queries: 55
Total Time: 0.34413981437683
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1776062208.4691
[end] => 1776062208.4694
[time] => 0.00025391578674316
)
[1] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.4716
[end] => 1776062208.4719
[time] => 0.00023698806762695
)
[2] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.4719
[end] => 1776062208.474
[time] => 0.0021319389343262
)
[3] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.4742
[end] => 1776062208.4863
[time] => 0.012120962142944
)
[4] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.4866
[end] => 1776062208.4888
[time] => 0.0021700859069824
)
[5] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.4888
[end] => 1776062208.4891
[time] => 0.00022792816162109
)
[6] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.4891
[end] => 1776062208.4911
[time] => 0.0020191669464111
)
[7] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.4911
[end] => 1776062208.5033
[time] => 0.012132883071899
)
[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 (63,50) ORDER BY lastname,firstname ASC
[start] => 1776062208.5038
[end] => 1776062208.5047
[time] => 0.00096702575683594
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062208.5059
[end] => 1776062208.5063
[time] => 0.0003969669342041
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062208.5066
[end] => 1776062208.5069
[time] => 0.00025391578674316
)
[11] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1776062208.5069
[end] => 1776062208.5075
[time] => 0.00058889389038086
)
[12] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.508
[end] => 1776062208.5083
[time] => 0.00022220611572266
)
[13] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.5083
[end] => 1776062208.5103
[time] => 0.002047061920166
)
[14] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.5104
[end] => 1776062208.5225
[time] => 0.012094020843506
)
[15] => Array
(
[query] => select * from match_roster where match_id = '3911'
[start] => 1776062208.5228
[end] => 1776062208.5297
[time] => 0.0069191455841064
)
[16] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.5298
[end] => 1776062208.53
[time] => 0.00022006034851074
)
[17] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.53
[end] => 1776062208.5321
[time] => 0.0020802021026611
)
[18] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.5321
[end] => 1776062208.5442
[time] => 0.012052059173584
)
[19] => Array
(
[query] => select point.*, penalty.cumulative from point
inner join penalty on (point.penalty_id = penalty.penalty_id)
where point.match_id = '3911' and (point.point = 'P' or point.point = 'E')
[start] => 1776062208.5464
[end] => 1776062208.6122
[time] => 0.065875053405762
)
[20] => Array
(
[query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
[start] => 1776062208.6124
[end] => 1776062208.6127
[time] => 0.00034213066101074
)
[21] => Array
(
[query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
[start] => 1776062208.6128
[end] => 1776062208.6129
[time] => 0.00017881393432617
)
[22] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.613
[end] => 1776062208.6132
[time] => 0.00020813941955566
)
[23] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.6132
[end] => 1776062208.6153
[time] => 0.002047061920166
)
[24] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.6153
[end] => 1776062208.6275
[time] => 0.012156963348389
)
[25] => Array
(
[query] => select * from match_roster where match_id = '3911'
[start] => 1776062208.6278
[end] => 1776062208.6348
[time] => 0.006976842880249
)
[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 = '3911' group by player_id
[start] => 1776062208.6348
[end] => 1776062208.6771
[time] => 0.042290925979614
)
[27] => Array
(
[query] => select * from penalty_to_team where match_id = '3911'
[start] => 1776062208.6773
[end] => 1776062208.6776
[time] => 0.00036001205444336
)
[28] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.6777
[end] => 1776062208.6779
[time] => 0.00018811225891113
)
[29] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.6779
[end] => 1776062208.68
[time] => 0.0020771026611328
)
[30] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.6801
[end] => 1776062208.6922
[time] => 0.012125015258789
)
[31] => Array
(
[query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
[start] => 1776062208.6925
[end] => 1776062208.6928
[time] => 0.00029492378234863
)
[32] => Array
(
[query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
[start] => 1776062208.6929
[end] => 1776062208.6934
[time] => 0.00052118301391602
)
[33] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.6936
[end] => 1776062208.6938
[time] => 0.0002140998840332
)
[34] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.6938
[end] => 1776062208.6958
[time] => 0.0020220279693604
)
[35] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.6959
[end] => 1776062208.708
[time] => 0.012099981307983
)
[36] => Array
(
[query] => select * from match_staff_roster where match_id = '3911'
[start] => 1776062208.7082
[end] => 1776062208.709
[time] => 0.00080490112304688
)
[37] => Array
(
[query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
[start] => 1776062208.7091
[end] => 1776062208.7093
[time] => 0.00014901161193848
)
[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 = '3911' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
[start] => 1776062208.7093
[end] => 1776062208.7095
[time] => 0.0001828670501709
)
[39] => Array
(
[query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
[start] => 1776062208.7095
[end] => 1776062208.7097
[time] => 0.00015616416931152
)
[40] => Array
(
[query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
[start] => 1776062208.7097
[end] => 1776062208.7099
[time] => 0.00012898445129395
)
[41] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.71
[end] => 1776062208.7102
[time] => 0.00016403198242188
)
[42] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.7102
[end] => 1776062208.7123
[time] => 0.0020730495452881
)
[43] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.7123
[end] => 1776062208.7245
[time] => 0.012127876281738
)
[44] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.7248
[end] => 1776062208.725
[time] => 0.00023102760314941
)
[45] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.725
[end] => 1776062208.7271
[time] => 0.0020251274108887
)
[46] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.7271
[end] => 1776062208.7394
[time] => 0.012321949005127
)
[47] => Array
(
[query] => select * from match_roster where match_id = '3911'
[start] => 1776062208.7397
[end] => 1776062208.7467
[time] => 0.0069620609283447
)
[48] => Array
(
[query] => select * from point where match_id = '3911' order by point_id ASC
[start] => 1776062208.7467
[end] => 1776062208.8089
[time] => 0.062162160873413
)
[49] => Array
(
[query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
[start] => 1776062208.8095
[end] => 1776062208.8099
[time] => 0.0003509521484375
)
[50] => Array
(
[query] => select * from matches where match_id = '3911'
[start] => 1776062208.8099
[end] => 1776062208.8101
[time] => 0.00021696090698242
)
[51] => Array
(
[query] => select time,closed from match_time where match_id = '3911'
[start] => 1776062208.8102
[end] => 1776062208.8123
[time] => 0.0020978450775146
)
[52] => Array
(
[query] => SELECT * FROM match_data where match_id = '3911'
[start] => 1776062208.8123
[end] => 1776062208.8244
[time] => 0.012117862701416
)
[53] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1776062208.8269
[end] => 1776062208.8274
[time] => 0.00048995018005371
)
[54] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1776062208.8282
[end] => 1776062208.8285
[time] => 0.00026321411132812
)
)