SELECT id, es, distance FROM ( SELECT id, es, keops.GetDistance('38.83','-88.63', `latitude`,`longitude`) AS distance FROM keops.geoplaces WHERE keops.geoplaces.asc_3=599 and geotype_id = 9 ) AS temp WHERE distance <= 1000 ORDER BY distance ASC, es ASC LIMIT 50;