SELECT *,
3956 * 2 * ASIN(SQRT( POWER(SIN(( - CenterLatitude) * pi()/180 / 2), 2) + COS( * pi()/180)
* COS(CenterLatitude * pi()/180) *POWER(SIN(( - CenterLongitude) * pi()/180 / 2), 2) )) AS distance 
FROM RegionCenterCoordinatesList, ParentRegionList 
WHERE 1 
AND RegionCenterCoordinatesList.RegionID = ParentRegionList.RegionID 
AND ParentRegionList.RegionType = 'Neighborhood'ORDER BY distance 
LIMIT 0, 1 
1