MyBB Community Forums

This code stop query from returning threads waiting moderation or those that can't be viewed:

t.visible='1' AND t.closed NOT LIKE 'moved|%'

What should I use to prevent query from fetching posts waiting moderation?

Just use p.visible=1 and it will be fine. This is assuming the query already aliases the mybb_posts table as p.

Thanks buddy that works great didn't know that