DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG
DEBUG - DEBUG - DEBUG

Referto Partita: Sotomayor vs Skoppiati

Referto Partita: Sotomayor vs Skoppiati

Sotomayor

Sotomayor

Skoppiati

Skoppiati

RISULTATO FINALE

100

51

1° Tempo

30

20

2° Tempo

34

14

3° Tempo

36

17

INVASIONI A MURO

1

2

Data e Luogo


Campionato Campionato Eccellenza 2025/2026 A1
Giornata: 3
Data e Luogo 14-11-2025 19:55 - HitBall Arena

Arbitri


Primo Arbitro Riccio Roberto
Secondo Arbitro Riccio Roberto
Refertista ASD Polaris

Sorteggio


Sorteggio Vinto Da Skoppiati
Scelta Sorteggio Palla

Annotazioni


Refertista: Capitolo Sabrina

Progresso

Punteggi Individuali

Sotomayor

  • Roberto Coletta
    Tot.

    14

    7
    x2
    0
    x3

    0
    x AUTOHIT
  • Enrico Demonte
    Tot.

    26

    13
    x2
    0
    x3

    0
    x AUTOHIT
  • Martina Lupo
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT
  • Daniele Agnello
    Tot.

    23

    7
    x2
    3
    x3

    0
    x AUTOHIT
  • Alessio Petrosino
    Tot.

    10

    5
    x2
    0
    x3

    0
    x AUTOHIT
  • Marco De Salvo
    Tot.

    27

    12
    x2
    1
    x3

    0
    x AUTOHIT

Skoppiati

  • Riccardo Francabandiera
    6
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    15

  • Giovanni Marsico
    2
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    10

  • Lennin Jarek Garcia
    3
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    6

  • Lorenzo Fontana
    0
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    0

  • Ion Soroceanu
    3
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    12

  • Andrea Cacioli
    1
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    8

                Total Queries: 55
        Total Time: 0.67178106307983
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781164254.5387
            [end] => 1781164254.5427
            [time] => 0.0039370059967041
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.5475
            [end] => 1781164254.5479
            [time] => 0.00037097930908203
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.5479
            [end] => 1781164254.5545
            [time] => 0.0065150260925293
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.5546
            [end] => 1781164254.5928
            [time] => 0.038227796554565
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.5932
            [end] => 1781164254.5967
            [time] => 0.0035011768341064
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.5968
            [end] => 1781164254.597
            [time] => 0.00021791458129883
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.597
            [end] => 1781164254.5994
            [time] => 0.0024008750915527
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.5995
            [end] => 1781164254.6123
            [time] => 0.012849807739258
        )

    [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 (1,11) ORDER BY lastname,firstname ASC
            [start] => 1781164254.6127
            [end] => 1781164254.6137
            [time] => 0.00092601776123047
        )

    [9] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1781164254.6148
            [end] => 1781164254.6153
            [time] => 0.00050497055053711
        )

    [10] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1781164254.6158
            [end] => 1781164254.6161
            [time] => 0.00030899047851562
        )

    [11] => Array
        (
            [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
            [start] => 1781164254.6162
            [end] => 1781164254.6168
            [time] => 0.00066494941711426
        )

    [12] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.6173
            [end] => 1781164254.6175
            [time] => 0.00024700164794922
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.6176
            [end] => 1781164254.62
            [time] => 0.0024838447570801
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.6201
            [end] => 1781164254.6398
            [time] => 0.019661903381348
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3969'
            [start] => 1781164254.6401
            [end] => 1781164254.6482
            [time] => 0.008105993270874
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.6484
            [end] => 1781164254.6487
            [time] => 0.00030088424682617
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.6487
            [end] => 1781164254.6512
            [time] => 0.0024871826171875
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.6512
            [end] => 1781164254.6725
            [time] => 0.021295070648193
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3969' and (point.point = 'P' or point.point = 'E')
            [start] => 1781164254.675
            [end] => 1781164254.7555
            [time] => 0.080458879470825
        )

    [20] => Array
        (
            [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
            [start] => 1781164254.7556
            [end] => 1781164254.7558
            [time] => 0.00025796890258789
        )

    [21] => Array
        (
            [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
            [start] => 1781164254.7559
            [end] => 1781164254.7567
            [time] => 0.00079011917114258
        )

    [22] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.7568
            [end] => 1781164254.757
            [time] => 0.00019502639770508
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.757
            [end] => 1781164254.7625
            [time] => 0.0054311752319336
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.7625
            [end] => 1781164254.7883
            [time] => 0.025804042816162
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3969'
            [start] => 1781164254.7886
            [end] => 1781164254.8058
            [time] => 0.017153024673462
        )

    [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 = '3969' group by player_id
        
            [start] => 1781164254.8058
            [end] => 1781164254.9028
            [time] => 0.096987962722778
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3969'
            [start] => 1781164254.903
            [end] => 1781164254.9043
            [time] => 0.0012900829315186
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.9043
            [end] => 1781164254.9046
            [time] => 0.00023317337036133
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.9046
            [end] => 1781164254.908
            [time] => 0.0034520626068115
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.9081
            [end] => 1781164254.9357
            [time] => 0.027601957321167
        )

    [31] => Array
        (
            [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
            [start] => 1781164254.9361
            [end] => 1781164254.9364
            [time] => 0.00031805038452148
        )

    [32] => Array
        (
            [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
            [start] => 1781164254.9365
            [end] => 1781164254.9379
            [time] => 0.0014419555664062
        )

    [33] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.9389
            [end] => 1781164254.9391
            [time] => 0.00023794174194336
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.9391
            [end] => 1781164254.9446
            [time] => 0.0054931640625
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.9447
            [end] => 1781164254.9718
            [time] => 0.027095079421997
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3969'
            [start] => 1781164254.9721
            [end] => 1781164254.9747
            [time] => 0.0025961399078369
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1781164254.9749
            [end] => 1781164254.9751
            [time] => 0.00023388862609863
        )

    [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 = '3969' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1781164254.9751
            [end] => 1781164254.9754
            [time] => 0.00023102760314941
        )

    [39] => Array
        (
            [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
            [start] => 1781164254.9754
            [end] => 1781164254.9756
            [time] => 0.00018596649169922
        )

    [40] => Array
        (
            [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
            [start] => 1781164254.9757
            [end] => 1781164254.9759
            [time] => 0.00022196769714355
        )

    [41] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164254.9761
            [end] => 1781164254.9763
            [time] => 0.0002140998840332
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164254.9763
            [end] => 1781164254.9808
            [time] => 0.0044469833374023
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164254.9808
            [end] => 1781164255.0061
            [time] => 0.025208950042725
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164255.0064
            [end] => 1781164255.009
            [time] => 0.0025620460510254
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164255.009
            [end] => 1781164255.0114
            [time] => 0.0024070739746094
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164255.0115
            [end] => 1781164255.0362
            [time] => 0.024755954742432
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3969'
            [start] => 1781164255.0365
            [end] => 1781164255.0524
            [time] => 0.015902042388916
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3969' order by point_id ASC
            [start] => 1781164255.0525
            [end] => 1781164255.1929
            [time] => 0.14045000076294
        )

    [49] => Array
        (
            [query] => select * from penalty where deleted = '0' ORDER BY penalty_id ASC
            [start] => 1781164255.1936
            [end] => 1781164255.1947
            [time] => 0.0011610984802246
        )

    [50] => Array
        (
            [query] => select * from matches where match_id = '3969'
            [start] => 1781164255.1948
            [end] => 1781164255.195
            [time] => 0.00021004676818848
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3969'
            [start] => 1781164255.195
            [end] => 1781164255.1985
            [time] => 0.003432035446167
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3969'
            [start] => 1781164255.1985
            [end] => 1781164255.2259
            [time] => 0.027367830276489
        )

    [53] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1781164255.2296
            [end] => 1781164255.2301
            [time] => 0.00055384635925293
        )

    [54] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1781164255.2318
            [end] => 1781164255.2322
            [time] => 0.00039100646972656
        )

)