sql query recursive exclude forums

[kh99]

The 'childlist' column of the forum table is a comma-separated list of all the children (and the children's children, etc) of a forum (The list includes the forum itself and -1, for some reason - maybe to mark the end of the list?). If you have the forum info (or the forum cache is filled in so you can get the info) you should be able to do something like "WHERE forumid NOT IN $forum['childlist']". (Or I suppose you could just use the field name if your query includes the forum table).