SELECT a.abstract_id as main_id, a.abstract_type_id, a.abstract_title, ab.Author_Status, au.author_id, au.prefix, au.first_name, au.middle_name, au.last_name, au.suffix, au.affiliation, at.abstract_type, d.day, r.room_name, aps.board_number, ps.poster_session_id, ps.poster_session_name, ps.session_roman_numeral, sc.Schedule_ID, sc.Schedule_Start_Time as Schedule_Start_Time, sc.Schedule_End_Time as Schedule_End_Time FROM ((((((((((Abstracts a LEFT OUTER JOIN Assoc_Author_Abstract ab ON a.Abstract_ID = ab.Abstract_ID) LEFT OUTER JOIN Authors au ON ab.Author_ID = au.Author_ID) LEFT OUTER JOIN Abstract_Type at ON a.Abstract_Type_ID = at.Abstract_Type_ID) LEFT OUTER JOIN Assoc_Subject_Area_Abstract asa ON a.Abstract_ID = asa.Abstract_ID) LEFT OUTER JOIN Subject_Area sa ON asa.Subject_Area_ID = sa.Subject_Area_ID) LEFT OUTER JOIN Schedule sc ON a.Abstract_ID = sc.Abstract_ID) LEFT OUTER JOIN Day d ON sc.Day_ID = d.Day_ID) LEFT OUTER JOIN Room r ON sc.Room_ID = r.Room_ID) LEFT OUTER JOIN Assoc_Poster_Sessions aps ON a.Abstract_ID = aps.Abstract_ID) LEFT OUTER JOIN Poster_Sessions ps ON aps.Poster_Session_ID = ps.Poster_Session_ID) WHERE (a.Abstract_Review_Status = 'accepted' or a.internal_abstract = 1) AND a.Event_ID = And not ab.Author_Type_ID = 10 AND (asa.Subject_Order = 1 or a.internal_abstract = 1) AND (sc.Schedule_ID <> 0 or ps.poster_session_id <> 0) AND sc.Schedule_ID IN () OR a.Abstract_ID IN () UNION SELECT a.abstract_id as main_id, a.abstract_type_id, a.abstract_title, ab.Author_Status, au.author_id, au.prefix, au.first_name, au.middle_name, au.last_name, au.suffix, au.affiliation, at.abstract_type, pss.day, '', aps.board_number, ps.poster_session_id, ps.poster_session_name, ps.session_roman_numeral, pss.Schedule_ID, pss.Schedule_Start_Time as Schedule_Start_Time, pss.Schedule_End_Time as Schedule_End_Time FROM ((((((((((Abstracts a LEFT OUTER JOIN Assoc_Author_Abstract ab ON a.Abstract_ID = ab.Abstract_ID) LEFT OUTER JOIN Authors au ON ab.Author_ID = au.Author_ID) LEFT OUTER JOIN Abstract_Type at ON a.Abstract_Type_ID = at.Abstract_Type_ID) LEFT OUTER JOIN Assoc_Subject_Area_Abstract asa ON a.Abstract_ID = asa.Abstract_ID) LEFT OUTER JOIN Subject_Area sa ON asa.Subject_Area_ID = sa.Subject_Area_ID) LEFT OUTER JOIN Schedule sc ON a.Abstract_ID = sc.Abstract_ID) LEFT OUTER JOIN Day d ON sc.Day_ID = d.Day_ID) LEFT OUTER JOIN Room r ON sc.Room_ID = r.Room_ID) LEFT OUTER JOIN Assoc_Poster_Sessions aps ON a.Abstract_ID = aps.Abstract_ID) LEFT OUTER JOIN Poster_Sessions ps ON aps.Poster_Session_ID = ps.Poster_Session_ID) LEFT OUTER JOIN Poster_Session_Schedule pss ON ps.Poster_Session_ID = pss.Poster_Session_ID WHERE (a.Abstract_Review_Status = 'accepted' or a.internal_abstract = 1) AND a.Event_ID = And not ab.Author_Type_ID = 10 AND (asa.Subject_Order = 1 or a.internal_abstract = 1) AND pss.Event_ID = AND sc.Schedule_ID IN () OR a.Abstract_ID IN () UNION SELECT a.poster_session_id as main_id, '9999', '', '', '', '', '', '', '', '', '', '', d.day, r.room_name, '', '', a.poster_session_name, '', b.Schedule_ID, b.Schedule_Start_Time as Schedule_Start_Time, b.Schedule_End_Time as Schedule_End_Time FROM ((Poster_Sessions a LEFT OUTER JOIN Schedule b ON a.Poster_Session_ID = b.Poster_Session_ID) LEFT OUTER JOIN Day d ON b.Day_ID = d.Day_ID) LEFT OUTER JOIN Room r ON b.Room_ID = r.Room_ID WHERE a.event_id = AND b.Schedule_ID IN () OR b.Abstract_ID IN () ORDER BY d.day, schedule_start_time, a.abstract_title, main_id, ab.Author_Status, au.Last_Name, au.Author_ID #email_string#

Your #session.event.title# Itinerary:

<cfoutput>#session.event.title#</cfoutput> Program Book

E-mail My Itinerary

This service sends a HTML-formatted message to the e-mail address of your choice. Enter the destination e-mail address in the form below and press the "E-mail Itinerary" button.

Thank you for using this service. Your itinerary has been e-mailed to #form.email#.

Return to program book home. Return to your Itinerary.