
统计回复贴子数量:
select its.Id,its.UserId,its.Title,its.Content,its.AddTime,t.RecordCount from (select ParentId,Count(ParentId) RecordCount from ReplayStickers group by ParentId) as t left join InitiatedStickers its on t.ParentId=its.Id order by RecordCount desc select its.Id,its.UserId,its.Title