'='discs')]]> ]]> discs iseq EPIC.DISCOGRAPHY RTRIM(DISCID) EPIC.DISCOGRAPHY RELEASEDATE EPIC.DISCOGRAPHY ARTISTID EPIC.DISCOGRAPHY DISCID EPIC.DISCOGRAPHY NAME EPIC.DISCOGRAPHY PRODUCER EPIC.DISCOGRAPHY STUDIO EPIC.DISCOGRAPHY TRACKNO EPIC.DISCOGRAPHY STORE RTRIM(DISCID) EPIC.DISCOGRAPHY RELEASEDATE RELEASEDATE EPIC.DISCOGRAPHY ARTISTID = 905 false false '='disc')]]> ]]> disc iseq > SELECT '' FROM DUAL <@ELSE> SELECT DISCS.*, CLIPVIEW.CLIPID, CLIPVIEW.SUBDIR, CLIPVIEW.SUFFIX, CLIPVIEW.CLIPSUFFIXTYPE, CLIPVIEW.SORT1, CLIPVIEW.SORT2, SUBSTR(TRACKS.LYRICSTEXT,1,1) FROM EPIC.DISCS, EPIC.CLIPVIEW, EPIC.TRACKS WHERE DISCS.DISCID='<@SEARCHARG discid>' AND CLIPVIEW.DISCID (+) = DISCS.DISCID AND CLIPVIEW.TRACKID (+) = DISCS.TRACKNO AND TRACKS.TRACKID = DISCS.TRACKID ORDER BY DISCS.RELEASEDATE DESC, DISCS.TRACKNO, CLIPVIEW.SORT1, CLIPVIEW.SORT2, CLIPVIEW.CLIPSUFFIXTYPE ]]> '='lyrics')]]> ]]> lyrics iseq ]]> Oracle epicsony.world epic %9A%1B%E59%B0X%82u %F5%CA%C4%AB%93%DA%F9%F9 Oracle epicsony.world epicsony.world %9A%1B%E59%B0X%82u %F5%CA%C4%AB%93%DA%F9%F9 Oracle epicsony.world epic %9A%1B%E59%B0X%82u %F5%CA%C4%AB%93%DA%F9%F9 Oracle epicsony.world epicsony.world %9A%1B%E59%B0X%82u %F5%CA%C4%AB%93%DA%F9%F9 Oracle epicsony.world epic %9A%1B%E59%B0X%82u %F5%CA%C4%AB%93%DA%F9%F9 Oracle epicsony.world epicsony.world %9A%1B%E59%B0X%82u %F5%CA%C4%AB%93%DA%F9%F9 Diana King

<@ROWS> " TARGET="dright">.gif" border=0>
]]> Diana King

<@ROWS> <@IF "<@CURROW>=1"> <@COL 3>

<@IF "<@VAR gTrackid>=<@COL 6>"><@ELSE>
<@IFEMPTY <@COL 15>><@ELSE> <@COL 7>. <@COL 8> <@IFEMPTY <@COL 9>><@ELSE>
<@ASSIGN gTrackID <@COL 6>> <@IFEMPTY <@COL 9>><@ELSE> <@COL 12>   <@ASSIGN gTrackID>

]]> Diana King
<@COL 1>

<@COL 2 ENCODING=NONE>

BACK

]]> Diana King ]]>