select uid,sum(sc) sl from (select uid,count(*) as sc from `bbs_topics` group by uidunionselect uid,count(*) as sc from `bbs_reply` group by uid) group by uid