OK got it. You need to change two indexes.
1. Include orderhash and status in index IX_SessionID, like this:
CREATE NONCLUSTERED INDEX [IX_sessionid] ON [dbo].[orderha]
([sessionid] ASC, OrderHash ASC) INCLUDE (Status)
2. Include printref in index IX_suspect_status_rsn_shipopt, like this:
CREATE NONCLUSTERED INDEX [IX_suspect_status_rsn_shipopt] ON [dbo].[orderha]
([suspectorder] ASC,
[status] ASC,
[rsn] ASC,
[shipopt] ASC) INCLUDE (PrintRef)
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden