SELECT F.RNUM
    , F.TOTCNT
    , F.CONTENTS_ID
    , F.CONTENTS_TYPE
    , F.TITLE
    , F.DESCRIPTION
    , F.GRC_NAME
    , F.GRP_TYPE
    , F.UPDATE_USER
    , F.UPDATE_DATE
    , F.IMG_ID
    , F.IMG_NAME
    , F.THUM_ID
    , F.THUM_NAME
    , F.POSTER_ALT
    , F.THUMB_ALT
FROM (
    SELECT CEIL ((ROW_NUMBER() OVER(ORDER BY A.PUBLISH_DATE DESC)+0.00) / (5+0.00)) AS RNUM
        , COUNT(*) OVER() TOTCNT
        , A.CONTENTS_ID
        , A.CONTENTS_TYPE
        , A.TITLE
        , A.DESCRIPTION
        , A.ASSET_ID_THUMBNAIL
        , A.UPDATE_USER
        , A.UPDATE_DATE
        , A.PUBLISH_DATE
        , C.GRP_TYPE
        , D.GRC_NAME
        , G.ASSET_ID AS IMG_ID
        , G.SAVE_FILE_NAME AS IMG_NAME
        , G.FILE_ALT AS POSTER_ALT
        , H.ASSET_ID AS THUM_ID
        , H.SAVE_FILE_NAME AS THUM_NAME
        , H.FILE_ALT AS THUMB_ALT
    FROM TB_CONTENTS A, TB_MGMT_GROUP C, TB_MGMT_GROUPCOM D, TB_ATTACH_FILE G, TB_ATTACH_FILE H
    WHERE 1=1
    AND A.CONTENTS_ID = C.CONTENTS_ID(+)
    AND A.CONTENTS_ID = D.CONTENTS_ID(+)
    AND A.ASSET_ID_POSTER = G.ATTACH_ID(+)
    AND A.ASSET_ID_THUMBNAIL = H.ATTACH_ID(+)
    AND A.DEL_YN = 'N'
    AND A.USE_YN = 'Y'
    AND A.LANG_CD(+) = 'KO'
    AND C.LANG_CD(+) = 'KO'
    AND D.LANG_CD(+) = 'KO'
    AND A.CONTENTS_TYPE IN ('STG','LSP','COP','HIS','GRC')
) F

위 쿼리가 있는데요 맨 하단에 AND A.CONTENTS_TYPE IN ('STG','LSP','COP','HIS','GRC') 이부분을 손보고 싶은데요

A.CONTENTS_TYPE 이 ('STG','LSP','COP','HIS') 요거까지는 C.GRP_TYPE = 'I' 로 검색하는 조건을 주고 싶고

A.CONTENTS_TYPE 이 ('GRC') 인거는 모두 조회하고 싶은데요.

한 쿼리에 이게 가능할까요?