Hi @SmritiFotedar
It seems the problem comes from the join conditions.
I suppose that the problem is on folder id : all the others joins are "LEFT JOIN". Those "LEFT JOIN" should not be a problem, even if there is no datas related to the recipient.
Are you trying to open the recipient from a view ? (views are folder that show everything, with colored label in blue or light green in the tree). These could explain that you can see the recipient, but maybe the folder associated have been deleted and it's impossible to open details.
You can try to select the line of these recipient in the list, right click, "Actions >" > "Update selected line" and change the @folder-id value for a existing one ?
As usual, I can be wrong
Cedric