Generate list of users with warnings

[rh2004]

Ignore this I did it wrong

Generate list of users with warnings, just a normal text list

MySQL - I did a query:

SELECT `user`.`username`, `user`.`warnings`
FROM user
WHERE (`user`.`warnings` >0)

[sv1cec]

I think there is a Statistics-Warnings per User report in the AdminCP/Warning System menu, why do you want to do it with SQL and re-invent the wheel?

Rgds