Třídová akce

Kód:

4

Tělo:

SELECT ID FROM MLBExcludedPeriods A
WHERE 
 A.ID <> :ID AND
 A.TRMCar_ID = :TRMCar_ID AND
 (
 (:DateFrom <  A.DateFrom$DATE AND (A.DateTo$DATE <= :DateTo AND A.DateTo$DATE<>0)) OR
 (:DateTo   >= A.DateFrom$DATE AND A.DateTo$DATE=0) OR
 (:DateFrom >= A.DateFrom$DATE AND :DateFrom <= A.DateTo$DATE) OR
 (:DateTo   >= A.DateFrom$DATE AND :DateTo <= A.DateTo$DATE)
 )
ORDER BY A.DateFrom$DATE

Generated by ABRA Software a.s. 27.10.2021 16:35:26