select a.fid,b.ip,a.票数 from
(select fid,sum(票数) as 票数 from 表3 group by fid) a
left join
(select mid,count(ip) as ip from 表4 group by mid) b on a.fid=b.mid
(select fid,sum(票数) as 票数 from 表3 group by fid) a
left join
(select mid,count(ip) as ip from 表4 group by mid) b on a.fid=b.mid
SELECT COUNT(*) AS ips, mid
FROM (SELECT mid, ip
FROM 表4
GROUP BY mid, ip) a
GROUP BY mid
获得不同ip数还可以简化吗?