SELECT id, en, keops.GetDistance('-26.386816','153.08916', latitude, longitude) AS distance FROM keops.geoplaces WHERE asc_6='174281' and AND geotype_id > 6 AND geotype_id NOT IN (7, 9, 10, 11, 12, 13, 14) AND latitude IS NOT NULL AND latitude != '' AND latitude != 0 AND longitude IS NOT NULL AND longitude != '' AND longitude != 0 HAVING distance <= 20 ORDER BY distance ASC, en ASC LIMIT 30; Something Wrong Happen !