select sys.ID from sys$posdocumentsopened sys join posdocuments doc on doc.id=sys.id where ((sys.Opened = 'A') or (sys.IsPayChange = 'A')) and (doc.shop_id = :Shop_ID) and (doc.SellingStand_ID is not null) and (sys.ID like :SiteMask) ORDER BY doc.CreatedDate$DATE
Generated by ABRA Software a.s. 27.10.2021 16:34:30