Facebook 评论框：“评论和回复总数”的 FQL在评论中

发布于 2024-11-19 02:41:34 字数 265 浏览 0 评论 0原文

我目前正在用来

select time from comment
where object_id in
 (select comments_fbid from link_stat where url ='http://www.example.com/post/')
ORDER BY time DESC

发现这篇文章有多少评论（我只是在这里计算回复数）。当然，这并没有列出回复的数量。

是否有等效的 FQL 查询可以计算评论+回复？

原文

I'm currently using

select time from comment
where object_id in
 (select comments_fbid from link_stat where url ='http://www.example.com/post/')
ORDER BY time DESC

to discover how many comments there are for this post (I simply count the responses here). This doesn't list the number of replies, of course.

Is there an equivalent FQL query that would count comments+replies?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

沙沙粒小 2024-11-26 02:41:34

试试这个：

select time from comment where 
object_id in 
  (select comments_fbid from link_stat where url ='http://www.example.com/post/') 
or object_id in 
  (select post_fbid from comment where object_id in (select comments_fbid from link_stat where url ='http://www.example.com/post/'))

Try this:

select time from comment where 
object_id in 
  (select comments_fbid from link_stat where url ='http://www.example.com/post/') 
or object_id in 
  (select post_fbid from comment where object_id in (select comments_fbid from link_stat where url ='http://www.example.com/post/'))

回复收藏 0 原文

~没有更多了~