BTW, I have 2 forums, same exact file structures, on 2 different servers. One it works fine using the above (first one). The second it kills the server. I checked with that server admin, and he said the following:
"it locks the table that the other queries are waiting on the table to unlock before they can show the board"
AND
"The problem with your query is you do not have a limit line to it so it takes a long time to send all that data back to the server. You should have a limit line to limit the number of rows returned since this query returns a lot of data"
What can I do to fix this?
