High I/O for part of query
If you don't already have one, create a composite nonclustered index on prism72ext.dbo.pb_WorkRequestLog(WorkRequestId, Id DESC) and run the query without the index hint. 

Also, have your inner select for the owner derived table return mwl.WorkRequestId instead of ml.WorkRequestId.