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)