I have a number of such guest users and I would like to know what they are and how many in total so I can assign them to other accounts and manage all their messages. Assigning other accounts I know what is the query to do, but not HOW TO FIND THEM (a list of them), so I ask how to locate them with the correct query.
I have a user that shows as a "guest" he is not associated with any group. He was leftover from a import from IPB way back in the day. He later joined under a different name. All his post show but there is no account associated with him such as a user, banned, etc. He is just a "guest". Is there...
I know how to merge guest user with another one with the same nick correctly registered. But first I want to know the list of all those guest users and then merge them.