[ImportPassion]

Originally Posted by NTLDR

If you want permissions ignored then feel free to remove them, otherwise they are needed to prevent threads in forums the browser doesn't have access to view.

I think u are missing what I am saying.
by default it is NOT IN
say i have 25 forums and i don't want 1-20 showing posts then i would do,so it NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,2 0)
etc. for the forums I don't want listed. which is correct. (but i think i have even more than that.)
so now mysql just takes 21-25 after an exhaustive search to exclude all those forums.

what I did was the reverse
I did
IN (21,22,23,24,25)
which is alot easier on mysql

it may not work for all, but for ppl with more NOT IN then IN, it is a better solution IMO.

D