Unknown column 'location' in 'field list'
select id,title,lat,lon,star,wr,mr,ri,titlepic,(2 * 6378.137* ASIN(SQRT(POW(SIN(PI()*(-lon)/360),2)+COS(PI()*location/180)* COS(lat * PI()/180)*POW(SIN(PI()*(location-lat)/360),2)))) as juli from ***_ecms_id where open<2
order by juli asc limit 20