Thread:Extension talk:LiquidThreads/General Threads Overview/reply (2)

At least I found an SQL-Statement that can do that:

SELECT * FROM prefix_thread WHERE (thread_parent IS NULL OR thread_ancestor=thread_id) AND (thread_type<>2) ORDER BY thread_modified DESC