sql dotaz a pocet komentaru

SELECT blog.id, blog.name, blog.url, blog.description, blog.image, blog.date, blog.autor, blog.category, users.real_name, COUNT( comments.nick ) AS count_comments, category.name AS category_name, category.title AS category_title
FROM `blog` , `users` , `category` , `comments` 
WHERE `blog`.`public` =1
AND `users`.`id` = `blog`.`autor` 
AND `category`.`id` = `blog`.`category` 
AND `comments`.`id_text` = `blog`.`id` 
GROUP BY `blog`.`id` 
ORDER BY `count_comments` DESC 
LIMIT 0 , 30