SELECT
   a.text_type, a.text_val, a.loc_id, c.lon, c.lat
FROM geodb_textdata a, geodb_textdata b, geodb_coordinates c
WHERE ( a.text_locale = 'de' AND a.text_type = 500100000 AND b.loc_id = a.loc_id AND b.text_type = 500300000 AND b.text_val = 8000 AND c.loc_id = b.loc_id )