franzauker cosa non ti convince in questo pezzo di query?

(select sum(real_con_length)
from
export_ore
where (code_prefix = qi.code_prefix or code_prefix like qi.code_prefix + '/%') and commessa is null
and (competenza = 'E' or competenza = 'G') and tipo_op = 'interno'

) as MI_ELET,