insert into r_result_val(value, result_id) select '9500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '7500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '5000', r.id from r_result r where r.name='VMC_SF_AG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='9500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='7500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5000' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='1')  );insert into r_result_val(value, result_id) select '16500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '13500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '9000', r.id from r_result r where r.name='VMC_SF_AG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='16500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='13500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='9000' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='2')  );insert into r_result_val(value, result_id) select '9500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '7500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '5000', r.id from r_result r where r.name='VMC_SF_AG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='9500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='7500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5000' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='1')  );insert into r_result_val(value, result_id) select '16500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '13500', r.id from r_result r where r.name='VMC_SF_AG_MU';insert into r_result_val(value, result_id) select '9000', r.id from r_result r where r.name='VMC_SF_AG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='16500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='13500' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='9000' and r.name='VMC_SF_AG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='2')  );insert into r_result(name) values('VMC_SF_HG_MU');insert into r_result_val(value, result_id) select '19700', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '16100', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '10750', r.id from r_result r where r.name='VMC_SF_HG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='19700' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='16100' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10750' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='1')  );insert into r_result_val(value, result_id) select '32850', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '26900', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '17900', r.id from r_result r where r.name='VMC_SF_HG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='32850' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='26900' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='17900' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='2')  );insert into r_result_val(value, result_id) select '13300', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '10850', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '7250', r.id from r_result r where r.name='VMC_SF_HG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='13300' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10850' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='7250' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='1')  );insert into r_result_val(value, result_id) select '21550', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '17600', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '11750', r.id from r_result r where r.name='VMC_SF_HG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='21550' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='17600' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='11750' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='2')  );insert into r_result_val(value, result_id) select '13300', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '10850', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '7250', r.id from r_result r where r.name='VMC_SF_HG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='13300' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10850' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='7250' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='1')  );insert into r_result_val(value, result_id) select '21550', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '17600', r.id from r_result r where r.name='VMC_SF_HG_MU';insert into r_result_val(value, result_id) select '11750', r.id from r_result r where r.name='VMC_SF_HG_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='21550' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='17600' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='ENR' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='11750' and r.name='VMC_SF_HG_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='ENR' and iv.value='2')  );
insert into r_result(name) values('REC_EG_MU_I');insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '2300', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '2200', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '1900', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='2300' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='2200' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1900' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_result_val(value, result_id) select '5400', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '5000', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '4500', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5400' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5000' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4500' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_result_val(value, result_id) select '10000', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '9300', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '8300', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10000' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='9300' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='8300' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_result_val(value, result_id) select '13800', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '12900', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '11500', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='13800' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='12900' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='11500' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='5')  );
insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '3500', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '3300', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '2900', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3500' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3300' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='2900' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_result_val(value, result_id) select '8200', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '7600', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '6800', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='8200' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='7600' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6800' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_result_val(value, result_id) select '15200', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '14200', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '12700', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='15200' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='14200' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='12700' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_result_val(value, result_id) select '21000', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '19600', r.id from r_result r where r.name='REC_EG_MU_I';insert into r_result_val(value, result_id) select '17500', r.id from r_result r where r.name='REC_EG_MU_I'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='21000' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='19600' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='17500' and r.name='REC_EG_MU_I' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_result(name) values('REC_EG_MU_E');insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '3100', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '2900', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '2600', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3100' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='2900' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='2600' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_result_val(value, result_id) select '7200', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '6700', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '6000', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='7200' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6700' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6000' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_result_val(value, result_id) select '13300', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '12400', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '11100', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='13300' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='12400' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='11100' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_result_val(value, result_id) select '18400', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '17200', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '15400', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='18400' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='17200' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='15400' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '4700', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '4400', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '3900', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4700' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4400' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3900' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='2')  );insert into r_result_val(value, result_id) select '10900', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '10200', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '9100', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10900' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10200' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='9100' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='3')  );insert into r_result_val(value, result_id) select '20300', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '18900', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '16900', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='20300' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='18900' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='16900' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='4')  );insert into r_result_val(value, result_id) select '28000', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '26200', r.id from r_result r where r.name='REC_EG_MU_E';insert into r_result_val(value, result_id) select '23400', r.id from r_result r where r.name='REC_EG_MU_E'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='28000' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='26200' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TeffCLASS' and iv.value='5')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='23400' and r.name='REC_EG_MU_E' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='ENR' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TeffCLASS' and iv.value='5')  );
insert into r_result(name) values('P3_ROB_MU');insert into r_result_val(value, result_id) select '1700', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '1400', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '930', r.id from r_result r where r.name='P3_ROB_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1700' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TCH' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1400' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TCH' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='930' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TCH' and iv.value='1')  );insert into r_result_val(value, result_id) select '1700', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '1400', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '930', r.id from r_result r where r.name='P3_ROB_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1700' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TCH' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1400' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TCH' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='930' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TCH' and iv.value='2')  ); insert into r_result_val(value, result_id) select '1200', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '980', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '650', r.id from r_result r where r.name='P3_ROB_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1200' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TCH' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='980' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TCH' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='650' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TCH' and iv.value='1')  );insert into r_result_val(value, result_id) select '1600', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '1300', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '890', r.id from r_result r where r.name='P3_ROB_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1600' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TCH' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1300' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TCH' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='890' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TCH' and iv.value='2')  );insert into r_result_val(value, result_id) select '1200', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '980', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '650', r.id from r_result r where r.name='P3_ROB_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1200' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TCH' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='980' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TCH' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='650' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TCH' and iv.value='1')  );insert into r_result_val(value, result_id) select '1600', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '1300', r.id from r_result r where r.name='P3_ROB_MU';insert into r_result_val(value, result_id) select '890', r.id from r_result r where r.name='P3_ROB_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1600' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='TCH' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='1300' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='TCH' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='890' and r.name='P3_ROB_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='TCH' and iv.value='2')  );insert into r_result(name) values('P3_PACE_MU');insert into r_result_val(value, result_id) select '68200', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '55800', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '37200', r.id from r_result r where r.name='P3_PACE_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='68200' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPECLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='55800' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPECLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='37200' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPECLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '88900', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '72800', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '48500', r.id from r_result r where r.name='P3_PACE_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='88900' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPECLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='72800' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPECLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='48500' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPECLASS' and iv.value='2')  ); insert into r_result_val(value, result_id) select '33800', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '27600', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '18400', r.id from r_result r where r.name='P3_PACE_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='33800' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPECLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='27600' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPECLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='18400' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPECLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '45300', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '37100', r.id from r_result r where r.name='P3_PACE_MU';insert into r_result_val(value, result_id) select '24700', r.id from r_result r where r.name='P3_PACE_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='45300' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPECLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='37100' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPECLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='24700' and r.name='P3_PACE_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPECLASS' and iv.value='2')  );
insert into r_result(name) values('P3_PACE_MU_2');insert into r_result_val(value, result_id) select '87400', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '71500', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '47700', r.id from r_result r where r.name='P3_PACE_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='87400' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_ETASCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='71500' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_ETASCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='47700' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_ETASCLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '101100', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '82700', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '55200', r.id from r_result r where r.name='P3_PACE_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='101100' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_ETASCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='82700' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_ETASCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='55200' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_ETASCLASS' and iv.value='2')  );insert into r_result_val(value, result_id) select '114600', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '93800', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '62500', r.id from r_result r where r.name='P3_PACE_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='114600' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_ETASCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='93800' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_ETASCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='62500' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_ETASCLASS' and iv.value='3')  );insert into r_result_val(value, result_id) select '43200', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '35300', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '23600', r.id from r_result r where r.name='P3_PACE_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='43200' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_ETASCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='35300' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_ETASCLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='23600' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_ETASCLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '50900', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '41600', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '27700', r.id from r_result r where r.name='P3_PACE_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='50900' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_ETASCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='41600' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_ETASCLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='27700' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_ETASCLASS' and iv.value='2')  );insert into r_result_val(value, result_id) select '58400', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '47800', r.id from r_result r where r.name='P3_PACE_MU_2';insert into r_result_val(value, result_id) select '31800', r.id from r_result r where r.name='P3_PACE_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='58400' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_ETASCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='47800' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_ETASCLASS' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='31800' and r.name='P3_PACE_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_ETASCLASS' and iv.value='3')  );insert into r_result(name) values('P3_PACA_MU');insert into r_result_val(value, result_id) select '90000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '74000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '49000', r.id from r_result r where r.name='P3_PACA_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='90000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPACLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='74000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPACLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='49000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPACLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '93000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '76000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '51000', r.id from r_result r where r.name='P3_PACA_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='93000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPACLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='76000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPACLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='51000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPACLASS' and iv.value='2')  ); insert into r_result_val(value, result_id) select '32000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '26000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '18000', r.id from r_result r where r.name='P3_PACA_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='32000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPACLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='26000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPACLASS' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='18000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPACLASS' and iv.value='1')  );insert into r_result_val(value, result_id) select '32000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '26000', r.id from r_result r where r.name='P3_PACA_MU';insert into r_result_val(value, result_id) select '18000', r.id from r_result r where r.name='P3_PACA_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='32000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='P3_COPACLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='26000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='P3_COPACLASS' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='18000' and r.name='P3_PACA_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='LOG' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='P3_COPACLASS' and iv.value='2')  );insert into r_result(name) values('P3_COPECOL_MU_1');insert into r_result_val(value, result_id) select '71900', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '58900', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '39000', r.id from r_result r where r.name='P3_COPECOL_MU_1'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='71900' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='58900' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='39000' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_result_val(value, result_id) select '106000', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '91700', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '68800', r.id from r_result r where r.name='P3_COPECOL_MU_1'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='106000' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='91700' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='68800' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_result_val(value, result_id) select '91100', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '74600', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '49500', r.id from r_result r where r.name='P3_COPECOL_MU_1'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='91100' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='74600' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='49500' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_result_val(value, result_id) select '134300', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '116200', r.id from r_result r where r.name='P3_COPECOL_MU_1';insert into r_result_val(value, result_id) select '87200', r.id from r_result r where r.name='P3_COPECOL_MU_1'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='134300' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='116200' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='87200' and r.name='P3_COPECOL_MU_1' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_COPECLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_result(name) values('P3_COPECOL_MU_2');
insert into r_result_val(value, result_id) select '46600', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '38200', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '25300', r.id from r_result r where r.name='P3_COPECOL_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='46600' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='38200' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='25300' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_result_val(value, result_id) select '68700', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '59400', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '44600', r.id from r_result r where r.name='P3_COPECOL_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='68700' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='59400' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='44600' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_result_val(value, result_id) select '56400', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '46200', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '30600', r.id from r_result r where r.name='P3_COPECOL_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='56400' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='46200' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='30600' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_result_val(value, result_id) select '83200', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '72000', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '54000', r.id from r_result r where r.name='P3_COPECOL_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='83200' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='72000' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='54000' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_result(name) values('P3_COPECOL_MU_2');insert into r_result_val(value, result_id) select '65800', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '53900', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '35700', r.id from r_result r where r.name='P3_COPECOL_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='65800' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='53900' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='35700' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='1')  );insert into r_result_val(value, result_id) select '96900', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '83900', r.id from r_result r where r.name='P3_COPECOL_MU_2';insert into r_result_val(value, result_id) select '62900', r.id from r_result r where r.name='P3_COPECOL_MU_2'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='96900' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='3')  or   (i.name='ZONE' and iv.value='1')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='83900' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='3')  or   (i.name='ZONE' and iv.value='2')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='62900' and r.name='P3_COPECOL_MU_2' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_ETASCLASS' and iv.value='3')  or   (i.name='ZONE' and iv.value='3')   or (i.name='CUSAGE' and iv.value='2')  );insert into r_result(name) values('P3_IND_RECUP_MU');insert into r_result_val(value, result_id) select '6400', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '6000', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '5000', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6400' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6000' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5000' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='1')  );insert into r_result_val(value, result_id) select '15900', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '15000', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '12600', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='15900' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='15000' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='12600' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='2')  );insert into r_result_val(value, result_id) select '19700', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '18600', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '15600', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='19700' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='18600' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='15600' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='3')  );insert into r_result_val(value, result_id) select '26700', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '25200', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '21100', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='26700' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='25200' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='21100' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='1')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='4')  );insert into r_result_val(value, result_id) select '10300', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '10300', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '10300', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10300' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10300' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='1')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='10300' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='1')  );insert into r_result_val(value, result_id) select '25600', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '25600', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '25600', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='25600' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='25600' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='2')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='25600' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='2')  );insert into r_result_val(value, result_id) select '31800', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '31800', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '31800', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='31800' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='31800' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='3')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='31800' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='3')  );insert into r_result_val(value, result_id) select '43100', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '43100', r.id from r_result r where r.name='P3_IND_RECUP_MU';insert into r_result_val(value, result_id) select '43100', r.id from r_result r where r.name='P3_IND_RECUP_MU'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='43100' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='1')   or (i.name='MFUNC' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='43100' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='2')   or (i.name='MFUNC' and iv.value='4')  );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='43100' and r.name='P3_IND_RECUP_MU' and not exists   (select * from  r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (     (i.name='P3_HEAT_USE' and iv.value='2')  or   (i.name='ZONE' and iv.value='3')   or (i.name='MFUNC' and iv.value='4')  );




-- Pour les simulateurs financement
insert into r_input(name) values('FIN-SITFAM');insert into r_input_val(value, input_id, title) select '1', i.id, 'Célibataire' from r_input i where i.name='FIN-SITFAM';insert into r_input_val(value, input_id, title) select '2', i.id, 'En Concubinage' from r_input i where i.name='FIN-SITFAM';insert into r_input_val(value, input_id, title) select '3', i.id, 'Pacsé' from r_input i where i.name='FIN-SITFAM';insert into r_input_val(value, input_id, title) select '4', i.id, 'Marié' from r_input i where i.name='FIN-SITFAM';insert into r_input(name) values('FIN-PERSCHARGE');insert into r_input(name) values('FIN-ENF');insert into r_input_val(value, input_id, title) select '0', i.id, '0' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '1', i.id, '1' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '2', i.id, '2' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '3', i.id, '3' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '4', i.id, '4' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '5', i.id, '5' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '6', i.id, '6' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '7', i.id, '7' from r_input i where i.name='FIN-ENF';insert into r_input_val(value, input_id, title) select '8', i.id, '8' from r_input i where i.name='FIN-ENF';insert into r_input(name) values('FIN-IC');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-IC';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-IC';insert into r_input(name) values('FIN-CI5');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-CI5';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-CI5';insert into r_input(name) values('FIN-EC');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-EC';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-EC';insert into r_input(name) values('FIN-DCI5');insert into r_input(name) values('FIN-RESSOURCE');insert into r_input(name) values('FIN-SITBAT');insert into r_input_val(value, input_id, title) select '1', i.id, 'Propriétaire Occupant' from r_input i where i.name='FIN-SITBAT';insert into r_input_val(value, input_id, title) select '2', i.id, 'Propriétaire Bailleur' from r_input i where i.name='FIN-SITBAT';insert into r_input_val(value, input_id, title) select '3', i.id, 'Locataire' from r_input i where i.name='FIN-SITBAT';insert into r_input_val(value, input_id, title) select '4', i.id, 'Occupant à titre gratuit' from r_input i where i.name='FIN-SITBAT';insert into r_input(name) values('FIN-AC');insert into r_input_val(value, input_id, title) select '1', i.id, 'Avant 1990' from r_input i where i.name='FIN-AC';insert into r_input_val(value, input_id, title) select '2', i.id, 'Entre 1990 et 1999' from r_input i where i.name='FIN-AC';insert into r_input_val(value, input_id, title) select '3', i.id, 'Entre 2000 et 2012' from r_input i where i.name='FIN-AC';insert into r_input_val(value, input_id, title) select '4', i.id, 'Après 2012' from r_input i where i.name='FIN-AC';insert into r_input(name) values('FIN-ANAH5');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-ANAH5';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-ANAH5';insert into r_input(name) values('FIN-ECOPTZ5');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-ECOPTZ5';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-ECOPTZ5';insert into r_input(name) values('FIN-PRE5');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-PRE5';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-PRE5';insert into r_input(name) values('FIN-ETAT');insert into r_input_val(value, input_id, title) select '1', i.id, 'Renseignements' from r_input i where i.name='FIN-ETAT';insert into r_input_val(value, input_id, title) select '2', i.id, 'En recherche de devis' from r_input i where i.name='FIN-ETAT';insert into r_input_val(value, input_id, title) select '3', i.id, 'Travaux programmés' from r_input i where i.name='FIN-ETAT';insert into r_input_val(value, input_id, title) select '4', i.id, 'Travaux réalisés' from r_input i where i.name='FIN-ETAT';insert into r_input(name) values('FIN-RESIDPRIN');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-RESIDPRIN';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-RESIDPRIN';insert into r_input(name) values('FIN-RESIDPRINLOC');insert into r_input_val(value, input_id, title) select '0', i.id, 'Non' from r_input i where i.name='FIN-RESIDPRINLOC';insert into r_input_val(value, input_id, title) select '1', i.id, 'Oui' from r_input i where i.name='FIN-RESIDPRINLOC';insert into r_input(name) values('FIN-Sform');insert into r_input_val(value, input_id, title) select '1', i.id, 'de vos mensualités' from r_input i where i.name='FIN-Sform';insert into r_input_val(value, input_id, title) select '2', i.id, 'du capital à atteindre' from r_input i where i.name='FIN-Sform';insert into r_input(name) values('FIN-LLuser');insert into r_input(name) values('FIN-LRuser');insert into r_input(name) values('FIN-INST');insert into r_input(name) values('FIN-LC');insert into r_input(name) values('FIN-LoanCLASS');insert into r_input_val(value, input_id, title) select '1', i.id, '1' from r_input i where i.name='FIN-LoanCLASS';insert into r_input_val(value, input_id, title) select '2', i.id, '2' from r_input i where i.name='FIN-LoanCLASS';insert into r_input_val(value, input_id, title) select '3', i.id, '3' from r_input i where i.name='FIN-LoanCLASS';insert into r_input_val(value, input_id, title) select '4', i.id, '4' from r_input i where i.name='FIN-LoanCLASS';insert into r_input_val(value, input_id, title) select '5', i.id, '5' from r_input i where i.name='FIN-LoanCLASS';insert into r_input(name) values('FIN-LLCLASS');insert into r_input_val(value, input_id, title) select '1', i.id, '1' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '2', i.id, '2' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '3', i.id, '3' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '4', i.id, '4' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '5', i.id, '5' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '6', i.id, '6' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '7', i.id, '7' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '8', i.id, '8' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '9', i.id, '9' from r_input i where i.name='FIN-LLCLASS';insert into r_input_val(value, input_id, title) select '10', i.id, '10' from r_input i where i.name='FIN-LLCLASS';
insert into r_result(name) values('LR_GROUPAMA');insert into r_result_val(value, result_id) select '4.37', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '4.37', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '4.37', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '4.37', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.37' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.37' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.37' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.37' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='LR_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.8', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '3.15', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '5.36', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '5.36', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '6.02', r.id from r_result r where r.name='LR_GROUPAMA';insert into r_result_val(value, result_id) select '6.02', r.id from r_result r where r.name='LR_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.8' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.15' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5.36' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5.36' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6.02' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6.02' and r.name='LR_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );
insert into r_result(name) values('TAEG_GROUPAMA');insert into r_result_val(value, result_id) select '4.46', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '4.46', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '4.46', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '4.46', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.46' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.46' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.46' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='4.46' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='1')     );insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='2')     );insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='3')     );insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '0', r.id from r_result r where r.name='TAEG_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='0' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='4')     );insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.87', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '3.2', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '5.49', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '5.49', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '6.19', r.id from r_result r where r.name='TAEG_GROUPAMA';insert into r_result_val(value, result_id) select '6.19', r.id from r_result r where r.name='TAEG_GROUPAMA'; insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='1')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='2')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='3')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.87' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='4')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='5')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='3.2' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='6')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5.49' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='7')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='5.49' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='8')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6.19' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='9')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );insert into r_value_assoc(resultval_id, inputval_id) select rv.id, iv.id from (select _rv.* from r_result_val _rv inner join r_result r on r.id=_rv.result_id where _rv.value ='6.19' and r.name='TAEG_GROUPAMA' and not exists   (select * from r_value_assoc va where va.resultval_id=_rv.id) limit 0,1) as rv inner join r_input_val iv inner join r_input i on i.id=iv.input_id where (       (i.name='FIN-LLCLASS' and iv.value='10')    or (i.name='FIN-LoanCLASS' and iv.value='5')     );



