mysql error: Unknown column 'aa.areaType' in 'on clause'
SQL: SELECT, b.address, AS city, b.state,, b.displayPhone, b.displayPhoneNumber FROM businesses AS b INNER JOIN business_industries AS bi ON b.businessID=bi.businessID INNER JOIN area_availability AS area_availability ON (aa.areaType='city' AND aa.group_id='19' AND aa.typeID=b.cityID) INNER JOIN ( SELECT `cityID`, ROUND((((acos(sin((37.6994599*pi()/180)) * sin((`lat`*pi()/180))+cos((37.6994599*pi()/180)) * cos((`lat`*pi()/180)) * cos(((-97.1380962- `long`)*pi()/180))))*180/pi())*60*1.1515), 1) AS miles FROM city_lat_long GROUP BY cityID HAVING miles<=20 ORDER BY miles ) AS cll ON b.cityID=cll.cityID INNER JOIN cities AS c ON b.cityID=c.cityID WHERE bi.industryID='48' ORDER BY cll.miles, LIMIT 5