If there is only one value, it's simple.
$idlang = 1; $idFeature = 14; $idProduct = 222; $getFeatureValue = Db::getInstance()->getValue(' SELECT a.value FROM '._DB_PREFIX_.'feature_value_lang a LEFT JOIN '._DB_PREFIX_.'feature_product b ON (a.id_feature_value = b.id_feature_value) WHERE b.id_feature = '.$idFeature.' AND b.id_product = '.$idProduct.' AND a.id_lang = '.$idLang);
Result one value: