[zylstra]

Analogpoint, we're getting there. I've found the bitfield responsible for the forum options. It does not have to do with permissions. It's all in forum.options:

<group name="forumoptions">
	<bitfield name="active">1</bitfield>
	<bitfield name="allowposting">2</bitfield>
	<bitfield name="cancontainthreads">4</bitfield>
	<bitfield name="moderatenewpost">8</bitfield>
	<bitfield name="moderatenewthread">16</bitfield>
	<bitfield name="moderateattach">32</bitfield>
	<bitfield name="allowbbcode">64</bitfield>
	<bitfield name="allowimages">128</bitfield>
	<bitfield name="allowhtml">256</bitfield>
	<bitfield name="allowsmilies">512</bitfield>
	<bitfield name="allowicons">1024</bitfield>
	<bitfield name="allowratings">2048</bitfield>
	<bitfield name="countposts">4096</bitfield>
	<bitfield name="canhavepassword">8192</bitfield>
	<bitfield name="indexposts">16384</bitfield>
	<bitfield name="styleoverride">32768</bitfield>
	<bitfield name="showonforumjump">65536</bitfield>
	<bitfield name="warnall">131072</bitfield>
</group>

If I have consolidated my forums so that the only option values that shouldn't contain threads are 85699 and 89795 what should the MySQL code be?

Thanks!

Analogpoint, I figured it out:

SELECT forum.* FROM forum
WHERE (options = 85699 OR options = 89795)
	AND replycount > 0
ORDER BY title