SELECT TOP(@NumberMessage)
  Message.MessageId
, Message.CreateDate
, Message.Body,Person.Name , Person.Surname,Utente.ID,MessageThread.MessageThreadId as MessageThreadID
, [User].Username,User.[Path] , Person.Image
, (SELECT MessageReadState.ReadDate
   FROM MessageReadState
   WHERE MessageReadState.MessageId = Message.MessageId
     and MessageReadState.UserId = @UserId) as ReadState
FROM (Message INNER JOIN [Utente] ON Message.SenderUserId = [Utente].ID
       INNER JOIN MessageThread ON MessageThread.MessageThreadId = Message.MessageThreadId
              INNER JOIN Person ON Person .ID = User.Id_person)
WHERE ([Message].MessageThreadId=@ThreadId)
ORDER BY Message.CreateDate DESC;
END