社区动态首页

select count(*) from memos 
where destroy_status is null and hidden=0 and published_at is not null and root_id is null;
/*
destroy_status=0表示已删除
hidden=1 表示隐藏，hidden=0表示未隐藏
published_at有值表示已审核通过
root_id不为空表示帖子，有值表示帖子评论
*/

select count(distinct author_id) from memos 
where destroy_status is null and hidden=0 and published_at is not null and root_id is null;

select count(viewed_count) from memos 
where destroy_status is null and hidden=0 and published_at is not null and root_id is null;