Live results

Verify informations

no score data yet
select 
  psc_scores_M4EEO24AF.stage_number
  ,psc_def_M4EEO24AF.sh_dvp
  ,psc_scores_M4EEO24AF.ipm_hf
  ,(
    select max(ipm_hf) 
    from psc_scores_M4EEO24AF MAXHFT 
    join psc_def_M4EEO24AF MAXHFTSHT on (MAXHFTSHT.sh_uid=MAXHFT.shtr) 
    where 
      MAXHFT.stage_number=psc_scores_M4EEO24AF.stage_number 
      and
      MAXHFTSHT.sh_dvp=psc_def_M4EEO24AF.sh_dvp
      and
      MAXHFTSHT.sh_dq<>1  
  ) as maxHF
  ,psc_scores_M4EEO24AF.*
  ,psc_def_M4EEO24AF.*
  ,typenonteamcategory.TypeNonTeamCategory
from psc_scores_M4EEO24AF
join psc_def_M4EEO24AF on (psc_def_M4EEO24AF.sh_uid=psc_scores_M4EEO24AF.shtr and `psc_def_M4EEO24AF`.sh_del=0 )
join match_shooters on (match_shooters.shoMatId=10 and match_shooters.shoCompId=psc_def_M4EEO24AF.sh_num)
left join typenonteamcategory on (typenonteamcategory.TypeNonTeamCategoryId=match_shooters.shoCategory)
where 
  sh_dq<>1
order by  psc_scores_M4EEO24AF.ipm_hf DESC, maxHF desc 
  
data generated: 29.3.2024 00:09:05 Europe/Prague (GMT +1), Cache TTL: 1m
This page is to show live results.

Extreme Euro Open 2024 / 2024-06-20 / Hodonice, CZE