Wohnung mieten in Schwarzenberg

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) * 6370 as distanz from region_google where qualifiziert in ' at line 1
SQL was: select *, REPLACE(stadtteil, ' - ', '-') as stadtteil, ACOS(SIN() * SIN(x_coord) + COS() * COS(x_coord) * COS(y_coord-)) * 6370 as distanz from region_google where qualifiziert in (1,2,3) and aktuell in (1) and id < 1001999 and genauigkeit in (4) and ( x_coord between - 0.05 and + 0.05 and y_coord between - 0.05 and + 0.05 ) and ort not like '%(%' and satzart is not null having distanz <= 50 and distanz >= 1 order by einwohner desc limit 0, 10