select a.cityname, a.geosizeid, a.cityid from sixcms71_bikerszene_xtra.bs_geo_city a where abs(x(a.loc) - 8.422678) < 0.5 and sixcms71_bikerszene_xtra.bs_distance_km(a.loc, geomfromtext("POINT(8.422678 53.346223)")) < 25 order by a.geosizeid desc limit 10
Motorradtouren Ovelgönne - bikerszene
