SELECT me.id_checkin, me.user_id, me.modified, 
       me.location, me.accuracy FROM 
( SELECT c.*, 
      GLength(LineStringFromWKB(
      LineString(AsBinary(c.location),AsBinary(?))))
  AS distance
  FROM loc c
  ORDER by distance asc
  LIMIT ?)