facebook - Facebook FQL，用于有序的link_stats

Question

我正在尝试检索以 public 子字符串开头的网址的有序(降序)结果link_stats。我正在尝试使用以下内容:

SELECT url,
       normalized_url,
       share_count,
       like_count,
       comment_count,
       total_count,
       commentsbox_count,
       comments_fbid,
       click_count
FROM   link_stat
WHERE  substr(url, 0, 22) = "http://www.example.com";  

但我不断收到以下错误消息:

Your statement is not indexable. The WHERE clause must contain an indexable column.

任何有关如何使用“total_count”来降序排序的附加语法的建议都将受到赞赏。

谢谢!

Answer 1

网址现在是可索引的列。参见https://developers.facebook.com/docs/reference/fql/link_stat

您是否使用过直接的where子句来发送网址？

SELECT url,
       normalized_url,
       share_count,
       like_count,
       comment_count,
       total_count,
       commentsbox_count,
       comments_fbid,
       click_count
FROM   link_stat
WHERE  url = "www.example.com";