Pediatric

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='2351' 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.) 08:30-10:00	MS02) Pediatric Session (English) Grand 2+3
	Chairs: Bo-Kyung Je (Korea University Ansan Hospital, Korea) Jae-Yeon Hwang (Seoul National University Children's Hospital, Korea)
08:30-09:00	Pediatric MR Urography	Joo Y. Cho (Emory University School of Medicine/ Children’s Healthcare of Atlanta, USA)
09:00-09:30	Pediatric Liver MRI for Diffuse Liver Disease	Young Hun Choi (Seoul National University Hospital, Korea)
09:30-	Oral Presentation