|
SELECT DISTINCT
dacms_user.name,
dacms_news.id,avtor,
dacms_comments.aid,dacms_rating.raid,rball,
COUNT(DISTINCT dacms_comments.aid),
COUNT(DISTINCT dacms_rating.raid),
SUM(dacms_rating.rball)
FROM dacms_news
left outer join dacms_user on (dacms_user.name=dacms_news.avtor)
LEFT JOIN dacms_comments ON (dacms_comments.aid = dacms_news.id)
LEFT JOIN dacms_rating ON (dacms_rating.raid = dacms_news.id)
GROUP BY dacms_news.id
|