{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["SQL Results","SQL Statement"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"SQL Results","index":0,"n_rows":64,"n_cols":18,"rows_kept":64,"flags":["formulas_cached_only"]}
["   ","开课单位","班级编号","NAME","上课院系数","课程号","课程名","日期","时间","教师","上课院系","上课专业","班级人数","教室1","教室2","教室3","教室4","备用考场"]
["1","大学外语部",205227,"大学基础英语-综合（Ⅲ）01班",0,"00020100C","大学基础英语-综合（Ⅲ）","2023-2-22","10:30-12:30","赵庆庆","","",46,"仙1-101","","","","仙1-302"]
["2","计算中心",203534,"Python程序设计03班",1,"00030220","Python程序设计","2023-2-24","10:00-12:00","张洁","环境学院","环境科学与工程类-2021,环境科学与工程类（环境与健康实验班）-2021",70,"基础实验楼乙107","","",""]
["44","马克思主义学院",205657,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）17班",1,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","金文","外国语学院","朝鲜语-2021,德语-2021,俄语-2021,法语-2021,日语-2021,西班牙语-2021,英语-2021",158,"仙1-108","仙1-104","","","仙1-302"]
["6","马克思主义学院",205637,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）01班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","李洪波","计算机科学与技术系","计算机（计算机与金融工程方向）-2020,计算机科学与技术-2020,计算机科学与技术（拔尖计划）-2020,信息与计算科学（强基计划）-2020",153,"仙2-207","仙2-216","","","仙1-302"]
["13","马克思主义学院",205648,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）08班",2,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","武海宝","大气科学学院,生命科学学院","大气科学-2020,生物科学（强基计划）-2020,生物科学类-2020,应用气象学-2020",151,"仙1-207","仙1-212","","","仙1-302"]
["7","马克思主义学院",205638,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）02班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","李洪波","计算机科学与技术系","计算机（计算机与金融工程方向）-2020,计算机科学与技术-2020,计算机科学与技术（拔尖计划）-2020,信息与计算科学（强基计划）-2020",148,"仙2-122","仙2-115","","","仙1-302"]
["25","马克思主义学院",205006,"中国近现代史纲要09班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","倪春纳","工程管理学院","工业工程-2021,金融工程-2021,金融工程（计算机金融实验班）-2021,自动化-2021",148,"仙1-108","仙1-104","","","仙1-302"]
["33","马克思主义学院",205839,"中国近现代史纲要17班",2,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","杨丹伟","电子科学与工程学院,马克思主义学院","电子信息科学与技术-2021,电子信息类-2021,集成电路设计与集成系统-2021,马克思主义理论-2021,通信工程-2021,微电子科学与工程-2021",147,"仙1-206","仙1-216","","","仙1-302"]
["48","马克思主义学院",205849,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）21班",1,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","夏玉凡","电子科学与工程学院","电子信息科学与技术-2021,电子信息类-2021,集成电路设计与集成系统-2021,通信工程-2021,微电子科学与工程-2021",141,"仙1-321","仙1-320","","","仙1-302"]
["47","马克思主义学院",205848,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）20班",1,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","夏玉凡","电子科学与工程学院","电子信息科学与技术-2021,电子信息类-2021,集成电路设计与集成系统-2021,通信工程-2021,微电子科学与工程-2021",140,"仙1-317","仙1-319","","","仙1-302"]
["34","马克思主义学院",205840,"中国近现代史纲要18班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","杨丹伟","电子科学与工程学院","电子信息科学与技术-2021,电子信息类-2021,集成电路设计与集成系统-2021,通信工程-2021,微电子科学与工程-2021",138,"仙1-207","仙1-212","","","仙1-302"]
["31","马克思主义学院",205043,"中国近现代史纲要15班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","谢任","商学院","财务管理-2021,工商管理-2021,工商管理（人力资源管理方向）-2021,会计学-2021",136,"仙1-320","仙1-321","","","仙1-302"]
["30","马克思主义学院",205040,"中国近现代史纲要14班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","周瑞瑞","现代工程与应用科学学院","材料化学-2021,材料物理-2021,光电信息科学与工程-2021,生物医学工程-2021,新能源科学与工程-2021",129,"仙2-303","仙2-304","","","仙1-302"]
["37","马克思主义学院",205607,"马克思主义基本原理17班",1,"00000110","马克思主义基本原理","2023-2-23","10:30-12:30","黄秋霞","数学系","数学（拔尖计划）-2021,数学类-2021,数学与应用数学（强基计划）-2021",125,"仙2-122","","","","仙1-302"]
["19","马克思主义学院",204868,"中国近现代史纲要04班",2,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","林棵","环境学院,建筑与城市规划学院","城乡规划-2021,环境科学与工程类-2021,环境科学与工程类（环境与健康实验班）-2021,建筑类（建筑与规划实验班）-2021,建筑学-2021",120,"仙2-207",null,"","","仙1-302"]
["29","马克思主义学院",205039,"中国近现代史纲要13班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","周瑞瑞","化学化工学院","化学-2021,化学（化学生物学）-2021,化学（强基计划）-2021,应用化学-2021",120,"仙2-305","仙2-306","","","仙1-302"]
["46","马克思主义学院",205663,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）19班",1,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","王亚茹","法学院","法学-2021,法学（运动员班）-2021",116,"仙2-112","仙2-110","","","仙1-302"]
["20","马克思主义学院",204908,"中国近现代史纲要02班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","黄骏","计算机科学与技术系","计算机科学与技术-2021,信息与计算科学（强基计划）-2021",113,"仙2-213","仙2-214","","","仙1-302"]
["32","马克思主义学院",205055,"中国近现代史纲要16班",2,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","谢任","匡亚明学院,商学院","电子商务-2021,理科强化班-2021,市场营销-2021,英才计划（生命科学班）-2021,英才计划（天文）-2021",113,"仙1-203","仙1-204","","","仙1-302"]
["43","马克思主义学院",205656,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）16班",3,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","程文侠","国际关系学院,海外教育学院,文学院","国际政治-2021,汉语国际教育-2021,汉语言文学-2021,汉语言文学（拔尖计划）-2021,汉语言文学（古文字学方向）（强基计划）-2021,戏剧影视文学-2021",112,"仙1-201","仙1-202","","","仙1-302"]
["18","马克思主义学院",204867,"中国近现代史纲要03班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","黄骏","计算机科学与技术系","计算机科学与技术-2021,信息与计算科学（强基计划）-2021",111,"仙2-211","仙2-212","","","仙1-302"]
["12","马克思主义学院",205647,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）07班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","丁蕖","匡亚明学院","理科强化班-2020",110,"逸B-105","逸B-104","","","仙1-302"]
["28","马克思主义学院",205035,"中国近现代史纲要12班",2,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","熊秋良","地理与海洋科学学院,地球科学与工程学院","地理科学（拔尖计划）-2021,地理科学类-2021,地质学（拔尖计划）-2021,地质学（生物演化与环境方向）-2021,地质学类-2021",109,"仙2-313","仙2-314","","","仙1-302"]
["45","马克思主义学院",205661,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）18班",1,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","金文","新闻传播学院","新闻传播学类-2021,新闻学（传媒实验班）-2021",109,"仙1-101","仙1-102","","","仙1-302"]
["36","马克思主义学院",206182,"中国近现代史纲要20班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","谢任","匡亚明学院","理科强化班-2021,英才计划（化学班）-2021,英才计划（计算机班）-2021",108,"仙1-317","仙1-319","","","仙1-302"]
["24","马克思主义学院",205002,"中国近现代史纲要08班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","王楠","人工智能学院","人工智能-2021",102,"仙2-112","仙2-110","","","仙1-302"]
["42","马克思主义学院",205655,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）15班",2,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","程文侠","历史学院,社会学院","考古学-2021,考古学（文物鉴定方向）-2021,历史学-2021,社会工作-2021,社会学-2021,应用心理学-2021",102,"仙1-203","仙1-204","","","仙1-302"]
["5","马克思主义学院",205879,"思想道德修养与法律基础02班",1,"00000020","思想道德修养与法律基础","2023-2-23","8:00-10:00","陆杰峰","电子科学与工程学院","电子信息科学与技术-2020,集成电路设计与集成系统-2020,通信工程-2020,微电子科学与工程-2020",101,"仙1-109","","","","仙1-302"]
["23","马克思主义学院",205000,"中国近现代史纲要07班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","王楠","人工智能学院","人工智能-2020",101,"仙2-122","","","","仙1-302"]
["15","马克思主义学院",205652,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）12班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","甘季国","商学院","财务管理-2020,工商管理-2020,工商管理（人力资源管理方向）-2020",100,"仙2-211","仙2-212","","","仙1-302"]
["17","马克思主义学院",204865,"中国近现代史纲要01班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","黄骏","医学院","口腔医学-2021,临床医学-2021",100,"仙2-215","仙2-218","","","仙1-302"]
["35","马克思主义学院",205850,"中国近现代史纲要19班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","倪春纳","生命科学学院","生物科学（强基计划）-2021,生物科学类-2021",100,"仙1-109","","","","仙1-302"]
["21","马克思主义学院",204996,"中国近现代史纲要05班",2,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","熊秋良","海外教育学院,信息管理学院","编辑出版学-2021,档案学-2021,汉语国际教育-2021,图书馆学-2021,信息管理与信息系统-2021",99,"仙2-318","仙2-319","","","仙1-302"]
["22","马克思主义学院",204998,"中国近现代史纲要06班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","王楠","大气科学学院","大气科学（拔尖计划）-2021,大气科学类-2021",97,"仙2-105","仙2-104","","","仙1-302"]
["14","马克思主义学院",205649,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）09班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","武海宝","信息管理学院","编辑出版学-2020,档案学-2020,图书馆学-2020,信息管理与信息系统-2020",95,"仙1-213","仙1-216","","","仙1-302"]
["11","马克思主义学院",205646,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）06班",2,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","丁蕖","国际关系学院,政府管理学院","国际政治-2020,劳动与社会保障-2020,行政管理-2020,行政管理（运动员班）-2020,政治学与行政学-2020",94,"逸A-117",null,"","","仙1-302"]
["41","马克思主义学院",205654,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）14班",2,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","甘季国","哲学系（宗教学系）,政府管理学院","劳动与社会保障-2021,行政管理-2021,哲学-2021,哲学（拔尖计划）-2021,哲学（强基计划）-2021,政治学与行政学-2021",93,"仙2-318","仙2-319","","","仙1-302"]
["39","马克思主义学院",205650,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）10班",1,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","高静","物理学院","物理学（拔尖计划）-2021,物理学（强基计划）-2021,物理学类-2021",92,"仙2-215","仙2-218","","","仙1-302"]
["4","马克思主义学院",205878,"思想道德修养与法律基础01班",1,"00000020","思想道德修养与法律基础","2023-2-23","8:00-10:00","陆杰峰","电子科学与工程学院","电子信息科学与技术-2020,集成电路设计与集成系统-2020,通信工程-2020,微电子科学与工程-2020",89,"仙1-108（不要坐在靠门一列）","","","","仙1-302"]
["8","马克思主义学院",205643,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）03班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","沈伯平","商学院","国际经济与贸易-2020,经济学-2020,经济学（产业经济方向）-2020",84,"仙2-102","仙2-104","","","仙1-302"]
["40","马克思主义学院",205651,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）11班",1,"00000130A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","高静","物理学院","物理学（拔尖计划）-2021,物理学（强基计划）-2021,物理学类-2021",83,"仙2-116","仙2-117","","","仙1-302"]
["16","马克思主义学院",205653,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）13班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","甘季国","商学院","电子商务-2020,会计学-2020,市场营销-2020",77,"仙2-314","仙2-316","","","仙1-302"]
["10","马克思主义学院",205645,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）05班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","丁蕖","工程管理学院","工业工程-2020,金融工程-2020,自动化-2020",74,"逸B-101",null,"","","仙1-302"]
["9","马克思主义学院",205644,"毛泽东思想和中国特色社会主义理论体系概论（理论部分）04班",1,"00000030A","毛泽东思想和中国特色社会主义理论体系概论（理论部分）","2023-2-23","14:00-16:00","沈伯平","商学院","保险学-2020,金融工程-2020,金融学-2020",43,"仙2-105","","","","仙1-302"]
["3","马克思主义学院",205868,"马克思主义基本原理概论01班",1,"00000010","马克思主义基本原理概论","2023-2-23","10:30-12:30","尤歆惟","大气科学学院","大气科学-2020,应用气象学-2020",39,"仙2-110","","","","仙1-302"]
["26","马克思主义学院",205030,"中国近现代史纲要10班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","吴盛杰","软件学院","软件工程-2021",35,"仙2-117","","","","仙1-302"]
["27","马克思主义学院",205034,"中国近现代史纲要11班",1,"00000041","中国近现代史纲要","2023-2-23","16:30-18:30","吴盛杰","软件学院","软件工程-2021",31,"仙2-116","","","","仙1-302"]
["38","马克思主义学院",205869,"马克思主义基本原理12班",1,"00000110","马克思主义基本原理","2023-2-23","10:30-12:30","尤歆惟","天文与空间科学学院","天文学类-2021",30,"仙2-112（不要坐在靠门一列）","","","","仙1-302"]
["49","数学系",203567,"概率论与数理统计05班",4,"11100200","概率论与数理统计","2023-2-21","16:30-18:30","赵进","大气科学学院,地球科学与工程学院,计算机科学与技术系,建筑与城市规划学院","城乡规划-2021,大气科学（拔尖计划）-2021,大气科学类-2021,地质学类-2021,计算机科学与技术-2021,建筑类（建筑与规划实验班）-2021",228,"仙1-201","仙1-202","仙1-203","仙1-204","仙1-302"]
["50","数学系",203681,"概率论与数理统计01班",1,"22010210","概率论与数理统计","2023-2-21","16:30-18:30","傅冬生","计算机科学与技术系","计算机科学与技术-2020",187,"仙1-319\n","仙1-320",null,null,"仙1-302"]
["51","数学系",203569,"概率论与数理统计07班",1,"11100200","概率论与数理统计","2023-2-21","16:30-18:30","卫然","计算机科学与技术系","计算机科学与技术-2021,信息与计算科学（强基计划）-2021",180,"仙1-206\n","仙1-207","","","仙1-302"]
["52","数学系",203554,"线性代数(第一层次)09班",1,"00010011C","线性代数(第一层次)","2023-2-21","14:00-16:00","朱晓胜","电子科学与工程学院","电子信息科学与技术-2021,电子信息类-2021,集成电路设计与集成系统-2021,通信工程-2021,微电子科学与工程-2021",144,"仙1-109","仙1-101",null,null,"仙1-302"]
["53","数学系",203558,"线性代数(第一层次)13班",3,"00010011C","线性代数(第一层次)","2023-2-21","14:00-16:00","王征宇","大气科学学院,地理与海洋科学学院,地球科学与工程学院","大气科学（拔尖计划）-2021,大气科学类-2021,地理科学（拔尖计划）-2021,地质学（拔尖计划）-2021,地质学（生物演化与环境方向）-2021,地质学类-2021",138,"仙1-320","仙1-321",null,null,"仙1-302"]
["54","数学系",203555,"线性代数(第一层次)10班",1,"00010011C","线性代数(第一层次)","2023-2-21","14:00-16:00","于立","电子科学与工程学院","电子信息科学与技术-2021,电子信息类-2021,集成电路设计与集成系统-2021,通信工程-2021,微电子科学与工程-2021",136,"仙1-108\n","仙1-102",null,null,"仙1-302"]
["55","数学系",203556,"线性代数(第一层次)11班",1,"00010011C","线性代数(第一层次)","2023-2-21","14:00-16:00","邵荣","软件学院","软件工程-2021",134,"仙1-206\n","仙1-212","","","仙1-302"]
["56","数学系",203557,"线性代数(第一层次)12班",1,"00010011C","线性代数(第一层次)","2023-2-21","14:00-16:00","邵荣","软件学院","软件工程-2021",133,"仙1-207\n","仙1-216",null,null,"仙1-302"]
["57","数学系",203563,"概率论与数理统计01班",1,"11100200","概率论与数理统计","2023-2-21","16:30-18:30","李春","商学院","国际经济与贸易-2021,经济学-2021,经济学（拔尖计划）-2021,经济学（产业经济方向）-2021",132,"仙1-109","仙1-103",null,null,"仙1-302"]
["58","数学系",203559,"线性代数(第一层次)14班",1,"00010011C","线性代数(第一层次)","2023-2-21","14:00-16:00","肖源明","信息管理学院","档案学-2021,信息管理与信息系统-2021",127,"仙1-319\n","仙1-317","","","仙1-302"]
["59","数学系",203565,"概率论与数理统计03班",1,"11100200","概率论与数理统计","2023-2-21","16:30-18:30","王伟","商学院","财务管理-2021,工商管理-2021,工商管理（人力资源管理方向）-2021",124,"仙1-108\n","仙1-104","","","仙1-302"]
["60","数学系",203564,"概率论与数理统计02班",1,"11100200","概率论与数理统计","2023-2-21","16:30-18:30","陶敏","商学院","保险学-2021,金融工程-2021,金融学-2021",111,"仙1-101","仙1-102","","","仙1-302"]
["61","数学系",203568,"概率论与数理统计06班",1,"11100200","概率论与数理统计","2023-2-21","16:30-18:30","卫然","现代工程与应用科学学院","材料物理-2021,光电信息科学与工程-2021,生物医学工程-2021,新能源科学与工程-2021",111,"仙1-212\n","仙1-213","","","仙1-302"]
["62","数学系",203566,"概率论与数理统计04班",1,"11100200","概率论与数理统计","2023-2-21","16:30-18:30","杨东","商学院","电子商务-2021,会计学-2021,市场营销-2021",100,"仙1-317","仙1-321","","","仙1-302"]
[null,"大学外语部",{"$nulls":4},"重修补修生（仅限住仙林校区学生）","2023-2-22","10:30-12:30",{"$nulls":3},20,"仙1-102",{"$nulls":3},"仙1-302"]

{"sheet":"SQL Statement","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["--期末考试时间安排导出\nselect distinct ca.name 开课单位,tc.id 班级编号,tc.name,(select count(distinct css.academycode) from teaching_classcourse tcc,code_speciality css where tcc.specialitycode=css.code and tcc.classid=tc.id) 上课院系数,\ntc.coursenumber 课程号,tc.coursename 课程名,er.dayval 日期,er.timeval 时间,\n(select substr(rawstrcat(distinct ttp.teachername),2,1000) from teaching_teacherplan ttp,teaching_periodplan tpp where ttp.periodplanid=tpp.id and tpp.classid=tc.id) 教师,\n(select substr(rawstrcat(distinct caa.name),2,1000) from teaching_classcourse tcc,code_speciality css,code_academy caa where css.academycode=caa.code and tcc.specialitycode=css.code and tcc.classid=tc.id) 上课院系,\n(select substr(rawstrcat(distinct css.name||'-'||tcc.grade),2,1000) from teaching_classcourse tcc,code_speciality css where tcc.specialitycode=css.code and tcc.classid=tc.id) 上课专业,\n(select count(distinct tsc.studentnumber) from teaching_studentclass tsc where tsc.classid=tc.id and tsc.electivetype<>'00') 班级人数,\nnull 教室1,null 教室2,null 教室3,null 教室4\n from teaching_class tc\n      left join code_academy ca on tc.courseacademy=ca.code,exam_result er\nwhere  tc.termcode='20221' and er.classid=tc.id\nand tc.coursenumber in ('00010011A','00010012A','00010013','00010014A','00010011C','00010011B','00010012B','00010011C','11100200','22010210','00000100','00000110','00000110','00000010','00000020','00000030A','00000130A','00000041','00030211','00030212','00030220','00030220','00020060A','00020080A','00020080B','00020070A','00020090A','00020090B','00020100A','00020110A','00020120','00020140','00020150A','00020100C','11100140C','11100140A')\nand tc.campus like '%仙林%'\n\norder by ca.name,tc.coursenumber,tc.id"]