select article.id,ptype.typeName ,count(*) as rcount from article inner join ptype on ptype.fid=article.typeid innerjoin restore on restore.id = article.id group by article.id,ptype.typeName order by rcount desc
select article.id,ptype.typeName ,restore.count(*) as rcount from article inner join ptype on ptype.fid=article.typeid innerjoin restore on restore.id = article.id group by article.id,ptype.typeName order by rcount desc
select article.id,ptype.typeName ,count(restore.你随便找个列名) as rcount from article inner join ptype on ptype.fid=article.typeid innerjoin restore on restore.id = article.id group by article.id,ptype.typeName order by rcount desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货