Mysql Queries - Best Tips

[eluser]Armchair Samurai[/eluser]
Assuming there is a 1-to-1 relationship between the tables, just join them rather than making three separate queries.

Code:

$this->db->join('accounts y', 'x.author_id = y.id');
$this->db->join('posts_categories z', 'x.cat_id = z.post_id');
$query = $this->db->get('blogs x');
return $query->result_array();