SELECT cityName , cityAvgPrice, cityID, (((acos(sin((52.75*pi()/180)) * sin((`cityLat`*pi()/180))+cos((52.75*pi()/180)) * cos((`cityLat`*pi()/180)) * cos(((6.6833333- `cityLon`)*pi()/180))))*180/pi())*60*1.1515*1.609344) as distance 
					FROM tp_cities 
					WHERE `cityLat` IS NOT NULL
						AND `cityLon` IS NOT NULL 
						AND cityAvgPrice > 10 
					ORDER BY distance ASC
					LIMIT 50<br />Sort aborted: Server shutdown in progress