Complex SQL -> converting to active records

[eluser]Phil Sturgeon[/eluser]

Code:

$this->db->select('ClubID, Name, Lat, Lng, Address1, Address2, Address3, County, PostCode, TelArea, TelNo, Web, Email, Review')
    ->select('( 3959 * acos( cos( radians($Lat) ) * cos( radians( Lat ) ) * cos( radians( Lng ) - radians($Lng) ) + sin( radians($Lat) ) * sin( radians( Lat ) ) ) ) AS distance', FALSE)
    ->having('distance <', $Dist)
    ->order_by('distance')
    ->limit(20);

$query = $this->db->get('golfcourses');

Or something along those lines.