select to_char(sysdate,'Mon-YY') as this_month from dual select distinct to_char(event_date,'Mon-YY') as this_month from event where event_date > sysdate - 220 order by to_date ('01' || this_month,'DD-Mon-YY')

Select Month to Display

#months.this_month#    
Live in Studio A Performances
select lisa_id, to_char(event_date,'Day') as event_day, to_char(event_date,'Mon-dd') as clean_event_date, event_date, to_char(start_time,'hh:mi AM') as start_time, to_char(end_time,'hh:mi AM') as end_time, performer,genre,comments from event where to_char(event_date,'Mon-YY') = '#URL.filter#' order by event_date, start_time
Date Time Performer Genre Info
#display.event_day#
#display.clean_event_date# 		#display.start_time# -
#display.end_time# 		#display.performer# #display.genre# #display.comments#

 Are you interested in getting booked for a Live in Studio A Performance? Then contact lisa@kdvs.org with all your information and be prepared to send in a demo CD if necessary.

 Has your band been booked and confirmed for Live in Studio A and you need instructions?