Share commonly used queries

Please share any vbulletin queries you use now and then or even every day with us.

This is to delete all visitor messages made by a user, where X is replace with the user's userid:

Code:

DELETE FROM visitormessage WHERE userid=X;