comment

Examples

• SELECT ... FROM comment WHERE id = A
• SELECT ... FROM comment WHERE object_id = A
• SELECT ... FROM comment WHERE parent_id = A
• SELECT ... FROM comment WHERE post_id = A

To read the comment table you need

• no access_token for public data
• any valid access_token to access private field: user_likes

Notes

Comments Order

Some comment threads, for example those from the Comments Plugin, are sorted by social relevance and not by time. Since there is no social_relevance column to ORDER BY, in order to get comments in socially relevant order, please add "AND parent_id='0'" to the WHERE clause of your query and omit any ORDER BY. For example:

SELECT id, text, time, fromid FROM comment WHERE object_id='10151309718465667' AND parent_id='0'

Will get the top level comments on this photo in the order they appear on the site. If you would like to get the comments in chronological order, simply add ORDER BY time:

SELECT id, text, time, fromid FROM comment WHERE object_id='10151309718465667' AND parent_id='0' ORDER BY time

To find out the default display order, select the comment_info column of the appropriate table. For the above example that would be:

SELECT comment_info FROM photo WHERE object_id='10151309718465667'

This will return a comment_info object with the comment_order:

{
  "comment_info": {
    "can_comment": true,
    "comment_count": 19,
    "comment_order": "ranked"
  }
}