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

Referto Partita: Torino Warriors vs Black Knights

Referto Partita: Torino Warriors vs Black Knights

Torino Warriors

Torino Warriors

Black Knights

Black Knights

RISULTATO FINALE

70

84

1° Tempo

26

29

2° Tempo

18

27

3° Tempo

26

28

INVASIONI A MURO

1

1

Data e Luogo


Campionato Campionato Eccellenza 2024/2025 A2
Giornata: 13
Data e Luogo 11-03-2025 21:35 - Frassati

Arbitri


Primo Arbitro Specchiulli Pier Paolo
Secondo Arbitro Ianniello Valerio
Refertista ASD Sinombre

Sorteggio


Sorteggio Vinto Da Black Knights
Scelta Sorteggio Palla

Annotazioni


Refertista: Filippo Venturini

Progresso

Punteggi Individuali

Torino Warriors

  • Stefano Borelli
    Tot.

    20

    7
    x2
    2
    x3

    0
    x AUTOHIT
  • Giacomo Guarrato
    Tot.

    17

    7
    x2
    1
    x3

    0
    x AUTOHIT
  • Marco Gamba
    Tot.

    19

    8
    x2
    1
    x3

    0
    x AUTOHIT
  • Carlotta Amodeo
    Tot.

    11

    4
    x2
    1
    x3

    0
    x AUTOHIT
  • Antonio D'Elicio
    Tot.

    2

    1
    x2
    0
    x3

    0
    x AUTOHIT

Black Knights

  • Fabio Bragagnolo
    7
    x2
    1
    x3

    1
    x AUTOHIT
    Tot.

    17

  • Lorenzo De Nicola Civitarese
    11
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    25

  • Marco Antinoro
    7
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    20

  • Matteo Vanni
    8
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    22

Sanzioni di Squadra

Torino Warriors


  • Nessuna penalità di squadra.

Black Knights


  • Formazione Incompleta
                Total Queries: 55
        Total Time: 0.3511438369751
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770971478.1948
            [end] => 1770971478.1951
            [time] => 0.00029301643371582
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.1972
            [end] => 1770971478.1975
            [time] => 0.00025606155395508
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.1975
            [end] => 1770971478.1996
            [time] => 0.0021109580993652
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.1998
            [end] => 1770971478.2119
            [time] => 0.012098073959351
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.2122
            [end] => 1770971478.2145
            [time] => 0.0022950172424316
        )

    [5] => 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' ORDER BY lastname,firstname ASC
            [start] => 1770971478.2147
            [end] => 1770971478.2211
            [time] => 0.0063469409942627
        )

    [6] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1770971478.2245
            [end] => 1770971478.2251
            [time] => 0.00053215026855469
        )

    [7] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1770971478.2255
            [end] => 1770971478.2258
            [time] => 0.00029206275939941
        )

    [8] => Array
        (
            [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
            [start] => 1770971478.2258
            [end] => 1770971478.2264
            [time] => 0.00060510635375977
        )

    [9] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.2269
            [end] => 1770971478.2271
            [time] => 0.0002138614654541
        )

    [10] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.2272
            [end] => 1770971478.2293
            [time] => 0.002126932144165
        )

    [11] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.2293
            [end] => 1770971478.2414
            [time] => 0.012102842330933
        )

    [12] => Array
        (
            [query] => select * from match_roster where match_id = '3573'
            [start] => 1770971478.2418
            [end] => 1770971478.249
            [time] => 0.0072340965270996
        )

    [13] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.2491
            [end] => 1770971478.2494
            [time] => 0.00031208992004395
        )

    [14] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.2495
            [end] => 1770971478.2515
            [time] => 0.0020499229431152
        )

    [15] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.2516
            [end] => 1770971478.2635
            [time] => 0.011934995651245
        )

    [16] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3573' and (point.point = 'P' or point.point = 'E')
            [start] => 1770971478.2657
            [end] => 1770971478.3321
            [time] => 0.066365003585815
        )

    [17] => Array
        (
            [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
            [start] => 1770971478.3322
            [end] => 1770971478.3326
            [time] => 0.00034594535827637
        )

    [18] => Array
        (
            [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
            [start] => 1770971478.3326
            [end] => 1770971478.3328
            [time] => 0.0002138614654541
        )

    [19] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.3329
            [end] => 1770971478.3331
            [time] => 0.00023794174194336
        )

    [20] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.3332
            [end] => 1770971478.3355
            [time] => 0.0023319721221924
        )

    [21] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.3356
            [end] => 1770971478.3478
            [time] => 0.012187957763672
        )

    [22] => Array
        (
            [query] => select * from match_roster where match_id = '3573'
            [start] => 1770971478.348
            [end] => 1770971478.3551
            [time] => 0.0070970058441162
        )

    [23] => 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 = '3573' group by player_id
        
            [start] => 1770971478.3552
            [end] => 1770971478.3974
            [time] => 0.042262077331543
        )

    [24] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3573'
            [start] => 1770971478.3976
            [end] => 1770971478.398
            [time] => 0.00041604042053223
        )

    [25] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.3981
            [end] => 1770971478.3983
            [time] => 0.00022101402282715
        )

    [26] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.3983
            [end] => 1770971478.4004
            [time] => 0.002061128616333
        )

    [27] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.4005
            [end] => 1770971478.4125
            [time] => 0.012055158615112
        )

    [28] => Array
        (
            [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
            [start] => 1770971478.4129
            [end] => 1770971478.4132
            [time] => 0.00031709671020508
        )

    [29] => Array
        (
            [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
            [start] => 1770971478.4133
            [end] => 1770971478.4139
            [time] => 0.00061893463134766
        )

    [30] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.4141
            [end] => 1770971478.4144
            [time] => 0.00026392936706543
        )

    [31] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.4144
            [end] => 1770971478.4164
            [time] => 0.0020430088043213
        )

    [32] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.4165
            [end] => 1770971478.4286
            [time] => 0.012151002883911
        )

    [33] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3573'
            [start] => 1770971478.4289
            [end] => 1770971478.4298
            [time] => 0.00087404251098633
        )

    [34] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1770971478.4299
            [end] => 1770971478.4301
            [time] => 0.00018882751464844
        )

    [35] => 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 = '3573' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1770971478.4301
            [end] => 1770971478.4303
            [time] => 0.00021481513977051
        )

    [36] => Array
        (
            [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
            [start] => 1770971478.4304
            [end] => 1770971478.4306
            [time] => 0.00017595291137695
        )

    [37] => Array
        (
            [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
            [start] => 1770971478.4306
            [end] => 1770971478.4308
            [time] => 0.00014686584472656
        )

    [38] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.4309
            [end] => 1770971478.4311
            [time] => 0.00021719932556152
        )

    [39] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.4312
            [end] => 1770971478.4332
            [time] => 0.0020420551300049
        )

    [40] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.4332
            [end] => 1770971478.4453
            [time] => 0.0120689868927
        )

    [41] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.4456
            [end] => 1770971478.4459
            [time] => 0.00025820732116699
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.4459
            [end] => 1770971478.4479
            [time] => 0.0020351409912109
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.448
            [end] => 1770971478.46
            [time] => 0.012004852294922
        )

    [44] => Array
        (
            [query] => select * from match_roster where match_id = '3573'
            [start] => 1770971478.4602
            [end] => 1770971478.4672
            [time] => 0.0069060325622559
        )

    [45] => Array
        (
            [query] => select * from point where match_id = '3573' order by point_id ASC
            [start] => 1770971478.4672
            [end] => 1770971478.5293
            [time] => 0.062072992324829
        )

    [46] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.5299
            [end] => 1770971478.5302
            [time] => 0.00033807754516602
        )

    [47] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.5302
            [end] => 1770971478.5323
            [time] => 0.0020811557769775
        )

    [48] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.5324
            [end] => 1770971478.5444
            [time] => 0.011993169784546
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3573'
            [start] => 1770971478.5452
            [end] => 1770971478.5455
            [time] => 0.00020408630371094
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3573'
            [start] => 1770971478.5455
            [end] => 1770971478.5475
            [time] => 0.0020401477813721
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3573'
            [start] => 1770971478.5476
            [end] => 1770971478.5597
            [time] => 0.012113094329834
        )

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

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

)