Kris should have stayed at homeflow

gistfile1.txt

# This gets X users within a distance of '10' radians 

user = User.find_me_a_bloody_user

result = ActiveRecord::Base.connection.execute("
      SELECT
          ((ACOS( SIN( #{user.lat} * PI( ) /180 ) * SIN( latitude * PI( ) /180 ) + COS( #{user.lat} * PI( ) /180 ) * COS( latitude * PI( ) /180 ) * COS( (
          #{user.lng} - longitude) * PI( ) /180 ) ) *180 / PI( ) ) *60 * 1.1515)
      AS `distance` , users
      FROM `users`
      HAVING `distance` <=10
      ORDER BY `distance` ASC
      LIMIT 0 , 1"
      )