select * 
	,NrOfSerialTx = (SELECT COUNT(*) FROM serialtx s WHERE s.SNTxCounter = D.OutSerialTx OR s.SNTxCounter = D.InSerialTx)
	,NrOfPostSTTx = (SELECT COUNT(*) FROM PostST p WHERE p.cauditnumber = D.AuditNumber)
	from _as_iq_TransferDetails D 
	WHERE 
		D.CreatedOnDate >= DATEADD(d,-150,GETDATE()) AND
		((SELECT COUNT(*) FROM serialtx s WHERE s.SNTxCounter = D.OutSerialTx OR s.SNTxCounter = D.InSerialTx) <> 2
	OR (SELECT COUNT(*) FROM PostST p WHERE p.cauditnumber = D.AuditNumber) <> 2 )
	order by id desc