Optimized get query with index hint and LOOP JOIN. Added Guid for test code.