Select tt.custom_label,ts.school_name,ts.test_id,ts.type_name,ts.sequence_name,ts.year_name from ods_test_sources as ts left outer join ods_test_tests as tt on (ts.test_id=tt.id and ts.dt=20180110 and tt.dt=20180110) left outer join ods_test_resources as tr on (ts.test_id=tr.test_id and tr.dt=20180110) where tr.type=1 and tt.department=1 and tt.subject_id=3 and tt.status=1 and tt.is_verify=1 and tt.empty_knowledge=0 group by tt.custom_label,ts.school_name,ts.test_id,ts.type_name,ts.sequence_name,ts.year_name
小英,试题来源,有知识点,有自定标签
最新推荐文章于 2022-08-04 11:20:56 发布