XF 1.4 Assigning posts from a deleted user to a new user


Well-known member
Hi there,

I just acquired a community which had some issues with accounts being deleted. I'd like to reassign these posts to users who are now returning, but I'm not sure how to do this.

Here's an example of a post I want to reassign to a NEW user who is also named PaulaJedi.


Does anyone know of a query I can run to reassign these posts to her?