SELECT
A.ID
FROM
Reservations A
WHERE
(A.Store_ID = :Store_ID)
AND (A.StoreCard_ID = :StoreCard_ID)
AND (((A.DateTo$DATE = 0) AND (A.DateFrom$DATE <= :ActualDate))
OR ((A.DateTo$DATE >= :ActualDate) AND (A.DateFrom$DATE <= :ActualDate)))
AND (A.Revided_ID IS NULL)Generated by ABRA Software a.s. 27.10.2021 16:34:11