Třídová akce

Kód:

2

Tělo:

SELECT WI2.ID FROM WorkingInjuries2 WI2
join WorkingInjuries WI on WI.ID = WI2.Parent_ID
join WagePeriods WP on WP.ID = WI2.WagePeriod_ID    
where
  (WP.DateFrom$DATE >= :DateFrom) and 
  (WP.DateTo$DATE <= :DateTo) and
  (
    (:WR = '') or
    (WI.WorkingRelation_ID = :WR)
  ) and  
  (
    (:BaseTypeRegard = 'N') or
    (:BaseTypeRegard = 'A') and (WI.BaseType in ({BaseType}))
  )   

Generated by ABRA Software a.s. 27.10.2021 16:34:36