select g.mnr from g_nr g where g.info_id = '1ecde282-384f-4bb3-8b9c-c78906965c2a'
and g.nrtype = (select DISTINCT (case when (select nrtype from g_nr where info_id = g.info_id and nrtype = 3 and rownum = 1) = 3 then 3
else (select min(nrtype) from g_nr where info_id = g.info_id) end) nrtype from g_nr where info_id = g.info_id)
and g.nrtype = (select DISTINCT (case when (select nrtype from g_nr where info_id = g.info_id and nrtype = 3 and rownum = 1) = 3 then 3
else (select min(nrtype) from g_nr where info_id = g.info_id) end) nrtype from g_nr where info_id = g.info_id)