DTcms查询统计每个tags标签的文章数
DTcms查询统计每个tags标签的文章数的SQL语句:select *,(select count(0) from dt_article_tags_relation where tag_id=dt_article_tags.id) as count FROM dt_article_tags数据库执行查询效果:
DTcms查询统计每个tags标签的文章数的SQL语句:select *,(select count(0) from dt_article_tags_relation where tag_id=dt_article_tags.id) as count FROM dt_article_tags数据库执行查询效果: