When you modify your Query, on the "General" page, there will be a tick box called: "Include soft deleted records". If you tick this then you will be able to see everything that has been softdeleted on that Object.
Thanks for that Jenny, do you know if there is a way to edit deleted objects using the bulk action editor? It says deleted objects cannot be modified. If not no problem as it will be rare that it's needed but it's more helpful to do it using the bulk-action or opening the object and saving than to use SQL.