Query:
SELECT `BlogPosts`.*, COUNT(`cmt_id`) AS `CountComments`, `BlogCategories`.`OwnerID`,`BlogCategories`.`CategoryName`, `BlogCategories`.`CategoryUri`
FROM `BlogPosts`
LEFT JOIN `CmtsBlogPosts` AS `tc` ON `BlogPosts`.`PostID` = `tc`.`cmt_object_id`
LEFT JOIN `BlogCategories` ON `BlogCategories`.`CategoryID`=`BlogPosts`.`CategoryID`
WHERE `PostStatus`='approval'
GROUP BY `BlogPosts`.`PostID`
ORDER BY `CountComments` DESC, `PostDate` DESC
Mysql error: Table 'jawwna.BlogPosts' doesn't exist
Found error in file /home/jawwna/new.jawwna.com/inc/classes/BxDolBlogs.php
at line 383. Called db_res function
with erroneous argument #0