Finding originating account of anonymous posts

[Not-The-Foggiest]

sorry, it did not see this: Can staff be able to see real author of anonymous posts - #6 by Un3qual

and i did not notice that this even has a query in it:

Is anonymous posting possible?

You’re right – this query of yours will do that: SELECT users.username , user_custom_fields.value FROM users JOIN user_custom_fields ON users.id = user_custom_fields.user_id OR users.id = CAST( user_custom_fields.value AS int ) WHERE user_custom_fields.name LIKE 'shadow_id' ORDER BY user_custom_fields.value There is no obvious way through the UI though.

so i’m off to try this out.