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

Referto Partita: Atletico Boomers vs Explichit

Referto Partita: Atletico Boomers vs Explichit

Atletico Boomers

Atletico Boomers

Explichit

Explichit

RISULTATO FINALE

91

100

1° Tempo

20

27

2° Tempo

30

44

3° Tempo

41

29

INVASIONI A MURO

0

0

Data e Luogo


Evento Playout 2024
Data e Luogo 29-05-2024 20:50 - Frassati

Arbitri


Primo Arbitro Naggi Giulio
Secondo Arbitro Tombolato Barbara
Refertista ASD Sinombre

Sorteggio


Sorteggio Vinto Da Atletico Boomers
Scelta Sorteggio Palla

Annotazioni


Refertista:Marco Antonucci

Progresso

Punteggi Individuali

Atletico Boomers

  • Mattia Valetti
    Tot.

    13

    2
    x2
    3
    x3

    0
    x AUTOHIT
  • Gianluca Martinelli
    Tot.

    16

    2
    x2
    4
    x3

    0
    x AUTOHIT
  • Lorenzo Lamberti
    Tot.

    7

    2
    x2
    1
    x3

    0
    x AUTOHIT
  • Stefano Incorvaia
    Tot.

    18

    3
    x2
    4
    x3

    0
    x AUTOHIT
  • Davide Fioretti
    Tot.

    3

    0
    x2
    1
    x3

    0
    x AUTOHIT
  • Federico D'Urzo
    Tot.

    24

    3
    x2
    6
    x3

    0
    x AUTOHIT
  • Roberto Pirrotta
    Tot.

    9

    0
    x2
    3
    x3

    0
    x AUTOHIT

Explichit

  • Lisa Portarulo
    6
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    15

  • Stefano Zorzan
    3
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    6

  • Samuel Maselli
    5
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    16

  • Claudio Bonocore
    4
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    14

  • Gabriele Maselli
    7
    x2
    4
    x3

    1
    x AUTOHIT
    Tot.

    26

    Divisa di gioco non regolamentare (Minuto: - 1T)
  • Mattia Allemano
    7
    x2
    3
    x3

    0
    x AUTOHIT
    Tot.

    23

Sanzioni Disciplinari

Atletico Boomers


Explichit


  • 80. Gabriele Maselli
    Divisa di gioco non regolamentare (Minuto: - 1T)
                Total Queries: 55
        Total Time: 0.35157823562622
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1776062082.9913
            [end] => 1776062082.9915
            [time] => 0.00022292137145996
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062082.9938
            [end] => 1776062082.994
            [time] => 0.00023889541625977
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062082.994
            [end] => 1776062082.9962
            [time] => 0.0021281242370605
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062082.9963
            [end] => 1776062083.0085
            [time] => 0.012192010879517
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.0089
            [end] => 1776062083.0111
            [time] => 0.0022261142730713
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.0112
            [end] => 1776062083.0114
            [time] => 0.00022482872009277
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.0115
            [end] => 1776062083.0138
            [time] => 0.0023601055145264
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.0139
            [end] => 1776062083.026
            [time] => 0.012142896652222
        )

    [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 (46,43) ORDER BY lastname,firstname ASC
            [start] => 1776062083.0265
            [end] => 1776062083.0276
            [time] => 0.0010740756988525
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.0317
            [end] => 1776062083.032
            [time] => 0.00027990341186523
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.032
            [end] => 1776062083.0341
            [time] => 0.0020880699157715
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.0342
            [end] => 1776062083.0462
            [time] => 0.012059926986694
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '3362'
            [start] => 1776062083.0465
            [end] => 1776062083.0536
            [time] => 0.0070219039916992
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.0537
            [end] => 1776062083.054
            [time] => 0.00025415420532227
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.054
            [end] => 1776062083.0561
            [time] => 0.0021278858184814
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.0562
            [end] => 1776062083.0683
            [time] => 0.012115955352783
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '3362' and (point.point = 'P' or point.point = 'E')
            [start] => 1776062083.0705
            [end] => 1776062083.1368
            [time] => 0.066392183303833
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.1377
            [end] => 1776062083.1379
            [time] => 0.00023698806762695
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.1379
            [end] => 1776062083.14
            [time] => 0.00211501121521
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.1401
            [end] => 1776062083.1522
            [time] => 0.012143850326538
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '3362'
            [start] => 1776062083.1525
            [end] => 1776062083.1594
            [time] => 0.0068809986114502
        )

    [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 = '3362' group by player_id
        
            [start] => 1776062083.1594
            [end] => 1776062083.2037
            [time] => 0.044293880462646
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '3362'
            [start] => 1776062083.2039
            [end] => 1776062083.2042
            [time] => 0.00035595893859863
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.2043
            [end] => 1776062083.2045
            [time] => 0.00020599365234375
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.2045
            [end] => 1776062083.2066
            [time] => 0.0020580291748047
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.2066
            [end] => 1776062083.2203
            [time] => 0.013707160949707
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.2219
            [end] => 1776062083.2222
            [time] => 0.00025486946105957
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.2222
            [end] => 1776062083.2243
            [time] => 0.0021271705627441
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.2244
            [end] => 1776062083.2365
            [time] => 0.012113094329834
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '3362'
            [start] => 1776062083.2368
            [end] => 1776062083.2376
            [time] => 0.00084280967712402
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1776062083.2378
            [end] => 1776062083.238
            [time] => 0.00019311904907227
        )

    [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 = '3362' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1776062083.238
            [end] => 1776062083.2382
            [time] => 0.00024604797363281
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.239
            [end] => 1776062083.2392
            [time] => 0.00023198127746582
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.2392
            [end] => 1776062083.2414
            [time] => 0.0021238327026367
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.2414
            [end] => 1776062083.2536
            [time] => 0.012144088745117
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.254
            [end] => 1776062083.2542
            [time] => 0.00025200843811035
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.2543
            [end] => 1776062083.2564
            [time] => 0.0020968914031982
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.2564
            [end] => 1776062083.2705
            [time] => 0.014065027236938
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '3362'
            [start] => 1776062083.2708
            [end] => 1776062083.2777
            [time] => 0.0069429874420166
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '3362' order by point_id ASC
            [start] => 1776062083.2778
            [end] => 1776062083.3399
            [time] => 0.062161922454834
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '3362'
            [start] => 1776062083.341
            [end] => 1776062083.3412
            [time] => 0.0001990795135498
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '3362'
            [start] => 1776062083.3412
            [end] => 1776062083.3433
            [time] => 0.0020489692687988
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '3362'
            [start] => 1776062083.3433
            [end] => 1776062083.3555
            [time] => 0.0121910572052
        )

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

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

)