|
|
SELECT
|
|
|
t.id shixun_id,
|
|
|
t.NAME shixun_name,
|
|
|
CONCAT(t3.lastname,'',t3.firstname) AS 'teacher_name',
|
|
|
t6.name AS 'school_name',
|
|
|
t.created_at,
|
|
|
t.updated_at,
|
|
|
t.visits,
|
|
|
t.identifier,
|
|
|
t.language,
|
|
|
t.myshixuns_count,
|
|
|
t.challenges_count,
|
|
|
t.averge_star,
|
|
|
t.users_count,
|
|
|
t.initiative_study_num,
|
|
|
t.spoc_study_num,
|
|
|
t1.shixun_tag,
|
|
|
t2.description,
|
|
|
t2.propaedeutics
|
|
|
FROM
|
|
|
`shixuns` t
|
|
|
LEFT JOIN (
|
|
|
SELECT
|
|
|
shixun_id,
|
|
|
GROUP_CONCAT(shixun_tags.`name` SEPARATOR '\t') AS 'shixun_tag'
|
|
|
FROM `shixun_tags`
|
|
|
GROUP BY shixun_id) t1
|
|
|
ON
|
|
|
t1.shixun_id = t.id
|
|
|
LEFT JOIN (
|
|
|
SELECT
|
|
|
shixun_id,
|
|
|
GROUP_CONCAT(`shixun_infos`.`propaedeutics` SEPARATOR '\t') AS 'propaedeutics',
|
|
|
GROUP_CONCAT(`shixun_infos`.`description` SEPARATOR '\t') AS 'description'
|
|
|
FROM
|
|
|
`shixun_infos`
|
|
|
GROUP BY shixun_id) t2
|
|
|
ON
|
|
|
t.id = t2.shixun_id
|
|
|
LEFT JOIN (
|
|
|
SELECT
|
|
|
t5.name, t4.`shixun_id`
|
|
|
FROM
|
|
|
shixun_schools t4
|
|
|
LEFT JOIN
|
|
|
schools t5
|
|
|
ON t5.id = t4.`school_id`
|
|
|
)t6
|
|
|
ON t6.shixun_id = t.id
|
|
|
|
|
|
LEFT JOIN
|
|
|
users t3
|
|
|
ON
|
|
|
t.user_id = t3.id
|
|
|
WHERE t.hidden != 1
|
|
|
AND t.status = 2
|
|
|
AND t.name NOT IN (
|
|
|
'测试',
|
|
|
'测试测试',
|
|
|
'测试实训',
|
|
|
'测试一下！',
|
|
|
'测试课实训',
|
|
|
'测试一下',
|
|
|
'测试1',
|
|
|
'测试2',
|
|
|
'测试场试车',
|
|
|
'测试学习',
|
|
|
'测试题目',
|
|
|
'测试用项目',
|
|
|
'测试题目',
|
|
|
'测试 2个实训项目',
|
|
|
'测试01',
|
|
|
'测试02',
|
|
|
'测试04',
|
|
|
'测试05',
|
|
|
'测试11',
|
|
|
'测试22',
|
|
|
'测试77',
|
|
|
'测试88',
|
|
|
'测试999',
|
|
|
'测试cyy',
|
|
|
'测试22222222',
|
|
|
'测试99999',
|
|
|
'测试x',
|
|
|
'测试一轮',
|
|
|
'测试一：事务',
|
|
|
'测试三',
|
|
|
'测试二',
|
|
|
'测试刷新成绩',
|
|
|
'测试实训--txt',
|
|
|
'测试实训项目',
|
|
|
'测试实训题',
|
|
|
'测试实践课程20210329',
|
|
|
'测试实践项目被引用后，改名字——改名字啦~',
|
|
|
'测试用',
|
|
|
'测试有无',
|
|
|
'测试项目',
|
|
|
'测试作业',
|
|
|
'测试二 python编程',
|
|
|
'测试基础',
|
|
|
'测试测试测试测试测试测试测试测试',
|
|
|
'测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试',
|
|
|
'测试用',
|
|
|
'测试项目',
|
|
|
'测试项目1',
|
|
|
'测试重复做实训作业',
|
|
|
'测试项目名称',
|
|
|
'测试项目复制功能',
|
|
|
'测试题',
|
|
|
'测试题一',
|
|
|
'测试题三',
|
|
|
'测试题二',
|
|
|
'测试专用',
|
|
|
'测试程序',
|
|
|
'测试长名称测试长名称-测试长名称-测试长名称-测试长名称-测试长名称-测试长名称-测试长名称测试长名称测试长名称测试长名',
|
|
|
'测试在云上实验室新建的实训，在主站上是否显示？',
|
|
|
'测试2-计数器的应用（SystemVerilog）',
|
|
|
'测试上传',
|
|
|
'测试模版问题',
|
|
|
'测试输入',
|
|
|
'测试lab',
|
|
|
'测试实验',
|
|
|
'test',
|
|
|
'Test',
|
|
|
'实训项目',
|
|
|
'java',
|
|
|
'cesss',
|
|
|
'cnn',
|
|
|
'helloworld',
|
|
|
'spark.ml',
|
|
|
'c+++++++',
|
|
|
'asd',
|
|
|
'fewa',
|
|
|
'aaaa',
|
|
|
'hallo',
|
|
|
'ji',
|
|
|
'QQ、',
|
|
|
'aa',
|
|
|
'xx',
|
|
|
'ddd',
|
|
|
'd',
|
|
|
'q',
|
|
|
'HHC',
|
|
|
'jjj',
|
|
|
'aaa',
|
|
|
'xs',
|
|
|
'shixun_test',
|
|
|
'ccc',
|
|
|
'html',
|
|
|
'qzks',
|
|
|
'dddd',
|
|
|
'py',
|
|
|
'js',
|
|
|
'PY',
|
|
|
'vvv',
|
|
|
'impala',
|
|
|
'shixun',
|
|
|
'dd',
|
|
|
'safaf',
|
|
|
'list',
|
|
|
'ceshi',
|
|
|
'TypeSet_TEST',
|
|
|
'jupyter-jzx',
|
|
|
'Sss',
|
|
|
'xcd',
|
|
|
'jpt',
|
|
|
'qq',
|
|
|
'cxunlin'
|
|
|
'gre',
|
|
|
'casL',
|
|
|
'where',
|
|
|
'test_script',
|
|
|
'jupyter',
|
|
|
'git',
|
|
|
'hello',
|
|
|
'asda',
|
|
|
'ttt',
|
|
|
'c',
|
|
|
'dsf',
|
|
|
'Penalty',
|
|
|
'Hello,world.',
|
|
|
'aaaaaaaaaaaaaaaa',
|
|
|
'nmap',
|
|
|
'unitytest',
|
|
|
'dwd',
|
|
|
'syC#',
|
|
|
'rcore_tutorial',
|
|
|
'android-vnc-jzx',
|
|
|
'jioaben',
|
|
|
'testprint',
|
|
|
'print_test',
|
|
|
'Output',
|
|
|
'xutest',
|
|
|
'lmtest',
|
|
|
'testtest',
|
|
|
'name',
|
|
|
'teast',
|
|
|
'hello-flat',
|
|
|
'abc',
|
|
|
'lmTest',
|
|
|
'hj',
|
|
|
's',
|
|
|
'ttest',
|
|
|
'shishi',
|
|
|
'JavaLmTest',
|
|
|
'jupyter-gpu-jzx',
|
|
|
'lj',
|
|
|
'ddddddddddddddddddddddddd',
|
|
|
'FengWo',
|
|
|
'ProbePhishing',
|
|
|
'/../../../../../../../../../../../../boot.ini',
|
|
|
'/../../../../../../../../../../../../winnt/win.ini',
|
|
|
'/../../../../../../../../../../../../windows/win.ini',
|
|
|
'&&id',
|
|
|
'id',
|
|
|
'\..\..\..\..\..\..\..\..\..\..\..\..\boot.ini',
|
|
|
'\..\..\..\..\..\..\..\..\..\..\..\..\winnt\win.ini',
|
|
|
'\..\..\..\..\..\..\..\..\..\..\..\..\windows\win.ini',
|
|
|
'\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\boot.ini',
|
|
|
'\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\winnt\\win.ini',
|
|
|
'\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\windows\\win.ini',
|
|
|
'nan',
|
|
|
'"',
|
|
|
'\"',
|
|
|
't',
|
|
|
'eeee',
|
|
|
'classify',
|
|
|
'web',
|
|
|
'B',
|
|
|
'Q-DMS-Weathe',
|
|
|
'djangorest',
|
|
|
'restdemo',
|
|
|
'globe',
|
|
|
'HTML',
|
|
|
'Control',
|
|
|
'image',
|
|
|
'eterhrh',
|
|
|
'rehsrjssj',
|
|
|
'string',
|
|
|
'Hello',
|
|
|
'sfsfdsf',
|
|
|
'fd',
|
|
|
'jsp',
|
|
|
'AW',
|
|
|
'e',
|
|
|
'kk',
|
|
|
'Android',
|
|
|
'android',
|
|
|
'hi',
|
|
|
'kfka',
|
|
|
'CA',
|
|
|
'sss',
|
|
|
'xho',
|
|
|
'DAS',
|
|
|
'SQL',
|
|
|
'alu',
|
|
|
'LX',
|
|
|
'sad',
|
|
|
'AAA',
|
|
|
'tmp',
|
|
|
'asp.net',
|
|
|
'JavaTest',
|
|
|
'llll',
|
|
|
'a+b',
|
|
|
'ffffff',
|
|
|
'sdfsdfsd',
|
|
|
'asdf',
|
|
|
'efgf',
|
|
|
'```',
|
|
|
'MyBatis'
|
|
|
'bochs',
|
|
|
'xunizuo',
|
|
|
'test-wps',
|
|
|
'sql',
|
|
|
'FNN',
|
|
|
'sxzDs',
|
|
|
'mmm',
|
|
|
'Ctest',
|
|
|
'C',
|
|
|
'Ctestasdf',
|
|
|
'dynet',
|
|
|
'a',
|
|
|
'qwweq',
|
|
|
'hello,world',
|
|
|
'ARM',
|
|
|
'fff',
|
|
|
'zxz',
|
|
|
'cpp.first',
|
|
|
'myspringchen',
|
|
|
'w',
|
|
|
'tes',
|
|
|
'dsag',
|
|
|
'tyjturteu',
|
|
|
'ACO',
|
|
|
'python-hello',
|
|
|
'testmake',
|
|
|
'bash',
|
|
|
'python-test',
|
|
|
'ss',
|
|
|
'wusuowei',
|
|
|
'ASDAASD',
|
|
|
'Lableme',
|
|
|
'A',
|
|
|
'EduCoder',
|
|
|
'test-VSCode',
|
|
|
'test-c',
|
|
|
'hhhtest',
|
|
|
'newOCR',
|
|
|
'ssssssss',
|
|
|
'sssss',
|
|
|
'aaaaaa',
|
|
|
'demo',
|
|
|
'dssdf',
|
|
|
'eee',
|
|
|
'ww',
|
|
|
'admin',
|
|
|
'flume',
|
|
|
'DD',
|
|
|
'testvi',
|
|
|
'qqq',
|
|
|
'testjava',
|
|
|
'qw',
|
|
|
'qimokaoshi',
|
|
|
'QQ',
|
|
|
'linux',
|
|
|
'testju',
|
|
|
'fdsf',
|
|
|
'CNN',
|
|
|
'xxx',
|
|
|
'GAng',
|
|
|
'gan',
|
|
|
'wqq',
|
|
|
'hu',
|
|
|
'dfds',
|
|
|
'Y',
|
|
|
'gghh',
|
|
|
'verilog',
|
|
|
'XXX',
|
|
|
'sdf',
|
|
|
'Pig',
|
|
|
'Ashman',
|
|
|
'Hello,World!',
|
|
|
'ffffda',
|
|
|
'hikhik',
|
|
|
'asdad',
|
|
|
'keke',
|
|
|
'sdsdf',
|
|
|
'cxd',
|
|
|
'ide',
|
|
|
'user',
|
|
|
'aaaaa',
|
|
|
'ruby',
|
|
|
'l',
|
|
|
'umi',
|
|
|
'testczd',
|
|
|
'ds',
|
|
|
'zsw',
|
|
|
'ces',
|
|
|
'JavaWeb',
|
|
|
'ECharts',
|
|
|
'grad-cam',
|
|
|
'hash',
|
|
|
'TestDir',
|
|
|
'sfsfsdf',
|
|
|
'DM',
|
|
|
'sdfsf',
|
|
|
'test-jupyterlab',
|
|
|
'led',
|
|
|
'svm',
|
|
|
'qqqq',
|
|
|
'test-jupyter-lab',
|
|
|
'c++',
|
|
|
'pygame',
|
|
|
'fh',
|
|
|
'dsajkfdaslk',
|
|
|
'sfdsfsa',
|
|
|
'vnc',
|
|
|
'oop',
|
|
|
'。',
|
|
|
'.',
|
|
|
'Webview',
|
|
|
'tangzonghao',
|
|
|
'DeepDream',
|
|
|
'qwer',
|
|
|
'testlab',
|
|
|
'JasonProject',
|
|
|
'mat',
|
|
|
'rpc',
|
|
|
'kjkkhk',
|
|
|
'dsgdasgdasg',
|
|
|
'gui-test',
|
|
|
'kali',
|
|
|
'Eightpuzzle',
|
|
|
'jjh',
|
|
|
'dada',
|
|
|
'dadda',
|
|
|
'wwerer',
|
|
|
'AOP',
|
|
|
'IoC',
|
|
|
'SOFABoot',
|
|
|
'ts',
|
|
|
'sdsd',
|
|
|
'asfsaf',
|
|
|
'lnux',
|
|
|
'WebA',
|
|
|
'Python-hk',
|
|
|
'apache',
|
|
|
'sdafsaafa',
|
|
|
'RDD',
|
|
|
'wefsf',
|
|
|
'ff',
|
|
|
'KinD',
|
|
|
'New',
|
|
|
'dense',
|
|
|
'AAAs',
|
|
|
'ttst',
|
|
|
'ccxz',
|
|
|
'realm',
|
|
|
'xunhuanq',
|
|
|
'RISC-V',
|
|
|
'tas',
|
|
|
'zzgs-SQLServer',
|
|
|
'aeqwfd',
|
|
|
'wetyjg',
|
|
|
'jljl',
|
|
|
'asfda',
|
|
|
'MatthewXY',
|
|
|
'Nie',
|
|
|
'BPF',
|
|
|
're',
|
|
|
'ThreeJs',
|
|
|
'my',
|
|
|
'ThreeJsTest',
|
|
|
'gpu',
|
|
|
'ui',
|
|
|
'asdasd',
|
|
|
'aaaaaaa',
|
|
|
'sadasds',
|
|
|
'Noriko',
|
|
|
'qwe',
|
|
|
'nt',
|
|
|
'qz',
|
|
|
'iwqyeuwggyjiwjijiw',
|
|
|
'qewqe',
|
|
|
'animal',
|
|
|
'testcuda'
|
|
|
'Complex',
|
|
|
'plotly',
|
|
|
'asgiah'
|
|
|
'feature',
|
|
|
'ssnn',
|
|
|
'GSiuxvusabxasxiUASHsyd',
|
|
|
'duwei',
|
|
|
'chedaolab',
|
|
|
'aide',
|
|
|
'saxsxd',
|
|
|
'asasd',
|
|
|
'sax',
|
|
|
'testfork',
|
|
|
'testlq',
|
|
|
'JUPYTERNOT',
|
|
|
'ISE',
|
|
|
'dad'
|
|
|
'ocr',
|
|
|
'ocrr',
|
|
|
'ocrrr',
|
|
|
'ocrrrr',
|
|
|
'ocrrrrr',
|
|
|
'ocrrrrrrr',
|
|
|
'ghjgj',
|
|
|
'gfhf',
|
|
|
'dadawda',
|
|
|
'ao-lab',
|
|
|
'wwtest',
|
|
|
'testList'
|
|
|
)
|
