Paginate problem with aggregate column

Try:

PHP Code:

$this->select('( 6371 * acos( cos( radians('.$this->escapeString($array['lat']).') ) * cos( radians( user_lat ) ) * cos( radians( user_lon ) - radians('.$this->escapeString($array['lon']).') ) + sin( radians('.$this->escapeString($array['lat']).') ) * sin(radians(user_lat)) ) ) as distance', false); 


ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper