Complex SQL Query with Active Record

[eluser]Aljebrini[/eluser]
i think you can user active record to do your query by writing full query then pass it to the db->get() function ...

$query = "SELECT category.id ,category.title , post.id , post.title , post.content ,COUNT(comments.id) as comment_count FROM categories as category , posts as post,comments Where post.status = 1 AND comments.status = 1 and post.category_id = category.id ";

$this->db->get($query) ;

i didn't test this query on your real database tables but it will work, try to see what you get from ..