Holy SQL, Batman!

SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance
FROM markers
HAVING distance < 25
ORDER BY distance
LIMIT 0 , 20;

relatedposts

comments: be first!

subjectslices

• The Fun
  Food, Outdoors, Tech, Transportation, Travel
• The Arts
  Art, Audio, Creative Commons, Language, Media, Parody, Photography, Photos, Video
• The Personal
  Family, Friends, Home, Money, Politics, School, Work
• The Meta
  Blogging, For Sale, Gripes, Meta, Tip Jar
• The Legacy
  From the Belly of the Beasts, Gallery, White Noise Lounge

monthchunks

• 2012
  1 2
• 2011
  1 2 3 4 5 6 7 8 9 10 11 12
• 2010
  1 2 3 4 5 6 7 8 9 10 11 12
• 2009
  1 2 3 4 5 6 7 8 9 10 11 12
• 2008
  1 2 3 4 5 6 7 8 9 10 11 12
• 2007
  1 2 3 4 5 6 7 8 9 10 11 12
• 2006
  1 2 3 4 5 6 7 8 9 10 11 12
• 2005
  1 2 3 4 5 6 7 8 9 10 11 12
• 2004
  1 2 3 4 5 6 7 8 9 10 11 12
• 2003
  1 2 3 4 5 6 7 8 9 10 11 12
• 2002
  6 7 8 9 10 11 12

license