окпд2

select novc.id, novc.value, novc.sid, novc.value_range_id, novr.min_value, novr.max_value, novr.min_notation, novr.max_notation, novr.range_type, lo.symbol from nsi_okpd2_value_characteristic novc
left join nsi_okpd2_value_range novr on novc.value_range_id = novr.id
left join list_okei lo on novc.okei_id = lo.id
where novc.characteristic_id = 1684234