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.34392142295837 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1776062171.201 [end] => 1776062171.2012 [time] => 0.00024795532226562 ) [1] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.2034 [end] => 1776062171.2037 [time] => 0.00021100044250488 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.2037 [end] => 1776062171.2058 [time] => 0.002108097076416 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.2059 [end] => 1776062171.2179 [time] => 0.012089967727661 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.2182 [end] => 1776062171.2204 [time] => 0.0021429061889648 ) [5] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.2205 [end] => 1776062171.2207 [time] => 0.00025510787963867 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.2207 [end] => 1776062171.2227 [time] => 0.0020151138305664 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.2228 [end] => 1776062171.2348 [time] => 0.012026071548462 ) [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 (3,6) ORDER BY lastname,firstname ASC [start] => 1776062171.2353 [end] => 1776062171.2362 [time] => 0.00096893310546875 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776062171.2375 [end] => 1776062171.238 [time] => 0.00050187110900879 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776062171.2383 [end] => 1776062171.2385 [time] => 0.00022101402282715 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1776062171.2386 [end] => 1776062171.2392 [time] => 0.00063014030456543 ) [12] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.2397 [end] => 1776062171.2399 [time] => 0.00020408630371094 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.2399 [end] => 1776062171.242 [time] => 0.0020689964294434 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.2421 [end] => 1776062171.2541 [time] => 0.012038946151733 ) [15] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1776062171.2544 [end] => 1776062171.2613 [time] => 0.0069441795349121 ) [16] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.2614 [end] => 1776062171.2616 [time] => 0.00024604797363281 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.2617 [end] => 1776062171.2637 [time] => 0.0020511150360107 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.2638 [end] => 1776062171.2758 [time] => 0.012004852294922 ) [19] => 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] => 1776062171.2779 [end] => 1776062171.3441 [time] => 0.066175937652588 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1776062171.3443 [end] => 1776062171.3446 [time] => 0.00031805038452148 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1776062171.3446 [end] => 1776062171.3448 [time] => 0.00017905235290527 ) [22] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.3449 [end] => 1776062171.3451 [time] => 0.00019717216491699 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.3451 [end] => 1776062171.3472 [time] => 0.0020720958709717 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.3473 [end] => 1776062171.3593 [time] => 0.012063026428223 ) [25] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1776062171.3596 [end] => 1776062171.3666 [time] => 0.0070037841796875 ) [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 = '3163' group by player_id [start] => 1776062171.3666 [end] => 1776062171.4089 [time] => 0.042226791381836 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '3163' [start] => 1776062171.409 [end] => 1776062171.4094 [time] => 0.00034999847412109 ) [28] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.4094 [end] => 1776062171.4096 [time] => 0.00018095970153809 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.4096 [end] => 1776062171.4117 [time] => 0.0020492076873779 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.4117 [end] => 1776062171.4239 [time] => 0.012154102325439 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1776062171.4242 [end] => 1776062171.4245 [time] => 0.00025701522827148 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1776062171.4245 [end] => 1776062171.4251 [time] => 0.00054001808166504 ) [33] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.4253 [end] => 1776062171.4255 [time] => 0.00020790100097656 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.4255 [end] => 1776062171.4275 [time] => 0.0020499229431152 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.4276 [end] => 1776062171.4396 [time] => 0.012024879455566 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '3163' [start] => 1776062171.4399 [end] => 1776062171.4408 [time] => 0.00082492828369141 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1776062171.4409 [end] => 1776062171.441 [time] => 0.00017023086547852 ) [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 = '3163' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E') [start] => 1776062171.441 [end] => 1776062171.4412 [time] => 0.00020289421081543 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1776062171.4413 [end] => 1776062171.4415 [time] => 0.00015997886657715 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1776062171.4415 [end] => 1776062171.4417 [time] => 0.00014710426330566 ) [41] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.4418 [end] => 1776062171.442 [time] => 0.00016617774963379 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.442 [end] => 1776062171.4441 [time] => 0.0020749568939209 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.4441 [end] => 1776062171.4561 [time] => 0.012010812759399 ) [44] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.4564 [end] => 1776062171.4567 [time] => 0.0002751350402832 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.4567 [end] => 1776062171.4588 [time] => 0.002112865447998 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.4589 [end] => 1776062171.4709 [time] => 0.012004852294922 ) [47] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1776062171.4711 [end] => 1776062171.4781 [time] => 0.0069601535797119 ) [48] => Array ( [query] => select * from point where match_id = '3163' order by point_id ASC [start] => 1776062171.4781 [end] => 1776062171.5403 [time] => 0.062135934829712 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1776062171.541 [end] => 1776062171.5413 [time] => 0.00032186508178711 ) [50] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1776062171.5414 [end] => 1776062171.5417 [time] => 0.00028705596923828 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1776062171.5417 [end] => 1776062171.5438 [time] => 0.0020809173583984 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1776062171.5439 [end] => 1776062171.556 [time] => 0.012129068374634 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1776062171.5585 [end] => 1776062171.559 [time] => 0.00051617622375488 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1776062171.5598 [end] => 1776062171.5601 [time] => 0.00031399726867676 ) )