SELECT `bug50698_2`.`foreign_id` FROM `bug50698_2` AS `bug50698_2` SELECT `countryproperties`.`Id`, `countryproperties`.`Name`, `countryproperties`.`Value`, `countryproperties`.`ValueType` FROM `countryproperties` AS `countryproperties`