- 변경 쿼리
SELECT ALBUM_ID AS SERIES_ID
FROM IMCSUSER.PT_LA_ALBUM_RELATION A
WHERE exists (SELECT 1
FROM IMCSUSER.PT_LA_ALBUM_RELATION
WHERE ALBUM_ID IN
(
'0154348001'
)
AND QUALITY_TYPE = A.QUALITY_TYPE
AND SALE_TYPE = A.SALE_TYPE
AND GROUP_TYPE = 'C'
and ALBUM_GROUP_ID = A.ALBUM_GROUP_ID
GROUP BY ALBUM_GROUP_ID)
UNION
SELECT ALBUM_GROUP_ID AS SERIES_ID
FROM IMCSUSER.PT_LA_ALBUM_GROUP
WHERE GROUP_TYPE = 'S'
AND ALBUM_GROUP_ID IN
(
'0154348001'
)
)
SELECT
/* modifySchedule.base.selectContentListBySeriesIdDup */
SER_MST.ALBUM_GROUP_ID AS CONTENT_ID ,
SER_MST.ALBUM_GROUP_NM AS CONTENT_NAME
FROM IMCSUSER.PT_LA_ALBUM_GROUP SER_MST ,
SUPER SUPER
WHERE SER_MST.ALBUM_GROUP_ID = SUPER.SERIES_ID
AND SER_MST.GROUP_TYPE = 'S';