select * from ( select a.*, rownum rnum from (select dj_name, show_name, show_occur.show_occur_id, show.show_id, to_number(to_char(show_date,'YYYYMMDD')) order_date, substr(to_char(show_date,'day'),1,3) as day, to_char(show_date,'MM/DD/YY') as show_date, to_char(schedule.start_time,'HH:Miam') start_time, to_char(schedule.end_time,'HH:Miam') as end_time, comments comments, replace(show_type.name,'Standard','') show_type, replace(show_name,'''','\''') as escaped_title from kdvs_library.show_occur show_occur, show, schedule, show_type where show_occur.show_id = show.show_id and show.show_id = schedule.show_id and show_occur.show_type = show_type.show_type_id(+) and to_date(to_char(show_date,'MM/DD/YYYY')||' '||to_char(start_time,'HH24:MI'),'MM/DD/YYYY HH24:MI') < sysdate and (show_occur.comments is not null or exists (select 1 from kdvs_library.playlist where playlist.show_occur_id =show_occur.show_occur_id)) and show.show_id = #URL.show# and (upper(dj_name || show_name || genre || comments || to_char(show_date,'MM/DD/YYYY')) like upper('%#URL.filter#%') or exists (select 1 from kdvs_library.playlist where playlist.show_occur_id = SHOW_OCCUR.show_occur_id and upper(playlist.artist || playlist.song || album || playlist.comments || playlist.label) like upper('%#URL.filter#%'))) order by order_date desc, start_time desc) a where rownum <= #endrow# ) where rnum >= #URL.start#
Date Time DJ Name Show Name Show Description
#show.day#
#show.show_date# 		#show.start_time#
#show.end_time# 		#show.dj_name# #show.show_name#
 #show.show_type#: #show.comments# 
(view playlist)

<<More Past Shows <<More Past Shows     Back>> Back>> Upcoming Shows on KDVS >> Upcoming Shows on KDVS >>