select ggcode from yg_item where g6='QN' group by ggcode order by g1 desc, g3 asc, g4 desc, gid asc