Select Failed! SELECT *,(((acos(sin((*3.1415926535898/180)) * sin((lat*3.1415926535898/180)) + cos((*3.1415926535898/180)) *  cos((lat*3.1415926535898/180)) * cos((( - lon)*3.1415926535898/180))))*180/3.1415926535898)*60*1.423) as distance FROM myb_locaties WHERE type = 'Flexplekken' AND open = 'on' AND demo ='' HAVING distance <= '270' ORDER BY distance DESC LIMIT 0,200