you are mixing up TOPIC_ID and POST_ID

for example, the url to THIS topic has ../topics/238341/...

in it..

that doesn't mean it is the topic id.. it is really the POST_ID for Ruben's last post.. that i am replying to

so to exclude a specific topic, you really want to look @ the 1st post in the topic (#238240 - Tue Jul 27 2010 02:11 AM -- for this topic)

and change the query to t1.POST_ID NOT IN (bla, bleh, blah)...

the ubbt_TOPICS table stores the POST_ID of the 1st post in it, so bada bing... ca ching wink

2c