You might want to add an additional where on the 'discussion_state' column. At the moment you're displaying all threads, regardless of their state. State can be one of visible, moderated or deleted.
Also, 'discussion_open' for open/close status.
There may also be other thread states which you...