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

Referto Partita: Flamurtari vs Sunknights

Referto Partita: Flamurtari vs Sunknights

Flamurtari

Flamurtari

Sunknights

Sunknights

RISULTATO FINALE

77

96

1° Tempo

33

30

2° Tempo

20

36

3° Tempo

24

30

INVASIONI A MURO

0

0

Data e Luogo


Campionato Campionato Eccellenza 2025/2026 A1
Giornata: 4
Data e Luogo 04-05-2026 20:45 - Cavour

Arbitri


Primo Arbitro Mondo Gianluca
Secondo Arbitro Mondo Gianluca
Refertista ASD Polaris

Sorteggio


Sorteggio Vinto Da Flamurtari
Scelta Sorteggio Palla

Annotazioni


Refertista di società: Francesca Da Re

Progresso

Punteggi Individuali

Flamurtari

  • Matteo Turigliatto
    Tot.

    30

    15
    x2
    0
    x3

    0
    x AUTOHIT
  • Riccardo Damiano
    Tot.

    4

    2
    x2
    0
    x3

    1
    x AUTOHIT
  • Pietro Evangelista
    Tot.

    42

    0
    x2
    14
    x3

    0
    x AUTOHIT
  • Federica Funnone
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT
  • Marco Zanatta
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT
  • Daniele Managò
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT
  • Angelo Zito
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT

Sunknights

  • Daniel Tiago Guzzafame
    10
    x2
    3
    x3

    0
    x AUTOHIT
    Tot.

    29

  • Alessio Casali
    2
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    10

  • Stefano Benedetto
    0
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    0

  • Alessandro Adami
    2
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    4

  • Maurizio Rattalino
    1
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    5

  • Mirko Violetto
    8
    x2
    9
    x3

    1
    x AUTOHIT
    Tot.

    43

  • Matteo Clara
    2
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    4

                Total Queries: 55
        Total Time: 0.38072824478149
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1786257081.8972
            [end] => 1786257081.8975
            [time] => 0.00029301643371582
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257081.8998
            [end] => 1786257081.9001
            [time] => 0.00028395652770996
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257081.9001
            [end] => 1786257081.9026
            [time] => 0.0024969577789307
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257081.9027
            [end] => 1786257081.9156
            [time] => 0.012829065322876
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257081.9159
            [end] => 1786257081.9184
            [time] => 0.0024528503417969
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257081.9185
            [end] => 1786257081.9187
            [time] => 0.00023198127746582
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257081.9187
            [end] => 1786257081.9211
            [time] => 0.0023479461669922
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257081.9212
            [end] => 1786257081.934
            [time] => 0.01288104057312
        )

    [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 (36,22) ORDER BY lastname,firstname ASC
            [start] => 1786257081.9345
            [end] => 1786257081.9355
            [time] => 0.0010719299316406
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257081.9391
            [end] => 1786257081.9393
            [time] => 0.00022602081298828
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257081.9393
            [end] => 1786257081.9417
            [time] => 0.0024049282073975
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257081.9418
            [end] => 1786257081.9546
            [time] => 0.012880086898804
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3972'
            [start] => 1786257081.9549
            [end] => 1786257081.9636
            [time] => 0.0086638927459717
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257081.9637
            [end] => 1786257081.964
            [time] => 0.00021886825561523
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257081.964
            [end] => 1786257081.9664
            [time] => 0.0023767948150635
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257081.9664
            [end] => 1786257081.9792
            [time] => 0.012794971466064
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3972' and (point.point = 'P' or point.point = 'E')
            [start] => 1786257081.9817
            [end] => 1786257082.0566
            [time] => 0.074918985366821
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257082.0574
            [end] => 1786257082.0576
            [time] => 0.00021600723266602
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257082.0577
            [end] => 1786257082.06
            [time] => 0.0023839473724365
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257082.0601
            [end] => 1786257082.0731
            [time] => 0.01294994354248
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3972'
            [start] => 1786257082.0734
            [end] => 1786257082.0814
            [time] => 0.0080771446228027
        )

    [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 = '3972' group by player_id
        
            [start] => 1786257082.0815
            [end] => 1786257082.129
            [time] => 0.047487020492554
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3972'
            [start] => 1786257082.1291
            [end] => 1786257082.1295
            [time] => 0.00038313865661621
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257082.1296
            [end] => 1786257082.1298
            [time] => 0.00020909309387207
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257082.1298
            [end] => 1786257082.1322
            [time] => 0.0023519992828369
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257082.1322
            [end] => 1786257082.145
            [time] => 0.012788057327271
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257082.1464
            [end] => 1786257082.1466
            [time] => 0.00019502639770508
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257082.1466
            [end] => 1786257082.149
            [time] => 0.0023529529571533
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257082.149
            [end] => 1786257082.1619
            [time] => 0.012825965881348
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3972'
            [start] => 1786257082.1624
            [end] => 1786257082.1634
            [time] => 0.00097393989562988
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1786257082.1635
            [end] => 1786257082.1637
            [time] => 0.00016498565673828
        )

    [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 = '3972' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1786257082.1637
            [end] => 1786257082.1639
            [time] => 0.00020289421081543
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257082.1645
            [end] => 1786257082.1646
            [time] => 0.00017213821411133
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257082.1646
            [end] => 1786257082.167
            [time] => 0.0023708343505859
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257082.1671
            [end] => 1786257082.1798
            [time] => 0.012703895568848
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257082.1801
            [end] => 1786257082.1803
            [time] => 0.00022697448730469
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257082.1803
            [end] => 1786257082.1827
            [time] => 0.0023860931396484
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257082.1828
            [end] => 1786257082.1955
            [time] => 0.01272988319397
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3972'
            [start] => 1786257082.1959
            [end] => 1786257082.2039
            [time] => 0.0080790519714355
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3972' order by point_id ASC
            [start] => 1786257082.204
            [end] => 1786257082.2738
            [time] => 0.069747924804688
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3972'
            [start] => 1786257082.2748
            [end] => 1786257082.275
            [time] => 0.00021004676818848
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3972'
            [start] => 1786257082.275
            [end] => 1786257082.2774
            [time] => 0.0024020671844482
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3972'
            [start] => 1786257082.2775
            [end] => 1786257082.2903
            [time] => 0.012798070907593
        )

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

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

)