SELECT name,image
FROM su_option_value_description
INNER JOIN su_option_value
ON su_option_value_description.option_value_id = su_option_value.option_value_id
WHERE option_id = 18
AND language_id = 1
<?php
$product_extra_field = array();
foreach($this->product->extra_field as $extra_field){
$product_extra_field[$extra_field['id']] = $extra_field;
}
$this->product->extra_field = $product_extra_field;
?>
<?php if ($this->product->extra_field[1]['value']){?>
<?php echo $this->product->extra_field[1]['value'];?>
<?php } else {?>
123
<?php }?>
array(8) { [1]=> array(8) { ["id"]=> string(1) "1" ["name"]=> string(20) "набор хар-к" ["description"]=> string(0) "" ["value"]=> string(5) "brand" ["groupname"]=> NULL ["field_value_ids"]=> array(1) { [0]=> string(1) "4" } ["grshow"]=> int(1) ["grshowclose"]=> int(1) } [2]=> array(7) { ["id"]=> string(1) "2" ["name"]=> string(20) "Площадь, м²" ["description"]=> string(20) "Площадь, м²" ["value"]=> string(2) "25" ["groupname"]=> string(45) "Основные характеристики" ["grshow"]=> int(1) ["grshowclose"]=> int(0) } [4]=> array(7) { ["id"]=> string(1) "4" ["name"]=> string(20) "Компрессор" ["description"]=> string(20) "Компрессор" ["value"]=> string(16) "инвертор" ["groupname"]=> string(45) "Основные характеристики" ["grshow"]=> int(0) ["grshowclose"]=> int(0) } [5]=> array(7) { ["id"]=> string(1) "5" ["name"]=> string(18) "Хладагент" ["description"]=> string(18) "Хладагент" ["value"]=> string(12) "R-410A / 0.7" ["groupname"]=> string(45) "Основные характеристики" ["grshow"]=> int(0) ["grshowclose"]=> int(0) } [12]=> array(7) { ["id"]=> string(2) "12" ["name"]=> string(25) "Страна бренда" ["description"]=> string(25) "Страна бренда" ["value"]=> string(10) "Китай" ["groupname"]=> string(45) "Основные характеристики" ["grshow"]=> int(0) ["grshowclose"]=> int(0) } [13]=> array(7) { ["id"]=> string(2) "13" ["name"]=> string(16) "Макс. м3/ч" ["description"]=> string(16) "Макс. м3/ч" ["value"]=> string(7) "560~330" ["groupname"]=> string(45) "Основные характеристики" ["grshow"]=> int(0) ["grshowclose"]=> int(0) } [14]=> array(7) { ["id"]=> string(2) "14" ["name"]=> string(30) "Уровень шума (дБ)" ["description"]=> string(30) "Уровень шума (дБ)" ["value"]=> string(5) "39~26" ["groupname"]=> string(45) "Основные характеристики" ["grshow"]=> int(0) ["grshowclose"]=> int(0) } [15]=> array(7) { ["id"]=> string(2) "15" ["name"]=> string(28) "Охлаждение, кВт" ["description"]=> string(28) "Охлаждение, кВт" ["value"]=> string(4) "2.60" ["groupname"]=> string(45) "Основные характеристики" ["grshow"]=> int(0) ["grshowclose"]=> int(1) } } array(8) { [1]=> array(8) { ["id"]=> string(1) "1" ["name"]=> string(20) "набор хар-к" ["description"]=> string(0) "" ["value"]=> string(5) "brand" ["groupname"]=> NULL ["field_value_ids"]=> array(1) { [0]=> string(1) "4" } ["grshow"]=> int(1) ["grshowclose"]=> И ТД