Ques/Help query to find all users showing as "guest"

[jmmp]

What query do I have to run to get a list of all GUEST users? Like this:



I tried this but it didn't work:

SELECT * FROM xf_user WHERE user_id = 0;

This one didn't work either:

SELECT username FROM xf_user WHERE user_id = 0;

P.D.: To run on xf 2.1 and xf 1.5

Continue reading...