select * from transactionDetails WHERE OrderID in (400376, 400379) AND ((TransactionDate <> ProcessingDate AND TransactionId in (2,3,9,14,15) OR (TransactionDate = ProcessingDate AND TransactionId in (2,3,9)))