[eluser]jerry4christ[/eluser]
Please help me check this, what am I doing wrong.
Code:
$this->db
->select("blog.*, blog_categories.title AS category_title, blog_categories.slug AS category_slug")
->select("SUM(IF(comments.is_active = 1,1,0)) total_comments")
->select('users.username, profiles.display_name')
->join('blog_categories', 'blog.category_id = blog_categories.id', 'left')
->join('comments', 'comments.entry_id = blog.id', 'left')
->join('profiles', 'profiles.user_id = blog.author_id', 'left')
->join('users', 'blog.author_id = users.id', 'left')
->order_by('created_on', 'DESC');
I keep getting this error:
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`total_comments`, `default_users`.`username`, `default_profiles`.`display_name` ' at line 1
SELECT `default_blog`.*, `default_blog_categories`.`title` AS `category_title`, `default_blog_categories`.`slug` AS `category_slug`, SUM(IF(comments.is_active = 1, `1 0))` `total_comments`, `default_users`.`username`, `default_profiles`.`display_name` FROM `default_blog` LEFT JOIN `default_blog_categories` ON `default_blog`.`category_id` = `default_blog_categories`.`id` LEFT JOIN `default_comments` ON `default_comments`.`entry_id` = `default_blog`.`id` LEFT JOIN `default_profiles` ON `default_profiles`.`user_id` = `default_blog`.`author_id` LEFT JOIN `default_users` ON `default_blog`.`author_id` = `default_users`.`id` WHERE `status` = 'live' AND `default_blog`.`created_on` <= 1413476587 ORDER BY `created_on` DESC LIMIT 100