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

Referto Partita: Sporting Team vs Evolution

Referto Partita: Sporting Team vs Evolution

Sporting Team

Sporting Team

Evolution

Evolution

RISULTATO FINALE

124

137

1° Tempo

35

30

2° Tempo

38

48

3° Tempo

51

59

INVASIONI A MURO

0

0

Data e Luogo


Campionato Campionato Eccellenza 2022/2023 A1
Giornata: 5
Data e Luogo 04-12-2022 18:50 - Enaip

Arbitri


Primo Arbitro Spina Gabriele
Secondo Arbitro Petrosino Alessio
Refertista Bracesco Martina

Sorteggio


Sorteggio Vinto Da Evolution
Scelta Sorteggio Palla

Progresso

Punteggi Individuali

Sporting Team

  • Franco Giambanco
    Tot.

    6

    3
    x2
    0
    x3

    0
    x AUTOHIT
    Comportamento scorretto o antisportivo (Minuto: 1 - 4T)
  • Francesco Bruno
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT
  • Alex Serratore
    Tot.

    2

    1
    x2
    0
    x3

    0
    x AUTOHIT
    Divisa di gioco non regolamentare (Minuto: - 1T)
  • Ilaria Mezzatesta
    Tot.

    2

    1
    x2
    0
    x3

    0
    x AUTOHIT
  • Federico Garrone
    Tot.

    74

    13
    x2
    16
    x3

    0
    x AUTOHIT
  • Gaetano Dinatale
    Tot.

    9

    3
    x2
    1
    x3

    0
    x AUTOHIT
    Divisa di gioco non regolamentare (Minuto: - 1T)
  • Riccardo Pajno Ferrara
    Tot.

    31

    5
    x2
    7
    x3

    0
    x AUTOHIT

Evolution

  • Gaspare Guarrato
    3
    x2
    7
    x3

    0
    x AUTOHIT
    Tot.

    27

  • Antonio Mirco Santarsia
    4
    x2
    3
    x3

    0
    x AUTOHIT
    Tot.

    17

  • Davide Brunello
    3
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    6

  • Giulio Naggi
    8
    x2
    4
    x3

    0
    x AUTOHIT
    Tot.

    28

  • Raffaele Maurelli
    6
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    15

  • Amedeo Biglino
    10
    x2
    7
    x3

    0
    x AUTOHIT
    Tot.

    41

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

    0
    x AUTOHIT
    Tot.

    3

Sanzioni Disciplinari

Sporting Team


  • 0. Franco Giambanco
    Comportamento scorretto o antisportivo (Minuto: 1 - 4T)
  • 13. Alex Serratore
    Divisa di gioco non regolamentare (Minuto: - 1T)
  • 10. Gaetano Dinatale
    Divisa di gioco non regolamentare (Minuto: - 1T)

Evolution


  • 10. Amedeo Biglino
    Divisa di gioco non regolamentare (Minuto: - 1T)
                Total Queries: 55
        Total Time: 1.4482636451721
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776062562.8483
            [end] => 1776062562.8485
            [time] => 0.00028610229492188
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062562.8518
            [end] => 1776062562.8521
            [time] => 0.0003359317779541
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062562.8522
            [end] => 1776062562.8593
            [time] => 0.0071220397949219
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062562.8594
            [end] => 1776062562.8956
            [time] => 0.036219120025635
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062562.896
            [end] => 1776062562.903
            [time] => 0.0069370269775391
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062562.9031
            [end] => 1776062562.9033
            [time] => 0.00022983551025391
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062562.9033
            [end] => 1776062562.9118
            [time] => 0.0084459781646729
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062562.9119
            [end] => 1776062562.9453
            [time] => 0.033473014831543
        )

    [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 (35,16) ORDER BY lastname,firstname ASC
            [start] => 1776062562.9457
            [end] => 1776062562.9471
            [time] => 0.0014300346374512
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062562.9532
            [end] => 1776062562.9534
            [time] => 0.00021505355834961
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062562.9534
            [end] => 1776062562.9595
            [time] => 0.0061089992523193
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062562.9596
            [end] => 1776062562.9999
            [time] => 0.040336132049561
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '2300'
            [start] => 1776062563.0002
            [end] => 1776062563.0254
            [time] => 0.025231122970581
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062563.0256
            [end] => 1776062563.0258
            [time] => 0.00026798248291016
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062563.0259
            [end] => 1776062563.0338
            [time] => 0.0079720020294189
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062563.0339
            [end] => 1776062563.1037
            [time] => 0.069841861724854
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '2300' and (point.point = 'P' or point.point = 'E')
            [start] => 1776062563.1079
            [end] => 1776062563.4351
            [time] => 0.32722187042236
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062563.4377
            [end] => 1776062563.4379
            [time] => 0.0002138614654541
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062563.4379
            [end] => 1776062563.446
            [time] => 0.0080981254577637
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062563.4461
            [end] => 1776062563.5134
            [time] => 0.067314147949219
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '2300'
            [start] => 1776062563.5137
            [end] => 1776062563.544
            [time] => 0.030340909957886
        )

    [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 = '2300' group by player_id
        
            [start] => 1776062563.5441
            [end] => 1776062563.6771
            [time] => 0.1330680847168
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '2300'
            [start] => 1776062563.6773
            [end] => 1776062563.6776
            [time] => 0.00029778480529785
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062563.6777
            [end] => 1776062563.6808
            [time] => 0.0030951499938965
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062563.6808
            [end] => 1776062563.6832
            [time] => 0.0024468898773193
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062563.6833
            [end] => 1776062563.7054
            [time] => 0.022113084793091
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062563.7091
            [end] => 1776062563.7093
            [time] => 0.0002129077911377
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062563.7094
            [end] => 1776062563.7114
            [time] => 0.0020828247070312
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062563.7115
            [end] => 1776062563.7506
            [time] => 0.039113998413086
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '2300'
            [start] => 1776062563.7509
            [end] => 1776062563.7517
            [time] => 0.00081205368041992
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776062563.7518
            [end] => 1776062563.7539
            [time] => 0.0020840167999268
        )

    [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 = '2300' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776062563.7539
            [end] => 1776062563.7569
            [time] => 0.003040075302124
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062563.7579
            [end] => 1776062563.7582
            [time] => 0.00024294853210449
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062563.7582
            [end] => 1776062563.7627
            [time] => 0.0044698715209961
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062563.7627
            [end] => 1776062563.8161
            [time] => 0.053404092788696
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062563.8164
            [end] => 1776062563.8229
            [time] => 0.0065350532531738
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062563.823
            [end] => 1776062563.8279
            [time] => 0.0049331188201904
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062563.828
            [end] => 1776062563.8912
            [time] => 0.063187837600708
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '2300'
            [start] => 1776062563.8914
            [end] => 1776062563.9076
            [time] => 0.016129016876221
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '2300' order by point_id ASC
            [start] => 1776062563.9076
            [end] => 1776062564.2187
            [time] => 0.31112003326416
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '2300'
            [start] => 1776062564.2312
            [end] => 1776062564.2329
            [time] => 0.0017538070678711
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '2300'
            [start] => 1776062564.2329
            [end] => 1776062564.2428
            [time] => 0.0098659992218018
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2300'
            [start] => 1776062564.2429
            [end] => 1776062564.3074
            [time] => 0.064553022384644
        )

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

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

)