SQL запрос

[Sidious]

Есть запрос:

SELECT DISTINCT ibf_posts.author_id, ibf_topics.*, 
				ibf_forums.name FROM ibf_topics, ibf_forums 
				LEFT JOIN ibf_posts ON (ibf_topics.tid = ibf_posts.topic_id AND ibf_posts.author_id = '".$this->ipsclass->member['id']."') 
				WHERE ibf_topics.forum_id = ibf_forums.id AND ibf_topics.last_post > ".$this->ipsclass->member['last_visit']."  
ORDER BY last_post DESC

 

Надо в него добавить:

WHERE (forum_id NOT IN ($forumexclude))

 

Кто нибудь знает куда?

[.silent]

ну так в where и добавляй

 

SELECT DISTINCT 
ibf_posts.author_id, ibf_topics.*, ibf_forums.name 
FROM 
ibf_topics, ibf_forums
	LEFT JOIN ibf_posts ON (
		ibf_topics.tid = ibf_posts.topic_id 
		AND ibf_posts.author_id = '".$this->ipsclass->member['id']."'
	)
WHERE 
ibf_topics.forum_id = ibf_forums.id
AND (ibf_topics.forum_id NOT IN (".$forumexclude.")) 
AND ibf_topics.last_post > ".$this->ipsclass->member['last_visit']."
ORDER BY 
last_post DESC

[SAT]

главное что бы $forumexclude не оказался числовым массивом, а то надо писать implode(",", $forumexclude)

[Sidious]

Спасиб, а сюда:

select t.*, f.name from ibf_topics t
	LEFT join ibf_forums f ON (f.id = t.forum_id) ORDER BY t.last_post DESC

тоже самое?

[.silent]

SELECT
t.*, f.name from ibf_topics t
	LEFT join ibf_forums f ON (
		f.id = t.forum_id
	) 
WHERE 
t.forum_id NOT IN ($forumexclude)
ORDER BY t.last_post DESC