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

Referto Partita: Driphit vs Iron Lion Tyson

Referto Partita: Driphit vs Iron Lion Tyson

Driphit

Driphit

Iron Lion Tyson

Iron Lion Tyson

RISULTATO FINALE

52

101

1° Tempo

14

35

2° Tempo

21

29

3° Tempo

17

37

INVASIONI A MURO

1

1

Data e Luogo


Campionato Campionato Eccellenza 2025/2026 B1
Giornata: 2
Data e Luogo 31-10-2025 20:45 - Cavour

Arbitri


Primo Arbitro Botosso Daniele
Secondo Arbitro Soroceanu Nelo
Refertista ASD Polaris

Sorteggio


Sorteggio Vinto Da Driphit
Scelta Sorteggio Campo

Progresso

Punteggi Individuali

Driphit

  • Dante Accarini
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT
  • Simone Mazza
    Tot.

    8

    4
    x2
    0
    x3

    0
    x AUTOHIT
  • Alessandro Maggio
    Tot.

    2

    1
    x2
    0
    x3

    0
    x AUTOHIT
  • Flavio Caiano
    Tot.

    17

    7
    x2
    1
    x3

    0
    x AUTOHIT
  • Andrea Brossa
    Tot.

    12

    6
    x2
    0
    x3

    1
    x AUTOHIT
  • Simone Abbona
    Tot.

    13

    5
    x2
    1
    x3

    0
    x AUTOHIT
  • Mattia Maggio
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT

Iron Lion Tyson

  • Matteo Amideo
    6
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    15

  • John Gonzalo Robles Zavaleta
    7
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    17

  • Tommaso Faletti
    6
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    12

  • Edoardo Bruno
    5
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    16

  • Simone Marcarino
    9
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    21

  • Marco Rizzo
    6
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    12

  • Samuele Dogliani
    2
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    7

                Total Queries: 55
        Total Time: 1.1131472587585
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781155247.8452
            [end] => 1781155247.8506
            [time] => 0.0054061412811279
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155247.8562
            [end] => 1781155247.8569
            [time] => 0.00071501731872559
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155247.8569
            [end] => 1781155247.8612
            [time] => 0.0043258666992188
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155247.8613
            [end] => 1781155247.8888
            [time] => 0.027480125427246
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155247.8892
            [end] => 1781155247.8917
            [time] => 0.0024838447570801
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155247.8918
            [end] => 1781155247.8948
            [time] => 0.0029580593109131
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155247.8948
            [end] => 1781155247.8983
            [time] => 0.0035412311553955
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155247.8984
            [end] => 1781155247.9254
            [time] => 0.026978969573975
        )

    [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 (56,25) ORDER BY lastname,firstname ASC
            [start] => 1781155247.9259
            [end] => 1781155247.9299
            [time] => 0.0039980411529541
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155247.9374
            [end] => 1781155247.9379
            [time] => 0.00041699409484863
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155247.9379
            [end] => 1781155247.9507
            [time] => 0.012863159179688
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155247.9508
            [end] => 1781155247.9836
            [time] => 0.032793998718262
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '4231'
            [start] => 1781155247.9839
            [end] => 1781155248.0019
            [time] => 0.017976045608521
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155248.002
            [end] => 1781155248.0023
            [time] => 0.00022101402282715
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155248.0023
            [end] => 1781155248.0067
            [time] => 0.004392147064209
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155248.0068
            [end] => 1781155248.0317
            [time] => 0.024945974349976
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '4231' and (point.point = 'P' or point.point = 'E')
            [start] => 1781155248.0371
            [end] => 1781155248.2474
            [time] => 0.21033596992493
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155248.25
            [end] => 1781155248.2502
            [time] => 0.00022006034851074
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155248.2502
            [end] => 1781155248.2567
            [time] => 0.0064918994903564
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155248.2568
            [end] => 1781155248.2964
            [time] => 0.039578914642334
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '4231'
            [start] => 1781155248.2967
            [end] => 1781155248.3249
            [time] => 0.028197050094604
        )

    [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 = '4231' group by player_id
        
            [start] => 1781155248.3249
            [end] => 1781155248.4756
            [time] => 0.15066695213318
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '4231'
            [start] => 1781155248.4758
            [end] => 1781155248.4781
            [time] => 0.0022828578948975
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155248.4781
            [end] => 1781155248.4784
            [time] => 0.00021505355834961
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155248.4784
            [end] => 1781155248.4872
            [time] => 0.0088529586791992
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155248.4873
            [end] => 1781155248.5251
            [time] => 0.037752151489258
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155248.529
            [end] => 1781155248.5292
            [time] => 0.00022196769714355
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155248.5292
            [end] => 1781155248.5356
            [time] => 0.0064148902893066
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155248.5357
            [end] => 1781155248.5796
            [time] => 0.043882131576538
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '4231'
            [start] => 1781155248.5799
            [end] => 1781155248.583
            [time] => 0.0030779838562012
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1781155248.5831
            [end] => 1781155248.5834
            [time] => 0.00022196769714355
        )

    [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 = '4231' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1781155248.5834
            [end] => 1781155248.5836
            [time] => 0.00024795532226562
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155248.5861
            [end] => 1781155248.5863
            [time] => 0.00023603439331055
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155248.5863
            [end] => 1781155248.5928
            [time] => 0.006483793258667
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155248.5929
            [end] => 1781155248.6352
            [time] => 0.042300939559937
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155248.6356
            [end] => 1781155248.637
            [time] => 0.0014030933380127
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155248.637
            [end] => 1781155248.6436
            [time] => 0.0066449642181396
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155248.6437
            [end] => 1781155248.6803
            [time] => 0.036601066589355
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '4231'
            [start] => 1781155248.6806
            [end] => 1781155248.7057
            [time] => 0.025079011917114
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '4231' order by point_id ASC
            [start] => 1781155248.7057
            [end] => 1781155248.9225
            [time] => 0.21681690216064
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '4231'
            [start] => 1781155248.9282
            [end] => 1781155248.9303
            [time] => 0.0021281242370605
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '4231'
            [start] => 1781155248.9304
            [end] => 1781155248.9369
            [time] => 0.0065140724182129
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '4231'
            [start] => 1781155248.937
            [end] => 1781155248.9792
            [time] => 0.042213916778564
        )

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

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

)