Dodanie warunku w klazuli WHERE Opcje

[seba123]

Hi, mam takie zapytanie

[SQL] pobierz, plaintext 
 SELECT post.ID, post.post_title, post.post_date, AVG(rating.rating_rating) AS ocena, COUNT(rating.rating_rating) AS ilosc FROM wp_posts AS post LEFT JOIN wp_ratings AS rating ON(rating.rating_postid = ID) WHERE post.post_type = 'post' && post.post_status = 'publish' GROUP BY post.ID ORDER BY ocena DESC LIMIT 4 
[SQL] pobierz, plaintext 

I potrzebuje dodać coś na styl WHERE ilosc > 3 - w jaki sposób to wykonać?

Ten post edytował seba123 23.03.2011, 11:35:28

[JoShiMa]

To nie WHERE tylko HAVING dodatkowa klauzula (IMG:style_emoticons/default/smile.gif)

[seba123]

Oooo! Dziękuję, zupełnie zapomniałem o tym! (IMG:style_emoticons/default/wink.gif)

[san32]

SELECT post.ID, post.post_title, post.post_date, AVG(rating.rating_rating) AS ocena, COUNT(rating.rating_rating) AS ilosc FROM wp_posts AS post LEFT JOIN wp_ratings AS rating ON(rating.rating_postid = ID) WHERE (post.post_type = 'post' && post.post_status = 'publish')and (ilosc > 3 ) GROUP BY post.ID ORDER BY ocena DESC LIMIT 4