SELECT DISTINCT O2.ID
FROM ORDITEMSTATE O1,
 FULFILDOC F, ORD O2
WHERE
 (O1.FFDOCTYPE = 'A')
 AND (O1.STATECODE IN ('0','1'))
 AND (F.NUM = O1.FFDOCNUM)
 AND (F.INPDATE >= :D1)
 AND (F.INPDATE <= :D2)
 AND (O2.NUM = O1.ORDNUM)
 UNION
SELECT DISTINCT O2.ID
FROM ORDITEMSTATE O1,
 FULFILDOC F, ORD O2
WHERE
(O1.FFDOCTYPE IN ('L','R'))
 AND (F.NUM = O1.FFDOCNUM)
 AND (F.INPDATE >= :D1)
 AND (F.INPDATE <= :D2)
 AND (O2.NUM = O1.ORDNUM)

PLAN SORT (JOIN (F NATURAL,O1 INDEX (XIF217ORDITEMSTATE,XIF150ORDITEMSTATE),O2 INDEX (RDB$PRIMARY56)))
PLAN SORT (JOIN (O2 NATURAL,O1 INDEX (XPKORDITEMSTATE,XIF217ORDITEMSTATE,RDB$FOREIGN173,XIF217ORDITEMSTATE,RDB$FOREIGN173),F INDEX (RDB$PRIMARY46)))