City Load (2.637009)   SELECT *, (ACOS(COS(-0.399680398706701)*COS(-0.754564012697105)*COS(RADIANS(cities.lat))*COS(RADIANS(cities.lng))+
 COS(-0.399680398706701)*SIN(-0.754564012697105)*COS(RADIANS(cities.lat))*SIN(RADIANS(cities.lng))+
 SIN(-0.399680398706701)*SIN(RADIANS(cities.lat)))*3963.19)
 AS distance FROM cities WHERE (cities.lat>-30.1284926426796 AND cities.lat<-15.6715073573204 AND cities.lng>-51.0728873255754 AND cities.lng<-35.3937792744246 AND (ACOS(COS(-0.399680398706701)*COS(-0.754564012697105)*COS(RADIANS(cities.lat))*COS(RADIANS(cities.lng))+
 COS(-0.399680398706701)*SIN(-0.754564012697105)*COS(RADIANS(cities.lat))*SIN(RADIANS(cities.lng))+
 SIN(-0.399680398706701)*SIN(RADIANS(cities.lat)))*3963.19)
 <= 500) 

  City Load (3.165801)   SELECT *, (ACOS(COS(-0.399680398706701)*COS(-0.754564012697105)*COS(RADIANS(cities.lat))*COS(RADIANS(cities.lng))+
 COS(-0.399680398706701)*SIN(-0.754564012697105)*COS(RADIANS(cities.lat))*SIN(RADIANS(cities.lng))+
 SIN(-0.399680398706701)*SIN(RADIANS(cities.lat)))*3963.19)
 AS distance FROM cities WHERE (cities.lat>-37.3425283000737 AND cities.lat<-8.45747169992626 AND cities.lng>-58.8534175856668 AND cities.lng<-27.6132490143333 AND (ACOS(COS(-0.399680398706701)*COS(-0.754564012697105)*COS(RADIANS(cities.lat))*COS(RADIANS(cities.lng))+
 COS(-0.399680398706701)*SIN(-0.754564012697105)*COS(RADIANS(cities.lat))*SIN(RADIANS(cities.lng))+
 SIN(-0.399680398706701)*SIN(RADIANS(cities.lat)))*3963.19)
 <= 999) 

(20730 records on the 999km radius)