SELECT code.text_val AS area_code, name.text_val AS name,
       coords.lon AS lon, coords.lat AS lat
  FROM geodb_textdata AS code JOIN geodb_textdata AS name USING (loc_id)
  JOIN geodb_coordinates AS coords USING (loc_id)
 WHERE code.text_type = 500300000 AND name.text_type = 500100000 AND
       code.text_val = ?
 ORDER BY name ASC;