数据结构:
[img]http://dl2.iteye.com/upload/attachment/0090/5711/b0b4a64b-fa19-3148-8285-2acb21a7c34e.png[/img]
统计回复贴子数量:
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
显示结果:
[img]http://dl2.iteye.com/upload/attachment/0090/5713/5d488a80-fe06-3459-a1c5-bb7542bfa1b7.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0090/5711/b0b4a64b-fa19-3148-8285-2acb21a7c34e.png[/img]
统计回复贴子数量:
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
显示结果:
[img]http://dl2.iteye.com/upload/attachment/0090/5713/5d488a80-fe06-3459-a1c5-bb7542bfa1b7.png[/img]