SELECT code.text_val AS area_code, name.text_val AS name,
       loc.lon AS lon, loc.lat AS lat
  FROM geodb_textdata AS code
       JOIN geodb_hierarchies AS hier ON (
       	 code.text_type = 500300000 AND hier.loc_id = code.loc_id
       )
       JOIN geodb_textdata AS country ON (
         country.text_type = 500500000 AND country.loc_id = hier.id_lvl2
       )
       JOIN geodb_textdata AS name ON (
         name.text_type = 500100000 AND name.loc_id = code.loc_id
       )
       JOIN geodb_coordinates AS loc ON (
         loc.loc_id = code.loc_id
       )
 WHERE country.text_val = ? AND code.text_val = ?;