mysql error: Unknown column 'aa.areaType' in 'on clause'
SQL: SELECT b.name, b.address, c.name AS city, b.state, b.zip#, 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='20' AND aa.typeID=b.cityID)
INNER JOIN (
SELECT `cityID`, ROUND((((acos(sin((40.699457*pi()/180)) * sin((`lat`*pi()/180))+cos((40.699457*pi()/180)) * cos((`lat`*pi()/180)) * cos(((-99.0814767- `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='42'
ORDER BY cll.miles, b.name
LIMIT 5