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ć?

To nie WHERE tylko HAVING dodatkowa klauzula

Oooo! Dziękuję, zupełnie zapomniałem o tym!

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