Třídová akce

Kód:

16

Tělo:

SELECT R.ID,
  MIN(P.DateFrom$DATE) AS DateOfBegin$DATE,
  MAX(P.DateTo$DATE) AS DateOfEnd$DATE
 FROM WorkingRelations R
  LEFT JOIN WageListPartial L ON R.ID = L.WorkingRelation_ID
  LEFT JOIN WagePeriods P ON L.WagePeriod_ID = P.ID
 WHERE 
  P.DateTo$DATE <= :ValidTo AND
  P.DateFrom$DATE >= :ValidFrom AND
  (R.DateOfEnd$DATE = 0 OR P.DateFrom$DATE <= R.DateOfEnd$DATE) AND
  R.Hidden = 'N' AND
  L.XMLImported = 'N'
 GROUP BY R.ID

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