? SQL query to delete users awaiting moderation

[jdrakopo]

Does anyone have a proven query to delete users awaiting moderation ?
I *THINK* the right query is something this:

DELETE * FROM user
JOIN userfield ON user.userid = userfield.userid
WHERE user.usergroupid =4

... but I've not tried it and I really don't want to mess w/ orphan records or data quality.
Thanks in advance

[snakes1100]

Why dont you just use the prune option under "users" in the admincp, then select the right group & conditions.