How do I search for all closed threads that I have on my forums?

[Gary King]

How do I search for all closed threads that I have on my forums? Sort of like the feature to find polls, for instance.

[Steve Machol]

There is no built-in function to do this. You could find the threadids of closed threads with this query:

SELECT threadid FROM thread WHERE open='0';