Zau4man

 
 
SELECT p.id
				FROM cms_forum_posts p
				INNER JOIN cms_forum_threads t ON t.id = p.thread_id
				INNER JOIN cms_forums f ON f.id = t.forum_id AND f.NSLeft >= '94' AND f.NSRight <= '95' AND f.published = 1 
 
 

 
 
SELECT p.pubdate, p.id AS post_id,
				   u.id AS uid, u.nickname AS author,
                   u.login AS author_login, 
				   t.title AS threadtitle, t.id AS threadid
			FROM cms_forum_posts p
			LEFT JOIN cms_forum_threads t ON t.id = p.thread_id AND t.is_hidden=0
			INNER JOIN cms_forums f ON f.id = t.forum_id
			LEFT JOIN cms_users u ON u.id = p.user_id
			WHERE (f.NSLeft >= 94 AND f.NSRight <= 95)
			ORDER BY p.id DESC
			LIMIT 1