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: 1.7000007629395 Array ( [0] => Array ( [query] => select * from setting where property = 'datetime_timezone' [start] => 1786249884.2632 [end] => 1786249884.2634 [time] => 0.0002748966217041 ) [1] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249884.2683 [end] => 1786249884.2686 [time] => 0.00025606155395508 ) [2] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249884.2686 [end] => 1786249884.2769 [time] => 0.0082850456237793 ) [3] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249884.277 [end] => 1786249884.3387 [time] => 0.061755895614624 ) [4] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249884.339 [end] => 1786249884.3478 [time] => 0.0087630748748779 ) [5] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249884.3479 [end] => 1786249884.3482 [time] => 0.00025296211242676 ) [6] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249884.3482 [end] => 1786249884.3579 [time] => 0.0097367763519287 ) [7] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249884.358 [end] => 1786249884.4289 [time] => 0.070935964584351 ) [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] => 1786249884.4293 [end] => 1786249884.4304 [time] => 0.0010411739349365 ) [9] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1786249884.4316 [end] => 1786249884.4341 [time] => 0.0025410652160645 ) [10] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1786249884.4345 [end] => 1786249884.4386 [time] => 0.0041167736053467 ) [11] => Array ( [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC [start] => 1786249884.4387 [end] => 1786249884.4424 [time] => 0.003676176071167 ) [12] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249884.4429 [end] => 1786249884.4432 [time] => 0.00024604797363281 ) [13] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249884.4432 [end] => 1786249884.4571 [time] => 0.013852834701538 ) [14] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249884.4571 [end] => 1786249884.5245 [time] => 0.067420959472656 ) [15] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1786249884.5248 [end] => 1786249884.5613 [time] => 0.036457061767578 ) [16] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249884.5614 [end] => 1786249884.5761 [time] => 0.01477313041687 ) [17] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249884.5762 [end] => 1786249884.5867 [time] => 0.01047682762146 ) [18] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249884.5868 [end] => 1786249884.6482 [time] => 0.061413049697876 ) [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] => 1786249884.6506 [end] => 1786249885.0256 [time] => 0.37505984306335 ) [20] => Array ( [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC [start] => 1786249885.0258 [end] => 1786249885.032 [time] => 0.0061559677124023 ) [21] => Array ( [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC [start] => 1786249885.032 [end] => 1786249885.0322 [time] => 0.0001990795135498 ) [22] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249885.0323 [end] => 1786249885.0326 [time] => 0.00022196769714355 ) [23] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249885.0326 [end] => 1786249885.0437 [time] => 0.011161804199219 ) [24] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249885.0438 [end] => 1786249885.1418 [time] => 0.097979068756104 ) [25] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1786249885.1421 [end] => 1786249885.1948 [time] => 0.052733898162842 ) [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] => 1786249885.1948 [end] => 1786249885.4167 [time] => 0.2218542098999 ) [27] => Array ( [query] => select * from penalty_to_team where match_id = '3163' [start] => 1786249885.4169 [end] => 1786249885.4187 [time] => 0.0018410682678223 ) [28] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249885.4188 [end] => 1786249885.4209 [time] => 0.0020918846130371 ) [29] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249885.4209 [end] => 1786249885.4239 [time] => 0.0030450820922852 ) [30] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249885.424 [end] => 1786249885.4558 [time] => 0.031779050827026 ) [31] => Array ( [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC [start] => 1786249885.4561 [end] => 1786249885.4609 [time] => 0.0048580169677734 ) [32] => Array ( [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC [start] => 1786249885.4611 [end] => 1786249885.4632 [time] => 0.0021970272064209 ) [33] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249885.4634 [end] => 1786249885.4647 [time] => 0.0012829303741455 ) [34] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249885.4648 [end] => 1786249885.4692 [time] => 0.004486083984375 ) [35] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249885.4693 [end] => 1786249885.5067 [time] => 0.037409067153931 ) [36] => Array ( [query] => select * from match_staff_roster where match_id = '3163' [start] => 1786249885.507 [end] => 1786249885.5117 [time] => 0.0047571659088135 ) [37] => Array ( [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC [start] => 1786249885.5119 [end] => 1786249885.5121 [time] => 0.00019311904907227 ) [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] => 1786249885.5121 [end] => 1786249885.5123 [time] => 0.00021791458129883 ) [39] => Array ( [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC [start] => 1786249885.5124 [end] => 1786249885.5125 [time] => 0.00016403198242188 ) [40] => Array ( [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC [start] => 1786249885.5126 [end] => 1786249885.5177 [time] => 0.0051360130310059 ) [41] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249885.5179 [end] => 1786249885.5182 [time] => 0.00023603439331055 ) [42] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249885.5182 [end] => 1786249885.5206 [time] => 0.0023849010467529 ) [43] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249885.5206 [end] => 1786249885.5682 [time] => 0.047552824020386 ) [44] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249885.5685 [end] => 1786249885.571 [time] => 0.0025460720062256 ) [45] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249885.571 [end] => 1786249885.5819 [time] => 0.010864019393921 ) [46] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249885.582 [end] => 1786249885.6258 [time] => 0.043751955032349 ) [47] => Array ( [query] => select * from match_roster where match_id = '3163' [start] => 1786249885.626 [end] => 1786249885.6556 [time] => 0.029607057571411 ) [48] => Array ( [query] => select * from point where match_id = '3163' order by point_id ASC [start] => 1786249885.6556 [end] => 1786249885.9165 [time] => 0.26082706451416 ) [49] => Array ( [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC [start] => 1786249885.9171 [end] => 1786249885.9183 [time] => 0.0011379718780518 ) [50] => Array ( [query] => select * from matches where match_id = '3163' [start] => 1786249885.9183 [end] => 1786249885.9186 [time] => 0.00021100044250488 ) [51] => Array ( [query] => select time,closed from match_time where match_id = '3163' [start] => 1786249885.9186 [end] => 1786249885.9261 [time] => 0.0075109004974365 ) [52] => Array ( [query] => SELECT * FROM match_data where match_id = '3163' [start] => 1786249885.9262 [end] => 1786249885.9734 [time] => 0.047230958938599 ) [53] => Array ( [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC [start] => 1786249885.977 [end] => 1786249885.9813 [time] => 0.0042939186096191 ) [54] => Array ( [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC [start] => 1786249885.9822 [end] => 1786249885.9829 [time] => 0.00074601173400879 ) )