select a.id,a.top,a.notice,a.elite,a.position,a.longitude,a.latitude,a.transpondNum,a.content,a.userId,a.saveTime,b.name,b.photo,c.content as transpondContent,a.transpondId,d.id as transpondUserId,d.name as transpondName from copying_circle_art as a inner join total_user as b on a.userId = b.id left join copying_circle_art as c on a.transpondId = c.id left join total_user as d on c.userId = d.id where a.longitude > 115.340000 and a.longitude < 117.340000 and a.latitude > 36.550000 and a.latitude < 38.550000 order by ACOS(SIN((37.550000 * 3.1415) / 180 ) * SIN((a.latitude * 3.1415) / 180 ) + COS((37.550000 * 3.1415) / 180 )* COS((a.latitude * 3.1415) / 180 ) * COS((116.340000* 3.1415) / 180 - (a.longitude * 3.1415) / 180 )) * 6380 asc