打开微信点击底部的“发现”，使用 “扫一扫” 即可分享到我的朋友圈。
中国教育学会
2020年5期查看目录
2020年4期查看目录
2020年3期查看目录
2020年1-2期查看目录
2019年12期查看目录
2019年11期查看目录
2019年10期查看目录
2019年9期查看目录
2019年7-8期查看目录
2019年6期查看目录
2019年5期查看目录
2019年4期查看目录
2019年3期查看目录
2019年1-2期查看目录
2018年12期查看目录
contentinfo
page
categinfo
headerObject
object
navInfo
leftNav
activeId
select * from `bk_article_classify` where `id` = '106' and `is_active` = '1' and `is_delete` = '0' limit 1
SELECT *
LIMIT
ORDER BY
select count(*) as aggregate from `bk_article_soft` left join `bk_article_soft_classify_relation` on `bk_article_soft_classify_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_classify` on `bk_article_soft_classify_relation`.`classify_id` = `bk_article_classify`.`id` left join `bk_article_tag_relation` on `bk_article_tag_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_tags` on `bk_article_tag_relation`.`tag_id` = `bk_article_tags`.`id` where `bk_article_soft`.`is_delete` = '1' and `bk_article_soft`.`status` = '1' and `bk_article_classify`.`id` = '106' group by `bk_article_soft`.`id`
select bk_article_soft.*, group_concat(DISTINCT bk_article_classify.name) as classnames, group_concat(DISTINCT bk_article_tags.name) as tagsnames from `bk_article_soft` left join `bk_article_soft_classify_relation` on `bk_article_soft_classify_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_classify` on `bk_article_soft_classify_relation`.`classify_id` = `bk_article_classify`.`id` left join `bk_article_tag_relation` on `bk_article_tag_relation`.`article_id` = `bk_article_soft`.`id` left join `bk_article_tags` on `bk_article_tag_relation`.`tag_id` = `bk_article_tags`.`id` where `bk_article_soft`.`is_delete` = '1' and `bk_article_soft`.`status` = '1' and `bk_article_classify`.`id` = '106' group by `bk_article_soft`.`id` order by `bk_article_soft`.`sort` desc, `bk_article_soft`.`write_time` desc, `bk_article_soft`.`id` desc limit 15 offset 0
select * from `bk_article_classify` where `is_delete` = '0' and `is_active` = '1' and `is_nav` = '1' order by `sort` desc
select * from `bk_article_classify` where `id` = '35' and `is_active` = '1' and `is_delete` = '0' limit 1
select * from `bk_article_classify` where `is_nav` = '1' and `is_delete` = '0' and `pid` in ('29') order by `sort` desc
select * from `bk_article_classify` where `id` = '29' and `is_active` = '1' and `is_delete` = '0' limit 1
select * from `bk_article_classify` where `pid` in ('35') and `is_active` = '1' and `is_delete` = '0' order by `sort` desc, `id` desc
