object

gistfile1.txt

@dynamic albumId;
@dynamic albumName;
@dynamic artistId;
@dynamic artistName;
@dynamic downId;
@dynamic finished;
@dynamic genreId;
@dynamic genreName;
@dynamic hitSongYN;
@dynamic playTime;
@dynamic songId;
@dynamic songTitle;
@dynamic status;
@dynamic tanggal;
@dynamic tipe;
@dynamic userId;
@dynamic totalBytesExpectedToRead;
@dynamic totalBytesRead;

SELECT AL.ALBUM_ID,
AL.ALBUM_NAME,
MUD.ARTIST_ID,
MUD.ARTIST_NAME,
MUD.DOWN_ID,
'@dynamic finished',
G.GENRE_ID,
G.GENRE_NAME,
S.HIT_SONG_YN,
S.PLAY_TIME,
S.SONG_ID,
S.SONG_NAME,
'@dynamic status;',
MUD.REG_DATE,
'@dynamic tipe;',
MUD.USER_ID,
'@dynamic totalBytesExpectedToRead',
'@dynamic totalBytesRead'
FROM MU_USER_DOWN MUD
INNER JOIN SONG S
ON MUD.SONG_ID=S.SONG_ID
INNER JOIN ALBUM AL
ON S.ALBUM_ID=AL.ALBUM_ID
INNER JOIN MD_GENRE G
ON S.GENRE_ID=G.GENRE_ID
WHERE MUD.BILLING_STATUS_CD IN ('BS0003','BS0004','BS0005');