select * from SHIRYOU where S_VIEW = 0 and B_CD = order by B_CD, BA_CD, BB_CD, BC_CD, S_CD