- SELECT
- n.pk_id,
- count( DISTINCT r.user_id ) forwardNum
- FROM
- news_info n
- INNER JOIN news_info_record r ON r.type = 1
- AND r.news_id = n.pk_id
- AND r.data_active = 0
- AND n.data_active = 0
- GROUP BY
- r.news_id
按照 news_id 分组统计, 但是在 user_id 相同的时候不能统计在内
来源: http://www.bubuko.com/infodetail-3692360.html