SQL query to disable users with less than (x) posts

[rh2004]

Hi,

I want to disable (move users to banned group) who have less than (x) number of posts.

For example disable users with less than 50 posts. Can anyone tell me the SQL to run?

Thank you

[Marco van Herwaarden]

Why not use the AdminCP for this?

AdminCP -> USers -> Move.