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 `MPD` DESC
LIMIT 0, 10
Blogs
