select count(*) as newstotal from ecms_news where userid='$userid' and ismember=1 and checked=1这个是查询用户在ecms_news表中发表的次数, 那还有ecms_movie和ecms_info两个表, 如何查询所有表的发表次数呢?
select sum(cnt) from ( select count(*) as cnt from ecms_news where userid='$userid' and ismember=1 and checked=1 union all select count(*) as cnt from ecms_movie where userid='$userid' and ismember=1 and checked=1 union all select count(*) as cnt from ecms_info where userid='$userid' and ismember=1 and checked=1 ) t
from (
select count(*) as cnt
from ecms_news
where userid='$userid'
and ismember=1
and checked=1
union all
select count(*) as cnt
from ecms_movie
where userid='$userid'
and ismember=1
and checked=1
union all
select count(*) as cnt
from ecms_info
where userid='$userid'
and ismember=1
and checked=1
) t