Originally Posted by bella-unit
Could it be that the topic ID is NOT the post ID for the very first entry?

yes, and my post says to change the SQL from ( i highlighted it in different color above):

t1.TOPIC_ID NOT IN ...

to

to t1. POST_ID NOT IN ...

there is both a TOPIC_ID and a POST_ID in a ubbt_TOPICS record.. they are two distinct things..

- from what you have above - just change to:

SQL Query
and t1.POST_ID NOT IN (440794,613732,613731,613729,464338,528073,440794,396215,379866,613475)

Scott's post (sql syntax) is correct, if you know the topic ids, but that value isn't easy to see and POST_ID suffices just the same and is stored in the ubbt_TOPICS table as the POST_ID of the 1st post in that topic wink