Josh Pett also created a list in 2003 that had many replies, with additional useful queries.
https://www.ubbdev.com/forums/ubbthreads.php/topics/258506/useful-mysql-queries-for-ubb-threads.htmlRick Baker also created a list shortly after. You can find that list by searching the UBBCentral forums here.
These lists are generally to perform a specific task.
Be warned: making manual changes to your DB can easily break things -- and if you dont have a backup, your changes can be broken without any way to revert them.