Error with complex Oracle query

Try

PHP Code:

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