--状态：正常；审核通过；排除上传题
SELECT ShiTiALL.* 
FROM dbo.Exam_e_QuestionInfo AS ShiTiALL
INNER JOIN dbo.Exam_e_QuestionType AS LeiXingALL
ON LeiXingALL.QuestionTypeID = ShiTiALL.QuestionTypeID
WHERE 1=1
AND LeiXingALL.QuestionTypeName not LIKE '%上传%'
and q.QuestionDesc not like '%<a%'
AND ShiTiALL.Status=0--正常
AND ShiTiALL.AuditingFlag=1--审核通过;

select c.CourseCode,c.CourseName from exam_e_courseinfo c 
inner join 
( SELECT distinct q.CourseCode
FROM Exam_e_QuestionInfo AS q
INNER JOIN Exam_e_QuestionType AS t
ON t.QuestionTypeID = q.QuestionTypeID
WHERE 1=1
AND t.QuestionTypeName not LIKE '%上传%'
and q.QuestionDesc not like '%<a%'
AND q.Status=0
AND q.AuditingFlag=1
and q.OuterSystemID=3372)tm
on c.CourseCode=tm.CourseCode
where c.SystemID=3372;

select tm.* from
(select count(DISTINCT t.root_id) cc,t.CourseCode
from exam_e_coursechapter t
inner join temp_course c on t.CourseCode=c.`code`
inner join exam_e_questioninfo q on t.ChapterID=q.ChapterID
where t.OuterSystemID=3372 and t.ParentChapterlID !=0
GROUP BY t.CourseCode)
tm where tm.cc=1;

select t.ChapterID id,t.ParentChapterlID parent_id,t.root_id,t.ChapterTitle type_name
from exam_e_coursechapter t
where t.OuterSystemID=3372 and t.CourseCode='209001' and t.ParentChapterlID !=0
and EXISTS(select 1 from exam_e_questioninfo q where t.ChapterID=q.ChapterID)
order by t.OrderNumber;


http://any.cnzx.info:81/

成教考试平台的前缀

是只筛选3372系统的数据

answerType 1-单选
2-多选
3-简单文本
4-复杂文本
5-文件上传
6-英译汉
7-汉译英

1-易
3-中
5-难

题型表获取OuterSystemlD in (0,3372)就行

主观题就是简答题
填空题没有空标识当简答题处理