SELECT `Blogs`.`ID` , `Blogs`.`OwnerID` , `Blogs`.`Description` , `Profiles`.`Nickname` , MAX(`PostDate`) AS 'MPD', COUNT(`BlogPosts`.`PostID`) AS 'PostCount'
FROM `Blogs`
INNER JOIN `BlogCategories` ON `BlogCategories`.`OwnerID` = `Blogs`.`OwnerID`
INNER JOIN `Profiles` ON `Profiles`.`ID` = `Blogs`.`OwnerID`
INNER JOIN `BlogPosts` ON `BlogPosts`.`CategoryID` = `BlogCategories`.`CategoryID`
WHERE `PostStatus`='approval'
GROUP BY `Blogs`.`ID`
ORDER BY `PostCount` DESC
LIMIT 0, 10
Top Blogs
