Thanks Gail for trying to help

I have sent you the quey plan, please let me know if you can see any issue or what is causing the high reads

one think I will test is to add an index on CRMOBJECTS(OLOCALEID), all other joins are done on clustered index

statistics are showing:

Table 'CRMOBJECTS'. Scan count 553, logical reads 1764, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

this is very far from the 250 000 pages generated by the query and captured by SQL Profiler

Best regards