中国教育学会2021年度教育科研中小学德育专项课题，于2021年11月启动申报工作以来，共接收课题申请136项，经评审和公示，最终确定立项专项课题20项，其中重点课题5项。现将批准立项课题予以公布（详见附件）。
附件：
中国教育学会2021年度教育科研中小学德育专项课题立项名单.xlsx
中国教育学会
2022年4月20日
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
select * from `bk_article_classify` where `id` = '118' and `is_active` = '1' and `is_delete` = '0' limit 11.08msdb_xhjy_pre| Params | |
|---|---|
| 0 | 118 |
| 1 | 1 |
| 2 | 0 |
| hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select bk_article_main.*, bk_article_detail.content, group_concat(DISTINCT bk_article_classify.name) as classnames, group_concat(DISTINCT bk_article_classify.id) as classifyid, group_concat(DISTINCT bk_article_tags.name) as tagsnames from `bk_article_main` left join `bk_article_detail` on `bk_article_main`.`id` = `bk_article_detail`.`article_id` left join `bk_article_classify_relation` on `bk_article_classify_relation`.`article_id` = `bk_article_main`.`id` left join `bk_article_classify` on `bk_article_classify_relation`.`classify_id` = `bk_article_classify`.`id` left join `bk_article_tag_relation` on `bk_article_tag_relation`.`article_id` = `bk_article_main`.`id` left join `bk_article_tags` on `bk_article_tag_relation`.`tag_id` = `bk_article_tags`.`id` where `bk_article_main`.`is_delete` = '1' and `bk_article_main`.`status` = '1' and `bk_article_main`.`id` = '3281' limit 11.79msdb_xhjy_pre| Params | |
|---|---|
| 0 | 1 |
| 1 | 1 |
| 2 | 3281 |
| hints | LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `bk_article_classify` where `is_delete` = '0' and `is_active` = '1' and `is_nav` = '1' order by `sort` desc2.22msdb_xhjy_pre| Params | |
|---|---|
| 0 | 0 |
| 1 | 1 |
| 2 | 1 |
| hints | Use SELECT * only if you need all columns from table |
select * from `bk_article_classify` where `id` = '118' and `is_active` = '1' and `is_delete` = '0' limit 1870μsdb_xhjy_pre| Params | |
|---|---|
| 0 | 118 |
| 1 | 1 |
| 2 | 0 |
| hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `bk_article_classify` where `id` = '118' and `is_active` = '1' and `is_delete` = '0' limit 1720μsdb_xhjy_pre| Params | |
|---|---|
| 0 | 118 |
| 1 | 1 |
| 2 | 0 |
| hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |
select * from `bk_article_classify` where `id` = '6' and `is_active` = '1' and `is_delete` = '0' limit 1610μsdb_xhjy_pre| Params | |
|---|---|
| 0 | 6 |
| 1 | 1 |
| 2 | 0 |
| hints | Use SELECT * only if you need all columns from tableLIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan |