title: Help converting SQL nested sub-query to join query for mysql 4.0 compatibility
body: <p>I have a nested SQL query :</p>
  
  <pre><code>SELECT DISTINCT(topic_id)
  FROM bb_posts 
  WHERE topic_id NOT IN ( 
    SELECT topic_id FROM bb_posts 
    WHERE poster_id = $user_id AND post_status = 0 ) 
  ORDER BY post_time DESC
  </code></pre>
  
  <p>My webserver runs MySQL 4.0 which doesnt allow nested queries. Can some SQL guru suggest the same query using the JOIN lingo? i tried and tried and tried... but i can't figure this out. Feeling dumb.</p>