Query this table to return detailed information from your Facebook Share implementation.
Highlighted rows are indexable / searchable and one is usually required in the WHERE portion of the query.
|url||string||The URL to the Web page users can share with Facebook Share. This is the indexable field in the table, so you must specify it in your query's WHERE clause. To specify more than one URL, you must use the IN operator in the query's WHERE clause.|
|normalized_url||string||The normalized URL for the page being shared.|
|share_count||string||The number of times users have shared the page on Facebook.|
|like_count||string||The number of times Facebook users have "Liked" the page.|
|comment_count||string||The number of comments users have made on the shared story.|
|total_count||string||The total number of times the URL has been shared, liked, or commented on.|
This query wants the number of Shares, Likes, comments, and the total of these counts.
SELECT share_count, like_count, comment_count, total_count FROM link_stat WHERE url="http://example.com/"
This query wants the number of Shares, Likes, comments, and the total of these counts for two URLs.
SELECT share_count, like_count, comment_count, total_count FROM link_stat WHERE url IN("http://example.com/","http://example.org/")