Chest

SELECT *, (SELECT GROUP_CONCAT( if(b.name_en!='TBD', if(b.country!='', CONCAT(b.name_en,' (',b.office_en,', ', b.country, ')'), CONCAT(b.name_en,' (',b.office_en,')')) ,b.name_en) order by a.sid SEPARATOR '|') FROM session_faculty_tbl a, faculty_tbl b WHERE a.faculty_sid=b.sid AND a.gubun='chair' AND b.code='icmri2024' AND a.session_sid=t1.sid) AS cname, (SELECT GROUP_CONCAT( if(b.name_en!='TBD', if(b.country!='', CONCAT(b.name_en,' (',b.office_en,', ', b.country, ')'), CONCAT(b.name_en,' (',b.office_en,')')) ,b.name_en) ORDER BY a.sid SEPARATOR '|') FROM session_faculty_tbl a, faculty_tbl b WHERE a.faculty_sid=b.sid AND a.gubun='panel' AND b.code='icmri2024' AND a.session_sid=t1.sid) AS pname FROM session_tbl t1 WHERE CODE='icmri2024' AND TYPE='1' AND viewYN='Y' AND category1='2345' ORDER BY tab ASC, (SELECT orderby FROM session_time_tbl t2 WHERE t2.tab=t1.tab AND t2.sid=t1.time) ASC

November 8 (Fri.) 14:10-15:40	MS03) Expanding the Area of Chest MR (English) Grand 1
	Chairs: Yun-Hyeon Kim (Chonnam National University Hospital, Korea) Woocheol Kwon (Ewha Womans University Seoul Hospital, Korea)
14:10-14:40	Proton MRI of the Lung	Andreas Voskrebenzev (Hannover Medical School, Germany)
14:40-15:10	MRI for the Management of Esophageal Cancer	Jooae Choe (Asan Medical Center, Korea)
15:10-15:30	A Quick and Easy Way to MR of Mediastinal Tumor	Sung Ho Hwang (Korea University Anam Hospital, Korea)
15:30-	Oral Presentation