You might be able to get some of them but not all. A couple versions back we added the POST_POSTER_NAME field to the ubbt_POSTS table and this remains intact after a user is deleted. So you can get posts made after that, but not prior.

select POST_ID from ubbt_POSTS where POST_POSTER_NAME='deleteuser'

Just change deleteduser to the username in question.