Třídová akce

Kód:

3

Tělo:

SELECT SPL2.ID 
FROM SupplierPriceLists2 SPL2
JOIN SupplierPriceLists SPL ON SPL.id = SPL2.parent_id
WHERE SPL2.storecard_id = :StoreCard_ID
  AND (SPL.ValidFromDate$DATE <= :ValidFromDate)
ORDER BY
  SPL2.purchaseprice,
  SPL2.ID
 

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