Referto Partita: Rising Titans vs Hocheti Pokety
Rising Titans
Hocheti Pokety
RISULTATO FINALE
75
77
1° Tempo
17
29
2° Tempo
30
26
3° Tempo
28
22
INVASIONI A MURO
0
1
Data e Luogo
Campionato
Campionato Eccellenza 2023/2024 B1
Giornata: 3
Giornata: 3
Data e Luogo
19-11-2023 15:35 - Maritano
Arbitri
Primo Arbitro
Botosso Daniele
Secondo Arbitro
Tombolato Barbara
Refertista
ASD SportingTeam
Sorteggio
Sorteggio Vinto Da
Hocheti Pokety
Scelta Sorteggio
Campo
Annotazioni
Refertista; Riccardo Pajno Ferrara
Addetto media: Murillo Alessandro
Progresso
Punteggi Individuali
Rising Titans
-
Ivan BilettaTot.6
3
x20
x3
0
x AUTOHIT -
Marco BarberoTot.21
6
x23
x3
0
x AUTOHIT -
Vincenzo De FeliceTot.4
2
x20
x3
0
x AUTOHIT -
Andrea GiannittiTot.14
7
x20
x3
1
x AUTOHIT -
Andrea VecchiattiniTot.30
9
x24
x3
0
x AUTOHIT
Hocheti Pokety
-
Edoardo Francesco Stefanelli
4
x20
x3
0
x AUTOHITTot.8
Thomas Rovetto
0
x20
x3
0
x AUTOHITTot.0
Alberto Racco
4
x23
x3
0
x AUTOHITTot.17
Simone De Meo
9
x20
x3
0
x AUTOHITTot.18
Samuel Romanazzi
1
x21
x3
0
x AUTOHITTot.5
Divisa di gioco non regolamentare (Minuto: - 1T)Simone Poser
2
x20
x3
0
x AUTOHITTot.4
Luigi Ghirardi
3
x20
x3
0
x AUTOHITTot.6
Divisa di gioco non regolamentare (Minuto: - 1T)Gioco antisportivo (Minuto: 13 - 4T)Ramon Rutigliano
5
x20
x3
0
x AUTOHITTot.10
Ivan Dastrù
4
x20
x3
0
x AUTOHITTot.8
Sanzioni Disciplinari
Rising Titans
Hocheti Pokety
-
8. Samuel RomanazziDivisa di gioco non regolamentare (Minuto: - 1T)
-
3. Luigi GhirardiDivisa di gioco non regolamentare (Minuto: - 1T)
Gioco antisportivo (Minuto: 13 - 4T)
Total Queries: 55 Total Time: 0.42745518684387 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1766071337.0264 [end] => 1766071337.0267 [time] => 0.00030684471130371 ) [1] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.0309 [end] => 1766071337.0319 [time] => 0.0010418891906738 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.032 [end] => 1766071337.0359 [time] => 0.0038900375366211 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.036 [end] => 1766071337.0576 [time] => 0.02157998085022 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.0579 [end] => 1766071337.0617 [time] => 0.0038058757781982 ) [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] => 1766071337.062 [end] => 1766071337.0754 [time] => 0.013411998748779 ) [6] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1766071337.0809 [end] => 1766071337.0814 [time] => 0.0005338191986084 ) [7] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1766071337.0818 [end] => 1766071337.0821 [time] => 0.00024890899658203 ) [8] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1766071337.0821 [end] => 1766071337.0829 [time] => 0.00071096420288086 ) [9] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.0833 [end] => 1766071337.0847 [time] => 0.0013980865478516 ) [10] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.0848 [end] => 1766071337.0885 [time] => 0.0037550926208496 ) [11] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.0886 [end] => 1766071337.1101 [time] => 0.021569013595581 ) [12] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1766071337.1104 [end] => 1766071337.1238 [time] => 0.013413190841675 ) [13] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.1239 [end] => 1766071337.1259 [time] => 0.0019750595092773 ) [14] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.1259 [end] => 1766071337.1298 [time] => 0.0038759708404541 ) [15] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.1299 [end] => 1766071337.1527 [time] => 0.02283501625061 ) [16] => Array ( [query] => select point.*, penalty.cumulative from point inner join penalty on (point.penalty_id = penalty.penalty_id) where point.match_id = '3163' and (point.point = 'P' or point.point = 'E') [start] => 1766071337.1553 [end] => 1766071337.2617 [time] => 0.10646200180054 ) [17] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1766071337.2619 [end] => 1766071337.2622 [time] => 0.00031208992004395 ) [18] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1766071337.2623 [end] => 1766071337.2624 [time] => 0.00017309188842773 ) [19] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.2625 [end] => 1766071337.2627 [time] => 0.00021100044250488 ) [20] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.2628 [end] => 1766071337.2646 [time] => 0.0018749237060547 ) [21] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.2647 [end] => 1766071337.2762 [time] => 0.011457920074463 ) [22] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1766071337.2765 [end] => 1766071337.2827 [time] => 0.006213903427124 ) [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 = '3163' group by player_id [start] => 1766071337.2827 [end] => 1766071337.321 [time] => 0.038275957107544 ) [24] => Array ( [query] => select * from penalty_to_team where match_id = '3163' [start] => 1766071337.3212 [end] => 1766071337.3216 [time] => 0.00041985511779785 ) [25] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.3217 [end] => 1766071337.3219 [time] => 0.00020790100097656 ) [26] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.322 [end] => 1766071337.3238 [time] => 0.0018868446350098 ) [27] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.3239 [end] => 1766071337.3354 [time] => 0.011505126953125 ) [28] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1766071337.3358 [end] => 1766071337.336 [time] => 0.00027203559875488 ) [29] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1766071337.3361 [end] => 1766071337.3368 [time] => 0.00062799453735352 ) [30] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.337 [end] => 1766071337.3372 [time] => 0.00020503997802734 ) [31] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.3372 [end] => 1766071337.3391 [time] => 0.0018661022186279 ) [32] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.3391 [end] => 1766071337.3505 [time] => 0.011357069015503 ) [33] => Array ( [query] => select * from match_staff_roster where match_id = '3163' [start] => 1766071337.3508 [end] => 1766071337.3515 [time] => 0.00069594383239746 ) [34] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1766071337.3516 [end] => 1766071337.3518 [time] => 0.00019311904907227 ) [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 = '3163' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1766071337.3518 [end] => 1766071337.352 [time] => 0.00022196769714355 ) [36] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1766071337.3521 [end] => 1766071337.3523 [time] => 0.00015997886657715 ) [37] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1766071337.3523 [end] => 1766071337.3525 [time] => 0.00016093254089355 ) [38] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.3527 [end] => 1766071337.3529 [time] => 0.00022315979003906 ) [39] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.3529 [end] => 1766071337.3548 [time] => 0.0019080638885498 ) [40] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.3549 [end] => 1766071337.3664 [time] => 0.011526107788086 ) [41] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.3668 [end] => 1766071337.3671 [time] => 0.00030088424682617 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.3671 [end] => 1766071337.369 [time] => 0.0018880367279053 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.369 [end] => 1766071337.3805 [time] => 0.011449098587036 ) [44] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1766071337.3808 [end] => 1766071337.387 [time] => 0.0061612129211426 ) [45] => Array ( [query] => select * from point where match_id = '3163' order by point_id ASC [start] => 1766071337.387 [end] => 1766071337.4433 [time] => 0.056281089782715 ) [46] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.4439 [end] => 1766071337.4442 [time] => 0.0003349781036377 ) [47] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.4442 [end] => 1766071337.4462 [time] => 0.0019481182098389 ) [48] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.4462 [end] => 1766071337.4577 [time] => 0.011494874954224 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1766071337.4582 [end] => 1766071337.4585 [time] => 0.00033307075500488 ) [50] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1766071337.4586 [end] => 1766071337.4588 [time] => 0.00023484230041504 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1766071337.4588 [end] => 1766071337.4607 [time] => 0.0018460750579834 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1766071337.4607 [end] => 1766071337.4723 [time] => 0.011620044708252 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1766071337.4748 [end] => 1766071337.4753 [time] => 0.00047802925109863 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1766071337.4761 [end] => 1766071337.4764 [time] => 0.00031495094299316 ) )