Query:
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 20, 10
Mysql error: Table 'jawwna.BlogPosts' doesn't exist
Found error in file /home/jawwna/new.jawwna.com/inc/classes/BxDolBlogs.php
at line 262. Called db_res function
with erroneous argument #0