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

Referto Partita: Krakens Chivasso vs Hocheti Pokety

Referto Partita: Krakens Chivasso vs Hocheti Pokety

Krakens Chivasso

Krakens Chivasso

Hocheti Pokety

Hocheti Pokety

RISULTATO FINALE

62

97

1° Tempo

18

39

2° Tempo

21

37

3° Tempo

23

21

INVASIONI A MURO

0

0

Data e Luogo


Campionato Campionato Eccellenza 2021/2022 B2
Giornata: 14
Data e Luogo 23-04-2022 19:30 - Palazzeschi

Arbitri


Primo Arbitro Spina Gabriele
Secondo Arbitro Da Re Francesca
Refertista Da Re Francesca

Sorteggio


Sorteggio Vinto Da Hocheti Pokety
Scelta Sorteggio Palla

Progresso

Punteggi Individuali

Krakens Chivasso

  • Davide Martini
    Tot.

    17

    7
    x2
    1
    x3

    0
    x AUTOHIT
  • Andrea Merlo
    Tot.

    21

    9
    x2
    1
    x3

    0
    x AUTOHIT
  • Gianluca Parisi
    Tot.

    12

    6
    x2
    0
    x3

    0
    x AUTOHIT
  • Alessio Argano
    Tot.

    12

    6
    x2
    0
    x3

    0
    x AUTOHIT

Hocheti Pokety

  • Simone Poser
    3
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    6

  • Edoardo Francesco Stefanelli
    7
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    20

  • Ramon Rutigliano
    9
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    18

  • Thomas Rovetto
    0
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    0

  • Simone De Meo
    10
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    26

  • Alberto Racco
    12
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    27

Sanzioni di Squadra

Krakens Chivasso


  • Formazione Incompleta

Hocheti Pokety


  • Nessuna penalità di squadra.
                Total Queries: 55
        Total Time: 1.4544670581818
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776062563.5658
            [end] => 1776062563.5679
            [time] => 0.0020749568939209
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062563.5732
            [end] => 1776062563.5735
            [time] => 0.00028395652770996
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062563.5735
            [end] => 1776062563.5852
            [time] => 0.011701107025146
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062563.5853
            [end] => 1776062563.639
            [time] => 0.053702116012573
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062563.6393
            [end] => 1776062563.6493
            [time] => 0.01001501083374
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062563.6495
            [end] => 1776062563.658
            [time] => 0.0085041522979736
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062563.658
            [end] => 1776062563.6678
            [time] => 0.0098350048065186
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062563.6679
            [end] => 1776062563.7207
            [time] => 0.052819013595581
        )

    [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 (9,6) ORDER BY lastname,firstname ASC
            [start] => 1776062563.7211
            [end] => 1776062563.726
            [time] => 0.0048458576202393
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062563.7378
            [end] => 1776062563.7397
            [time] => 0.0019569396972656
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062563.7398
            [end] => 1776062563.746
            [time] => 0.006295919418335
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062563.7461
            [end] => 1776062563.8029
            [time] => 0.056772947311401
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '1980'
            [start] => 1776062563.8031
            [end] => 1776062563.827
            [time] => 0.023935794830322
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062563.8272
            [end] => 1776062563.8338
            [time] => 0.0066001415252686
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062563.8338
            [end] => 1776062563.8423
            [time] => 0.0085110664367676
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062563.8424
            [end] => 1776062563.8974
            [time] => 0.05501914024353
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '1980' and (point.point = 'P' or point.point = 'E')
            [start] => 1776062563.8995
            [end] => 1776062564.2496
            [time] => 0.35009813308716
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062564.254
            [end] => 1776062564.2543
            [time] => 0.00021600723266602
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062564.2543
            [end] => 1776062564.2614
            [time] => 0.0071280002593994
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062564.2615
            [end] => 1776062564.2964
            [time] => 0.034898042678833
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '1980'
            [start] => 1776062564.2966
            [end] => 1776062564.335
            [time] => 0.03836989402771
        )

    [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 = '1980' group by player_id
        
            [start] => 1776062564.335
            [end] => 1776062564.4656
            [time] => 0.13057088851929
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '1980'
            [start] => 1776062564.4658
            [end] => 1776062564.4661
            [time] => 0.00029611587524414
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062564.4661
            [end] => 1776062564.4679
            [time] => 0.0017352104187012
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062564.4679
            [end] => 1776062564.4735
            [time] => 0.0056281089782715
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062564.4736
            [end] => 1776062564.5226
            [time] => 0.049030065536499
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062564.5299
            [end] => 1776062564.5302
            [time] => 0.00023579597473145
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062564.5302
            [end] => 1776062564.5383
            [time] => 0.0080969333648682
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062564.5383
            [end] => 1776062564.5899
            [time] => 0.051562070846558
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '1980'
            [start] => 1776062564.5902
            [end] => 1776062564.595
            [time] => 0.0048379898071289
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776062564.5951
            [end] => 1776062564.5953
            [time] => 0.00019478797912598
        )

    [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 = '1980' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776062564.5953
            [end] => 1776062564.5956
            [time] => 0.00023698806762695
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062564.5973
            [end] => 1776062564.5975
            [time] => 0.0002140998840332
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062564.5975
            [end] => 1776062564.6045
            [time] => 0.0069851875305176
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062564.6046
            [end] => 1776062564.6542
            [time] => 0.049647092819214
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062564.6546
            [end] => 1776062564.658
            [time] => 0.0034899711608887
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062564.6581
            [end] => 1776062564.6615
            [time] => 0.0034439563751221
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062564.6616
            [end] => 1776062564.7318
            [time] => 0.070152044296265
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '1980'
            [start] => 1776062564.7322
            [end] => 1776062564.7729
            [time] => 0.040654182434082
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '1980' order by point_id ASC
            [start] => 1776062564.7729
            [end] => 1776062565.0082
            [time] => 0.23520708084106
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '1980'
            [start] => 1776062565.0093
            [end] => 1776062565.0122
            [time] => 0.0029220581054688
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '1980'
            [start] => 1776062565.0122
            [end] => 1776062565.0166
            [time] => 0.0044188499450684
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1980'
            [start] => 1776062565.0167
            [end] => 1776062565.0356
            [time] => 0.0189368724823
        )

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

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

)