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

Referto Partita: Homeless vs Krakens Chivasso

Referto Partita: Homeless vs Krakens Chivasso

Homeless

Homeless

Krakens Chivasso

Krakens Chivasso

RISULTATO FINALE

67

84

1° Tempo

21

31

2° Tempo

23

38

3° Tempo

23

15

INVASIONI A MURO

1

2

Data e Luogo


Campionato Campionato Eccellenza 2025/2026 B2
Giornata: 9
Data e Luogo 13-02-2026 20:45 - Cavour

Arbitri


Primo Arbitro Zanetti Gianluca
Secondo Arbitro Zanetti Gianluca
Refertista ASD Polaris

Sorteggio


Sorteggio Vinto Da Homeless
Scelta Sorteggio Campo

Annotazioni


Refertista di società: Francesca Da Re

Progresso

Punteggi Individuali

Homeless

  • Fabio Zorzan
    Tot.

    9

    3
    x2
    1
    x3

    0
    x AUTOHIT
  • Gaetano Rendine
    Tot.

    18

    3
    x2
    4
    x3

    0
    x AUTOHIT
  • Elena Pasino
    Tot.

    3

    0
    x2
    1
    x3

    1
    x AUTOHIT
  • Pierluigi Marchisio
    Tot.

    2

    1
    x2
    0
    x3

    0
    x AUTOHIT
  • Andrea Merlo
    Tot.

    15

    3
    x2
    3
    x3

    0
    x AUTOHIT
  • Davide Baldus
    Tot.

    13

    5
    x2
    1
    x3

    0
    x AUTOHIT
  • Giovanni Aquila
    Tot.

    5

    1
    x2
    1
    x3

    0
    x AUTOHIT

Krakens Chivasso

  • Gioele Alesina
    9
    x2
    4
    x3

    1
    x AUTOHIT
    Tot.

    30

  • Nicolò Signorini
    10
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    26

  • Franco Augustin Signori
    4
    x2
    0
    x3

    1
    x AUTOHIT
    Tot.

    8

  • Francesco Ghio
    1
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    2

  • Francesco Signorini
    2
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    10

  • Mattia Calvio
    2
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    7

                Total Queries: 55
        Total Time: 0.37840962409973
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1786252905.0162
            [end] => 1786252905.0165
            [time] => 0.0003058910369873
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.0189
            [end] => 1786252905.0192
            [time] => 0.00022983551025391
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.0192
            [end] => 1786252905.0216
            [time] => 0.0024099349975586
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.0217
            [end] => 1786252905.0344
            [time] => 0.012738943099976
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.0348
            [end] => 1786252905.0372
            [time] => 0.0023989677429199
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.0373
            [end] => 1786252905.0375
            [time] => 0.00022196769714355
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.0375
            [end] => 1786252905.0398
            [time] => 0.0023279190063477
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.0399
            [end] => 1786252905.0526
            [time] => 0.012715816497803
        )

    [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 (43,54) ORDER BY lastname,firstname ASC
            [start] => 1786252905.053
            [end] => 1786252905.0541
            [time] => 0.001107931137085
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.0579
            [end] => 1786252905.0581
            [time] => 0.0001981258392334
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.0581
            [end] => 1786252905.0604
            [time] => 0.002357006072998
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.0605
            [end] => 1786252905.0732
            [time] => 0.012733936309814
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '4359'
            [start] => 1786252905.0735
            [end] => 1786252905.0815
            [time] => 0.0079920291900635
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.0816
            [end] => 1786252905.0818
            [time] => 0.00025415420532227
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.0818
            [end] => 1786252905.0842
            [time] => 0.0023758411407471
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.0843
            [end] => 1786252905.0971
            [time] => 0.012795925140381
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '4359' and (point.point = 'P' or point.point = 'E')
            [start] => 1786252905.0996
            [end] => 1786252905.1742
            [time] => 0.074531078338623
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.175
            [end] => 1786252905.1752
            [time] => 0.00019693374633789
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.1752
            [end] => 1786252905.1776
            [time] => 0.0023961067199707
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.1776
            [end] => 1786252905.1904
            [time] => 0.012738227844238
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '4359'
            [start] => 1786252905.1906
            [end] => 1786252905.1987
            [time] => 0.0081119537353516
        )

    [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 = '4359' group by player_id
        
            [start] => 1786252905.1988
            [end] => 1786252905.246
            [time] => 0.047285795211792
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '4359'
            [start] => 1786252905.2462
            [end] => 1786252905.2466
            [time] => 0.00038290023803711
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.2467
            [end] => 1786252905.2469
            [time] => 0.00020694732666016
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.2469
            [end] => 1786252905.2492
            [time] => 0.002371072769165
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.2493
            [end] => 1786252905.2621
            [time] => 0.012778997421265
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.2635
            [end] => 1786252905.2637
            [time] => 0.00020885467529297
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.2637
            [end] => 1786252905.2661
            [time] => 0.0023930072784424
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.2662
            [end] => 1786252905.2789
            [time] => 0.012763023376465
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '4359'
            [start] => 1786252905.2792
            [end] => 1786252905.2802
            [time] => 0.00098395347595215
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1786252905.2803
            [end] => 1786252905.2805
            [time] => 0.00018787384033203
        )

    [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 = '4359' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1786252905.2805
            [end] => 1786252905.2807
            [time] => 0.00020885467529297
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.2813
            [end] => 1786252905.2815
            [time] => 0.0001981258392334
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.2815
            [end] => 1786252905.2838
            [time] => 0.0023608207702637
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.2839
            [end] => 1786252905.2966
            [time] => 0.012709856033325
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.297
            [end] => 1786252905.2972
            [time] => 0.0002138614654541
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.2972
            [end] => 1786252905.2996
            [time] => 0.002371072769165
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.2996
            [end] => 1786252905.3123
            [time] => 0.012711048126221
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '4359'
            [start] => 1786252905.3126
            [end] => 1786252905.3205
            [time] => 0.0079660415649414
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '4359' order by point_id ASC
            [start] => 1786252905.3206
            [end] => 1786252905.3902
            [time] => 0.069653034210205
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '4359'
            [start] => 1786252905.3913
            [end] => 1786252905.3915
            [time] => 0.00021004676818848
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '4359'
            [start] => 1786252905.3916
            [end] => 1786252905.394
            [time] => 0.0023941993713379
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4359'
            [start] => 1786252905.394
            [end] => 1786252905.4068
            [time] => 0.012760162353516
        )

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

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

)