mysql query help

[.Vapor]

I would like to move users with zero posts into an "inactive" group. But my sql is bad to say the least....
What would i query to place zero posters into group "xxx"?

Thanks

[Tyrsson]

Uhm you dont need a query for that. Enable post count membergroups and create the group, set the post count

[Tyrsson]

The default is newbie I think if memory serves, dont delete that group.

[Illori]

The default is newbie I think if memory serves, dont delete that group.

it is impossible via the admin interface to delete that group

[Tyrsson]

Yea, which is why I posted *if memory serves*, been a minute since I checked