SELECT 
  CASE
    T1.NOTI_YN 
    WHEN 'Y' 
    THEN '공지' 
    ELSE @ROWNUM := @ROWNUM + 1 
  END AS RNUM,
  T1.* 
FROM
  (SELECT 
    'N' CHK,
    A.ID,
    A.CS_BBS_ID,
    A.GRP,
    A.SORT,
    A.LV,
    B.P_CATEGORY_ID,
    C.CATEGORY_NM P_CS_CATEGORY_NM,
    A.CS_CATEGORY_ID,
    B.CATEGORY_NM CS_CATEGORY_NM,
    A.TITLE,
    A.CONTENTS,
    A.NAME,
    A.VIEWS,
    A.NOTI_YN,
    A.USE_YN,
    A.USER_PWD,
    A.UR_USER_ID,
    A.USER_NAME,
    DATE_FORMAT(A.CREATED, '%Y-%m-%d') AS CREATED,
    A.MODIFIED,
    (SELECT 
      COUNT(*) 
    FROM
      CS_BBS_RECOM R 
    WHERE R.CS_BBS_ID = A.ID) AS CS_BBS_RECOM_CNT,
    F.ID CS_BBS_ATTC_ID,
    F.PHYS_ATTACHED,
    F.REAL_ATTACHED 
  FROM
    CS_BBS A 
    INNER JOIN CS_CATEGORY B 
      ON A.CS_CATEGORY_ID = B.ID 
    INNER JOIN CS_CATEGORY C 
      ON B.P_CATEGORY_ID = C.ID 
    LEFT OUTER JOIN CS_BBS_ATTC F 
      ON A.ID = F.CS_BBS_ID,
    (SELECT 
      @ROWNUM := 0) R 
  WHERE 1 = 1 
    AND B.USE_YN != 'N' 
    AND C.USE_YN != 'N' 
    AND B.P_CATEGORY_ID = 1 
  ORDER BY A.GRP ASC,
    A.SORT DESC) T1 
ORDER BY CAST(RNUM AS INT) DESC 

ROWNUM을 DESC로 정렬하려고 하는데

홀수번째 ROWNUM이 빠져서 나옵니다..ㅠㅠ도와주세여