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

Referto Partita: Pazzeschi vs Sunknights

Referto Partita: Pazzeschi vs Sunknights

Pazzeschi

Pazzeschi

Sunknights

Sunknights

RISULTATO FINALE

127

134

1° Tempo

50

48

2° Tempo

33

27

3° Tempo

44

59

INVASIONI A MURO

0

2

Data e Luogo


Campionato Campionato Eccellenza 2023/2024 A1
Giornata: 14
Data e Luogo 07-03-2024 20:45 - Cavour

Arbitri


Primo Arbitro Spina Gabriele
Secondo Arbitro Mezzatesta Ilaria
Refertista ASD Polaris

Sorteggio


Sorteggio Vinto Da Pazzeschi
Scelta Sorteggio Campo

Annotazioni


Refertista: Capitolo Sabrina

Progresso

Punteggi Individuali

Pazzeschi

  • Marco Bernocco
    Tot.

    39

    9
    x2
    7
    x3

    0
    x AUTOHIT
  • Danilo Sacchetto
    Tot.

    2

    1
    x2
    0
    x3

    0
    x AUTOHIT
  • Sergio Fileccia
    Tot.

    16

    5
    x2
    2
    x3

    0
    x AUTOHIT
  • Luca Ambrosino
    Tot.

    24

    9
    x2
    2
    x3

    0
    x AUTOHIT
  • Antonio De Rosa
    Tot.

    30

    9
    x2
    4
    x3

    0
    x AUTOHIT
  • Luca Cangialosi
    Tot.

    16

    5
    x2
    2
    x3

    0
    x AUTOHIT

Sunknights

  • Alessandro Adami
    3
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    6

  • Alessio Casali
    0
    x2
    6
    x3

    0
    x AUTOHIT
    Tot.

    18

  • Maurizio Rattalino
    9
    x2
    8
    x3

    0
    x AUTOHIT
    Tot.

    42

    Divisa di gioco non regolamentare (Minuto: - 1T)
  • Enrico Spagnolini
    1
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    2

  • Mirko Violetto
    8
    x2
    15
    x3

    0
    x AUTOHIT
    Tot.

    61

  • Matteo Clara
    1
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    5

Sanzioni Disciplinari

Pazzeschi


Sunknights


  • 4. Maurizio Rattalino
    Divisa di gioco non regolamentare (Minuto: - 1T)
                Total Queries: 55
        Total Time: 1.3964734077454
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776066947.6833
            [end] => 1776066947.685
            [time] => 0.0016939640045166
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066947.6943
            [end] => 1776066947.6995
            [time] => 0.0052411556243896
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066947.6995
            [end] => 1776066947.7086
            [time] => 0.009070873260498
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066947.7087
            [end] => 1776066947.7742
            [time] => 0.065536022186279
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066947.7746
            [end] => 1776066947.7857
            [time] => 0.011150121688843
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066947.7859
            [end] => 1776066947.7899
            [time] => 0.0040428638458252
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066947.7899
            [end] => 1776066947.7969
            [time] => 0.0070219039916992
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066947.797
            [end] => 1776066947.8533
            [time] => 0.056241989135742
        )

    [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 (18,22) ORDER BY lastname,firstname ASC
            [start] => 1776066947.8536
            [end] => 1776066947.8548
            [time] => 0.0011999607086182
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066947.8709
            [end] => 1776066947.8727
            [time] => 0.0018389225006104
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066947.8728
            [end] => 1776066947.8827
            [time] => 0.0098979473114014
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066947.8828
            [end] => 1776066947.9157
            [time] => 0.032969951629639
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3036'
            [start] => 1776066947.9161
            [end] => 1776066947.9386
            [time] => 0.022501945495605
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066947.9387
            [end] => 1776066947.941
            [time] => 0.002338171005249
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066947.941
            [end] => 1776066947.9454
            [time] => 0.0043318271636963
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066947.9454
            [end] => 1776066947.9861
            [time] => 0.040671110153198
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3036' and (point.point = 'P' or point.point = 'E')
            [start] => 1776066947.9885
            [end] => 1776066948.2287
            [time] => 0.24029397964478
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066948.2318
            [end] => 1776066948.2329
            [time] => 0.0010612010955811
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066948.2329
            [end] => 1776066948.242
            [time] => 0.009087085723877
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066948.242
            [end] => 1776066948.2788
            [time] => 0.036794900894165
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3036'
            [start] => 1776066948.2791
            [end] => 1776066948.2998
            [time] => 0.020705938339233
        )

    [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 = '3036' group by player_id
        
            [start] => 1776066948.2999
            [end] => 1776066948.4907
            [time] => 0.19076490402222
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3036'
            [start] => 1776066948.4908
            [end] => 1776066948.503
            [time] => 0.012173891067505
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066948.5031
            [end] => 1776066948.5033
            [time] => 0.00021815299987793
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066948.5033
            [end] => 1776066948.5054
            [time] => 0.0021169185638428
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066948.5055
            [end] => 1776066948.5598
            [time] => 0.054270029067993
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066948.5651
            [end] => 1776066948.5657
            [time] => 0.00063586235046387
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066948.5658
            [end] => 1776066948.5741
            [time] => 0.0083720684051514
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066948.5742
            [end] => 1776066948.6211
            [time] => 0.046903848648071
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3036'
            [start] => 1776066948.6214
            [end] => 1776066948.6256
            [time] => 0.0041840076446533
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776066948.6257
            [end] => 1776066948.6329
            [time] => 0.0071990489959717
        )

    [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 = '3036' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776066948.6329
            [end] => 1776066948.6332
            [time] => 0.00024294853210449
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066948.6352
            [end] => 1776066948.6354
            [time] => 0.0002138614654541
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066948.6354
            [end] => 1776066948.6411
            [time] => 0.0056848526000977
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066948.6412
            [end] => 1776066948.6884
            [time] => 0.04724383354187
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066948.6888
            [end] => 1776066948.6949
            [time] => 0.006115198135376
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066948.695
            [end] => 1776066948.6977
            [time] => 0.0027551651000977
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066948.6978
            [end] => 1776066948.7524
            [time] => 0.054558992385864
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3036'
            [start] => 1776066948.7527
            [end] => 1776066948.7808
            [time] => 0.028179168701172
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3036' order by point_id ASC
            [start] => 1776066948.7809
            [end] => 1776066949.0413
            [time] => 0.26038694381714
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3036'
            [start] => 1776066949.0492
            [end] => 1776066949.0499
            [time] => 0.00067901611328125
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3036'
            [start] => 1776066949.0499
            [end] => 1776066949.0578
            [time] => 0.0078141689300537
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3036'
            [start] => 1776066949.0578
            [end] => 1776066949.0963
            [time] => 0.038455963134766
        )

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

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

)