Select top 12 idxnum, title, contents, img_00, hit, regdate, z From RESTREE.dbo.Risom_Event2 Where status ='Y' And Idxnum not in (Select Top 0 Idxnum From RESTREE.dbo.Risom_Event2 Where status ='Y' order by case status when 'Y' then 1 end, regdate desc ) order by case status when 'Y' then 1 end, regdate desc