Warning: Illegal string offset 'url' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 137

Warning: Illegal string offset 'webname' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 138

Warning: Illegal string offset 'logo' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 139

Warning: Illegal string offset 'url' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 137

Warning: Illegal string offset 'webname' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 138

Warning: Illegal string offset 'logo' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 139

Warning: Illegal string offset 'url' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 137

Warning: Illegal string offset 'webname' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 138

Warning: Illegal string offset 'logo' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 139

Warning: Illegal string offset 'url' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 137

Warning: Illegal string offset 'webname' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 138

Warning: Illegal string offset 'logo' in /home/wwwroot/skyhome/include/taglib/flink.lib.php on line 139

Warning: fopen(/home/wwwroot/skyhome/cmstop/data/cache/channelsonlist.inc): failed to open stream: Permission denied in /home/wwwroot/skyhome/include/helpers/channelunit.helper.php on line 778

Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/wwwroot/skyhome/include/helpers/channelunit.helper.php on line 779

Warning: fclose() expects parameter 1 to be resource, boolean given in /home/wwwroot/skyhome/include/helpers/channelunit.helper.php on line 780
TAG标签：DISTINCT_湛蓝天空
当前位置： 湛蓝天空 > TAG标签 > DISTINCT

04 2012年06月

按“分类名称”分类统计日志数和参与用户数

发布于：11时35分 | 来源：湛蓝天空 | 编辑：湛蓝

a表： b表： 按分类名称分类统计日志数和参与用户数： SELECT b.catname AS 分类名称, COUNT( * ) AS 日志数, count( DISTINCT a.username )AS 人数 FROM `pre_home_blog` a LEFT JOIN `pre_home_blog_category` b ON a.cati

+阅读全文

标签：GROUP BY,DISTINCT,Mysql 日志分类：SQL围观群众：356人
    共1页/1条