SELECT * FROM tx_bpapflegeeinrichtungen_memberdata LEFT JOIN tx_plzlonlat as ll on (plz=tx_bpapflegeeinrichtungen_memberdata.mem_zip) LEFT JOIN fe_users as feu ON (feu.username = mem_fe_user_id) WHERE hidden=0 AND feu.username IS NOT NULL AND ACOS(SIN(RADIANS(ll.lat)) * SIN(RADIANS(52.3613)) + COS(RADIANS(ll.lat)) * COS(RADIANS(52.3613)) * COS(RADIANS(ll.lon) - RADIANS(9.66549))) * 6380 < 1
