SELECT name, code, state, city, lat, lng, hotel, size, description,( 3959 * acos( cos( radians(43.165) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-77.611) ) + sin( radians(43.165) ) * sin( radians( lat ) ) ) ) AS distance FROM waterparks HAVING distance < 100 ORDER BY distance ASC
Error: Table 'pooiwp.waterparks' doesn't exist