database question -> get rows from complex query AND results in ONE query ?!

[eluser]danmontgomery[/eluser]

Code:

$query = $this->db->from('user')->blablabla->bla->limit($entryspersite,$offset)->get();
if($query !== FALSE) {
    $num_rows = $query->num_rows();
    $result = $query->result_array();
}