Can anyone help me with this one.

Fast Option:

PHP Code:

$query = $this->db->query('YOUR QUERY HERE'); 


Or maybe create a view (without order) and use like a table.

Hi. Thanks for your answer. Yup. I solved it already using a variable $query and then return $query->result();

Thank you.