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

Referto Partita: Rising Titans vs Krakens Chivasso

Referto Partita: Rising Titans vs Krakens Chivasso

Rising Titans

Rising Titans

Krakens Chivasso

Krakens Chivasso

RISULTATO FINALE

78

68

1° Tempo

22

17

2° Tempo

25

23

3° Tempo

31

28

INVASIONI A MURO

0

0

Data e Luogo


Campionato Campionato Eccellenza 2021/2022 B2
Giornata: 10
Data e Luogo 12-03-2022 15:45 - Palazzeschi

Arbitri


Primo Arbitro Petrosino Alessio
Secondo Arbitro Da Re Francesca
Refertista Da Re Francesca

Sorteggio


Sorteggio Vinto Da Krakens Chivasso
Scelta Sorteggio Palla

Progresso

Punteggi Individuali

Rising Titans

  • Ivan Biletta
    Tot.

    9

    3
    x2
    1
    x3

    0
    x AUTOHIT
  • Vincenzo De Felice
    Tot.

    12

    6
    x2
    0
    x3

    0
    x AUTOHIT
  • Matteo Paccagnini
    Tot.

    17

    7
    x2
    1
    x3

    0
    x AUTOHIT
  • Andrea Giannitti
    Tot.

    10

    5
    x2
    0
    x3

    0
    x AUTOHIT
  • Andrea Vecchiattini
    Tot.

    28

    8
    x2
    4
    x3

    0
    x AUTOHIT
  • Sonnj Dall'ara
    Tot.

    2

    1
    x2
    0
    x3

    1
    x AUTOHIT

Krakens Chivasso

  • Emanuele Preti
    1
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    2

  • Davide Martini
    9
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    18

  • Emanuele Filiberto Pellegrin
    1
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    2

  • Andrea Merlo
    2
    x2
    3
    x3

    0
    x AUTOHIT
    Tot.

    13

  • Gianluca Parisi
    4
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    11

  • Francesco Ghio
    1
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    2

  • Alessio Argano
    8
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    19

                Total Queries: 55
        Total Time: 0.3477897644043
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1770966633.02
            [end] => 1770966633.0203
            [time] => 0.00030112266540527
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.0226
            [end] => 1770966633.0228
            [time] => 0.00022482872009277
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.0228
            [end] => 1770966633.0249
            [time] => 0.002047061920166
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.025
            [end] => 1770966633.0369
            [time] => 0.011975049972534
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.0372
            [end] => 1770966633.0394
            [time] => 0.0021240711212158
        )

    [5] => 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' ORDER BY lastname,firstname ASC
            [start] => 1770966633.0395
            [end] => 1770966633.046
            [time] => 0.0064380168914795
        )

    [6] => Array
        (
            [query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
            [start] => 1770966633.0497
            [end] => 1770966633.0501
            [time] => 0.00043010711669922
        )

    [7] => Array
        (
            [query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
            [start] => 1770966633.0505
            [end] => 1770966633.051
            [time] => 0.00046110153198242
        )

    [8] => Array
        (
            [query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
            [start] => 1770966633.051
            [end] => 1770966633.0516
            [time] => 0.00058388710021973
        )

    [9] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.0521
            [end] => 1770966633.0523
            [time] => 0.00020599365234375
        )

    [10] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.0523
            [end] => 1770966633.0544
            [time] => 0.0020451545715332
        )

    [11] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.0544
            [end] => 1770966633.0665
            [time] => 0.012056827545166
        )

    [12] => Array
        (
            [query] => select * from match_roster where match_id = '1988'
            [start] => 1770966633.0667
            [end] => 1770966633.0736
            [time] => 0.0068650245666504
        )

    [13] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.0737
            [end] => 1770966633.074
            [time] => 0.0002439022064209
        )

    [14] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.074
            [end] => 1770966633.076
            [time] => 0.0020160675048828
        )

    [15] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.0761
            [end] => 1770966633.088
            [time] => 0.011983871459961
        )

    [16] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '1988' and (point.point = 'P' or point.point = 'E')
            [start] => 1770966633.0902
            [end] => 1770966633.156
            [time] => 0.065834045410156
        )

    [17] => Array
        (
            [query] => select * from penalty where type = 'P' ORDER BY penalty_id ASC
            [start] => 1770966633.1561
            [end] => 1770966633.1565
            [time] => 0.00034308433532715
        )

    [18] => Array
        (
            [query] => select * from penalty where type = 'E' ORDER BY penalty_id ASC
            [start] => 1770966633.1565
            [end] => 1770966633.1567
            [time] => 0.00020790100097656
        )

    [19] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.1568
            [end] => 1770966633.1571
            [time] => 0.00024795532226562
        )

    [20] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.1571
            [end] => 1770966633.1592
            [time] => 0.0021469593048096
        )

    [21] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.1593
            [end] => 1770966633.1713
            [time] => 0.01200008392334
        )

    [22] => Array
        (
            [query] => select * from match_roster where match_id = '1988'
            [start] => 1770966633.1715
            [end] => 1770966633.1784
            [time] => 0.0068609714508057
        )

    [23] => 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 = '1988' group by player_id
        
            [start] => 1770966633.1784
            [end] => 1770966633.2203
            [time] => 0.041919946670532
        )

    [24] => Array
        (
            [query] => select * from penalty_to_team where match_id = '1988'
            [start] => 1770966633.2205
            [end] => 1770966633.2209
            [time] => 0.00039792060852051
        )

    [25] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.2209
            [end] => 1770966633.2211
            [time] => 0.00019407272338867
        )

    [26] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.2212
            [end] => 1770966633.2232
            [time] => 0.0020749568939209
        )

    [27] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.2233
            [end] => 1770966633.2353
            [time] => 0.011991024017334
        )

    [28] => Array
        (
            [query] => select * from team_penalty where deleted = '0' ORDER BY team_penalty_id ASC
            [start] => 1770966633.2357
            [end] => 1770966633.2359
            [time] => 0.00024199485778809
        )

    [29] => Array
        (
            [query] => select * from staff where deleted = '0' ORDER BY firstname,lastname ASC
            [start] => 1770966633.236
            [end] => 1770966633.2366
            [time] => 0.00056290626525879
        )

    [30] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.2368
            [end] => 1770966633.237
            [time] => 0.00022292137145996
        )

    [31] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.2371
            [end] => 1770966633.2391
            [time] => 0.0020549297332764
        )

    [32] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.2392
            [end] => 1770966633.2512
            [time] => 0.012017011642456
        )

    [33] => Array
        (
            [query] => select * from match_staff_roster where match_id = '1988'
            [start] => 1770966633.2514
            [end] => 1770966633.2522
            [time] => 0.00079822540283203
        )

    [34] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1770966633.2523
            [end] => 1770966633.2524
            [time] => 0.00017094612121582
        )

    [35] => 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 = '1988' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1770966633.2525
            [end] => 1770966633.2527
            [time] => 0.00020909309387207
        )

    [36] => Array
        (
            [query] => select * from staff_penalty where type = 'P' ORDER BY staff_penalty_id ASC
            [start] => 1770966633.2528
            [end] => 1770966633.253
            [time] => 0.00020003318786621
        )

    [37] => Array
        (
            [query] => select * from staff_penalty where type = 'E' ORDER BY staff_penalty_id ASC
            [start] => 1770966633.253
            [end] => 1770966633.2531
            [time] => 0.00012397766113281
        )

    [38] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.2533
            [end] => 1770966633.2534
            [time] => 0.00015711784362793
        )

    [39] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.2535
            [end] => 1770966633.2555
            [time] => 0.0020670890808105
        )

    [40] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.2556
            [end] => 1770966633.2675
            [time] => 0.011938095092773
        )

    [41] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.2678
            [end] => 1770966633.268
            [time] => 0.00022792816162109
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.268
            [end] => 1770966633.2701
            [time] => 0.0020320415496826
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.2701
            [end] => 1770966633.2821
            [time] => 0.011956930160522
        )

    [44] => Array
        (
            [query] => select * from match_roster where match_id = '1988'
            [start] => 1770966633.2823
            [end] => 1770966633.2891
            [time] => 0.0067901611328125
        )

    [45] => Array
        (
            [query] => select * from point where match_id = '1988' order by point_id ASC
            [start] => 1770966633.2891
            [end] => 1770966633.351
            [time] => 0.06194019317627
        )

    [46] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.3516
            [end] => 1770966633.3519
            [time] => 0.00034499168395996
        )

    [47] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.3519
            [end] => 1770966633.3541
            [time] => 0.0021090507507324
        )

    [48] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.3541
            [end] => 1770966633.3661
            [time] => 0.011992931365967
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '1988'
            [start] => 1770966633.3669
            [end] => 1770966633.3671
            [time] => 0.00020790100097656
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '1988'
            [start] => 1770966633.3671
            [end] => 1770966633.3691
            [time] => 0.002007007598877
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '1988'
            [start] => 1770966633.3691
            [end] => 1770966633.3813
            [time] => 0.012140989303589
        )

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

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

)