[ Facebook Comments Box: FQL for "total comments and replies" in comment ]
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?
Answer 1
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/'))