Dedecms数据调用

Dedecms中常用数据调用的SQL语句包括：，，1. 获取文章列表：，“sql，SELECT * FROM dede_archives WHERE channel = 频道ID ORDER BY pubdate DESC，`，，2. 获取文章详情：，`sql，SELECT * FROM dede_archives WHERE id = 文章ID，`，，3. 获取栏目列表：，`sql，SELECT * FROM dede_channel WHERE parentid = 0，`，，4. 获取子栏目列表：，`sql，SELECT * FROM dede_channel WHERE parentid = 父栏目ID，`，，5. 获取标签列表：，`sql，SELECT * FROM dede_taglist，`，，6. 获取指定标签的文章列表：，`sql，SELECT * FROM dede_archives WHERE tag = ‘标签名称’，“