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

Referto Partita: Pazzeschi vs Evolution

Referto Partita: Pazzeschi vs Evolution

Pazzeschi

Pazzeschi

Evolution

Evolution

RISULTATO FINALE

79

96

1° Tempo

26

31

2° Tempo

18

35

3° Tempo

35

30

INVASIONI A MURO

0

0

Data e Luogo


Campionato Campionato Eccellenza 2023/2024 A1
Giornata: 3
Data e Luogo 21-11-2023 20:45 - Cavour

Arbitri


Primo Arbitro Riccio Roberto
Secondo Arbitro Pirozzolo Domenico
Refertista ASD Polaris

Sorteggio


Sorteggio Vinto Da Evolution
Scelta Sorteggio Campo

Annotazioni


Refertista: Capitolo Sabrina

Progresso

Punteggi Individuali

Pazzeschi

  • Marco Bernocco
    Tot.

    14

    7
    x2
    0
    x3

    0
    x AUTOHIT
  • Riccardo Del Boca
    Tot.

    2

    1
    x2
    0
    x3

    0
    x AUTOHIT
  • Giuseppe Mirra
    Tot.

    3

    0
    x2
    1
    x3

    0
    x AUTOHIT
  • Danilo Sacchetto
    Tot.

    4

    2
    x2
    0
    x3

    0
    x AUTOHIT
  • Sergio Fileccia
    Tot.

    10

    5
    x2
    0
    x3

    0
    x AUTOHIT
  • Luca Ambrosino
    Tot.

    16

    5
    x2
    2
    x3

    0
    x AUTOHIT
  • Antonio De Rosa
    Tot.

    21

    6
    x2
    3
    x3

    0
    x AUTOHIT
  • Luca Cangialosi
    Tot.

    9

    3
    x2
    1
    x3

    0
    x AUTOHIT

Evolution

  • Gaspare Guarrato
    4
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    8

  • Antonio Mirco Santarsia
    5
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    10

  • Davide Brunello
    7
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    14

  • Davide Giordano
    8
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    22

  • Giulio Naggi
    5
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    13

  • Raffaele Maurelli
    8
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    16

  • Amedeo Biglino
    5
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    13

                Total Queries: 55
        Total Time: 1.1832168102264
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776062153.7486
            [end] => 1776062153.7511
            [time] => 0.0025269985198975
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062153.7534
            [end] => 1776062153.7538
            [time] => 0.00032901763916016
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062153.7538
            [end] => 1776062153.7599
            [time] => 0.006134033203125
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062153.7601
            [end] => 1776062153.7973
            [time] => 0.037222862243652
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062153.7976
            [end] => 1776062153.8038
            [time] => 0.0061709880828857
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062153.8039
            [end] => 1776062153.8042
            [time] => 0.00027990341186523
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062153.8042
            [end] => 1776062153.8123
            [time] => 0.0081028938293457
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062153.8124
            [end] => 1776062153.8461
            [time] => 0.033725023269653
        )

    [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,16) ORDER BY lastname,firstname ASC
            [start] => 1776062153.8465
            [end] => 1776062153.8496
            [time] => 0.003122091293335
        )

    [9] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1776062153.8511
            [end] => 1776062153.8515
            [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] => 1776062153.8519
            [end] => 1776062153.8522
            [time] => 0.00030398368835449
        )

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062153.8535
            [end] => 1776062153.8544
            [time] => 0.00087094306945801
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062153.8544
            [end] => 1776062153.8565
            [time] => 0.002140998840332
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062153.8566
            [end] => 1776062153.8837
            [time] => 0.027091979980469
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '2981'
            [start] => 1776062153.8839
            [end] => 1776062153.9048
            [time] => 0.020847082138062
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062153.9049
            [end] => 1776062153.9098
            [time] => 0.0048420429229736
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062153.9098
            [end] => 1776062153.9148
            [time] => 0.0049769878387451
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062153.9149
            [end] => 1776062153.9559
            [time] => 0.041056871414185
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '2981' and (point.point = 'P' or point.point = 'E')
            [start] => 1776062153.9591
            [end] => 1776062154.1683
            [time] => 0.20915985107422
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062154.1697
            [end] => 1776062154.1701
            [time] => 0.00044393539428711
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062154.1701
            [end] => 1776062154.1763
            [time] => 0.0062110424041748
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062154.1764
            [end] => 1776062154.2146
            [time] => 0.038218021392822
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '2981'
            [start] => 1776062154.2149
            [end] => 1776062154.2328
            [time] => 0.017877817153931
        )

    [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 = '2981' group by player_id
        
            [start] => 1776062154.2328
            [end] => 1776062154.4008
            [time] => 0.16799306869507
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '2981'
            [start] => 1776062154.401
            [end] => 1776062154.406
            [time] => 0.005014181137085
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062154.406
            [end] => 1776062154.4063
            [time] => 0.00020408630371094
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062154.4063
            [end] => 1776062154.4123
            [time] => 0.006011962890625
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062154.4124
            [end] => 1776062154.4518
            [time] => 0.039421081542969
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062154.4565
            [end] => 1776062154.4567
            [time] => 0.00023007392883301
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062154.4568
            [end] => 1776062154.4622
            [time] => 0.005465030670166
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062154.4623
            [end] => 1776062154.5028
            [time] => 0.040471792221069
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '2981'
            [start] => 1776062154.503
            [end] => 1776062154.5137
            [time] => 0.010722875595093
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776062154.5138
            [end] => 1776062154.5179
            [time] => 0.0040690898895264
        )

    [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 = '2981' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776062154.5179
            [end] => 1776062154.5182
            [time] => 0.00025606155395508
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062154.5189
            [end] => 1776062154.5192
            [time] => 0.00034880638122559
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062154.5192
            [end] => 1776062154.5244
            [time] => 0.0051929950714111
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062154.5245
            [end] => 1776062154.5786
            [time] => 0.05411696434021
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062154.5789
            [end] => 1776062154.5827
            [time] => 0.0037920475006104
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062154.5828
            [end] => 1776062154.591
            [time] => 0.008220911026001
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062154.5911
            [end] => 1776062154.6422
            [time] => 0.051120042800903
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '2981'
            [start] => 1776062154.6424
            [end] => 1776062154.6689
            [time] => 0.026459932327271
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '2981' order by point_id ASC
            [start] => 1776062154.6689
            [end] => 1776062154.8801
            [time] => 0.21119403839111
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '2981'
            [start] => 1776062154.8816
            [end] => 1776062154.8847
            [time] => 0.0031659603118896
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '2981'
            [start] => 1776062154.8848
            [end] => 1776062154.8903
            [time] => 0.0055429935455322
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2981'
            [start] => 1776062154.8904
            [end] => 1776062154.9363
            [time] => 0.045912981033325
        )

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

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

)