Třídová akce

Kód:

3

Tělo:

SELECT {FIELDS}
FROM (
  SELECT 
    A.*,
    PLV.ValidFromDate$DATE,
    MAX(PLV.ValidFromDate$DATE) OVER(PARTITION BY A.StoreCard_ID) AS MAXValidFromDate$DATE
  FROM StorePrices A
  LEFT JOIN PriceListValidities PLV ON A.PriceListValidity_ID = PLV.ID
  WHERE 
    A.PriceList_ID = :PriceList_ID and COALESCE(PLV.ValidFromDate$DATE, 0.0) <= :PriceListValidityDate
) A
LEFT JOIN StoreCards B ON A.StoreCard_ID = B.ID
WHERE
  (A.MAXValidFromDate$DATE IS NULL OR (A.MAXValidFromDate$DATE = A.ValidFromDate$DATE)) AND 
  A.DeletedFromPriceList = 'N'

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