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

Referto Partita: Sapore di Mara vs Smaronne

Referto Partita: Sapore di Mara vs Smaronne

Sapore di Mara

Sapore di Mara

Smaronne

Smaronne

RISULTATO FINALE

54

97

1° Tempo

19

32

2° Tempo

22

33

3° Tempo

13

32

INVASIONI A MURO

0

0

Data e Luogo


Campionato Torneo Femminile 2023
Giornata: 6
Data e Luogo 30-05-2023 20:45 - Frassati

Arbitri


Primo Arbitro Riccio Roberto
Secondo Arbitro Riccio Roberto
Refertista ASD Sinombre

Sorteggio


Sorteggio Vinto Da Sapore di Mara
Scelta Sorteggio Palla

Progresso

Punteggi Individuali

Sapore di Mara

  • Carola Casassa Vigna
    Tot.

    17

    7
    x2
    1
    x3

    1
    x AUTOHIT
  • Laura Mongi
    Tot.

    0

    0
    x2
    0
    x3

    0
    x AUTOHIT
  • Alessia Visintin
    Tot.

    18

    9
    x2
    0
    x3

    0
    x AUTOHIT
  • SIlvia Petiti
    Tot.

    6

    3
    x2
    0
    x3

    0
    x AUTOHIT
  • Mara Ferraris
    Tot.

    13

    5
    x2
    1
    x3

    0
    x AUTOHIT

Smaronne

  • Federica Nardacchione
    2
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    10

  • Julie Carpinelli
    6
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    12

  • Adina Catalina Ghimpu
    1
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    5

  • Patrizia Cascino
    11
    x2
    4
    x3

    0
    x AUTOHIT
    Tot.

    34

  • Martina Lupo
    2
    x2
    1
    x3

    0
    x AUTOHIT
    Tot.

    7

  • Cristina Vaudagna
    2
    x2
    2
    x3

    0
    x AUTOHIT
    Tot.

    10

  • Carlotta Amodeo
    9
    x2
    0
    x3

    0
    x AUTOHIT
    Tot.

    18

                Total Queries: 55
        Total Time: 1.851478099823
    Array
(
    [0] => Array
        (
            [query] => select * from setting where property = 'datetime_timezone'
            [start] => 1781164772.9262
            [end] => 1781164772.9269
            [time] => 0.00064611434936523
        )

    [1] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164772.9314
            [end] => 1781164772.9346
            [time] => 0.0031969547271729
        )

    [2] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164772.9346
            [end] => 1781164772.9485
            [time] => 0.013930082321167
        )

    [3] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164772.9487
            [end] => 1781164773.0219
            [time] => 0.07323694229126
        )

    [4] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164773.0222
            [end] => 1781164773.052
            [time] => 0.029773950576782
        )

    [5] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164773.0521
            [end] => 1781164773.0524
            [time] => 0.00025510787963867
        )

    [6] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164773.0524
            [end] => 1781164773.0598
            [time] => 0.0074300765991211
        )

    [7] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164773.0599
            [end] => 1781164773.1318
            [time] => 0.07191801071167
        )

    [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 (52,51) ORDER BY lastname,firstname ASC
            [start] => 1781164773.1323
            [end] => 1781164773.1377
            [time] => 0.0053999423980713
        )

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

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

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

    [12] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164773.161
            [end] => 1781164773.1629
            [time] => 0.0019221305847168
        )

    [13] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164773.1629
            [end] => 1781164773.1694
            [time] => 0.0064709186553955
        )

    [14] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164773.1695
            [end] => 1781164773.2412
            [time] => 0.071710824966431
        )

    [15] => Array
        (
            [query] => select * from match_roster where match_id = '2857'
            [start] => 1781164773.2415
            [end] => 1781164773.2818
            [time] => 0.040292024612427
        )

    [16] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164773.2819
            [end] => 1781164773.284
            [time] => 0.0020720958709717
        )

    [17] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164773.284
            [end] => 1781164773.2941
            [time] => 0.010079145431519
        )

    [18] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164773.2942
            [end] => 1781164773.3558
            [time] => 0.061599016189575
        )

    [19] => Array
        (
            [query] => select point.*, penalty.cumulative from point 
                inner join penalty on (point.penalty_id = penalty.penalty_id)
                where point.match_id = '2857' and (point.point = 'P' or point.point = 'E')
            [start] => 1781164773.3593
            [end] => 1781164773.7388
            [time] => 0.37948489189148
        )

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

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

    [22] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164773.7495
            [end] => 1781164773.7497
            [time] => 0.0002131462097168
        )

    [23] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164773.7497
            [end] => 1781164773.7581
            [time] => 0.0084309577941895
        )

    [24] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164773.7582
            [end] => 1781164773.8197
            [time] => 0.061477899551392
        )

    [25] => Array
        (
            [query] => select * from match_roster where match_id = '2857'
            [start] => 1781164773.82
            [end] => 1781164773.8682
            [time] => 0.048232078552246
        )

    [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 = '2857' group by player_id
        
            [start] => 1781164773.8683
            [end] => 1781164774.118
            [time] => 0.24969100952148
        )

    [27] => Array
        (
            [query] => select * from penalty_to_team where match_id = '2857'
            [start] => 1781164774.1181
            [end] => 1781164774.1194
            [time] => 0.0013020038604736
        )

    [28] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164774.1195
            [end] => 1781164774.1209
            [time] => 0.0014228820800781
        )

    [29] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164774.1209
            [end] => 1781164774.1309
            [time] => 0.0099899768829346
        )

    [30] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164774.131
            [end] => 1781164774.1947
            [time] => 0.06374716758728
        )

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

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

    [33] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164774.2079
            [end] => 1781164774.2097
            [time] => 0.0018148422241211
        )

    [34] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164774.2097
            [end] => 1781164774.2203
            [time] => 0.010571002960205
        )

    [35] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164774.2204
            [end] => 1781164774.2859
            [time] => 0.065523862838745
        )

    [36] => Array
        (
            [query] => select * from match_staff_roster where match_id = '2857'
            [start] => 1781164774.2861
            [end] => 1781164774.2878
            [time] => 0.0016400814056396
        )

    [37] => Array
        (
            [query] => select * from staff_penalty ORDER BY staff_penalty_id ASC
            [start] => 1781164774.2879
            [end] => 1781164774.2958
            [time] => 0.0079460144042969
        )

    [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 = '2857' and (penalty_to_staff.point = 'P' or penalty_to_staff.point = 'E')
            [start] => 1781164774.2959
            [end] => 1781164774.2962
            [time] => 0.00023388862609863
        )

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

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

    [41] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164774.2969
            [end] => 1781164774.2981
            [time] => 0.0012309551239014
        )

    [42] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164774.2981
            [end] => 1781164774.3074
            [time] => 0.0092730522155762
        )

    [43] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164774.3075
            [end] => 1781164774.3768
            [time] => 0.069359064102173
        )

    [44] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164774.3771
            [end] => 1781164774.3774
            [time] => 0.00029206275939941
        )

    [45] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164774.3775
            [end] => 1781164774.3879
            [time] => 0.010453939437866
        )

    [46] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164774.388
            [end] => 1781164774.4506
            [time] => 0.062623977661133
        )

    [47] => Array
        (
            [query] => select * from match_roster where match_id = '2857'
            [start] => 1781164774.4509
            [end] => 1781164774.4898
            [time] => 0.038888931274414
        )

    [48] => Array
        (
            [query] => select * from point where match_id = '2857' order by point_id ASC
            [start] => 1781164774.4898
            [end] => 1781164774.7607
            [time] => 0.27086997032166
        )

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

    [50] => Array
        (
            [query] => select * from matches where match_id = '2857'
            [start] => 1781164774.7641
            [end] => 1781164774.7644
            [time] => 0.00021910667419434
        )

    [51] => Array
        (
            [query] => select time,closed from match_time where match_id = '2857'
            [start] => 1781164774.7644
            [end] => 1781164774.7727
            [time] => 0.0083808898925781
        )

    [52] => Array
        (
            [query] => SELECT * FROM match_data where match_id = '2857'
            [start] => 1781164774.7728
            [end] => 1781164774.7934
            [time] => 0.020587921142578
        )

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

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

)