[Panzer Max]

Oh, you're right, I forgot to include usergroupid:

SELECT U1.userid, U1.username, U1.usergroupid, S1.signature
FROM user AS U1, usertextfield AS S1
WHERE U1.userid = S1.userid
AND U1.joindate >1291165261
AND ( U1.lastactivity - U1.joindate ) < 86400
AND U1.posts < 2
AND S1. signature NOT LIKE ''
ORDER BY U1.username

Then I want to run an UPDATE query to change their usergroupid from 2 (the registered usergroup) to 99 (the spammer usergroup). And then I can go into the ACP>Users>Move and Prune and delete all members of that usergroup.

Yes, you would be surprised how many spam accounts there are, sitting with no posts but spam links in their sigs and homepages...and these are magnets for more spam. Afterall, if the spammers see you are a willing spam depository, they won't leave you off their list!