SELECT * FROM events WHERE is_featured = 1 AND end_date > #CreateODBCDate(archive_off)# ORDER BY begin_date ASC

where : industry events + data

#title#
#DateFormat(begin_date,begin_date_format)# #to# #DateFormat(end_date,end_date_format)#
#location#
#city#, #state#