While in mySQL - how would I do this query?

[kofoid]

THANKS!

does that pull all threads and their responses as a single query? Also, is there any way to get it to run exactly like "Find all threads started by XXX," so it shows all pictures, signatures, etc? If not, is there a setting in the admin control panel that will allow someone to see ALL posts based on user group? That way I could set only the admin group to be able to see threads started by x, instead of only the last 100