Live results

Verify informations

Last scored record (D/T): 25.06.2022 18:35 (Di Schiena Mario, stage 4)
Number of score records: 19078
select 
  psc_scores_M4EEO22AF.stage_number
  ,psc_def_M4EEO22AF.sh_dvp
  ,psc_scores_M4EEO22AF.ipm_hf
  ,(
    select max(ipm_hf) 
    from psc_scores_M4EEO22AF MAXHFT 
    join psc_def_M4EEO22AF MAXHFTSHT on (MAXHFTSHT.sh_uid=MAXHFT.shtr) 
    where 
      MAXHFT.stage_number=psc_scores_M4EEO22AF.stage_number 
      and
      MAXHFTSHT.sh_dvp=psc_def_M4EEO22AF.sh_dvp
      and
      MAXHFTSHT.sh_dq<>1  
  ) as maxHF
  ,psc_scores_M4EEO22AF.*
  ,psc_def_M4EEO22AF.*
  ,typenonteamcategory.TypeNonTeamCategory
from psc_scores_M4EEO22AF
join psc_def_M4EEO22AF on (psc_def_M4EEO22AF.sh_uid=psc_scores_M4EEO22AF.shtr)
join match_shooters on (match_shooters.shoMatId=10 and match_shooters.shoCompId=psc_def_M4EEO22AF.sh_num)
left join typenonteamcategory on (typenonteamcategory.TypeNonTeamCategoryId=match_shooters.shoCategory)
where 
  sh_dq<>1
order by  psc_scores_M4EEO22AF.ipm_hf DESC, maxHF desc 
  
data generated: 17.8.2022 06:12:24 Europe/Prague (GMT +2), Cache TTL: 2m
This page is to show live results.

Extreme Euro Open 2022 / 2022-06-23 / Hodonice, CZE