Tips: Query for searching multiple account of general users

Question

SELECT createip, writeip, created, handle FROM qa_users WHERE createip IN (SELECT createip FROM qa_users WHERE level < 20 GROUP BY createip HAVING count(*) > 1) OR writeip IN (SELECT writeip FROM qa_users WHERE level < 20 GROUP BY writeip HAVING count(*) > 1) AND level < 20 ORDER BY createip ASC, writeip ASC, created ASC, handle ASC;

Comments

The moderation in this site does not function definitely. Therefore, I think that there are some users (group) operating information illegally in this site. I want to know the result that carried out upper query in this site. By the way, result in my site (ASKIVE) is ZERO.