CommentLikes
Returns information about likes on WordPress comments, including the number of likes each comment has received.
Table Specific Information
SELECT
The add-in uses the WordPress API to process some of the filters.
- CommentId supports the '=' comparison.
The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server side.
SELECT * FROM CommentLikes WHERE CommentId = 10
Columns
| Name | Type | References | Description |
| CommentId [KEY] | Int |
Comments.Id | The unique identifier of the comment that received the like. |
| ID [KEY] | Int | The unique identifier of the user who liked the comment. | |
| Name | String | The display name of the user who liked the comment. | |
| Login | String | The WordPress username of the user who liked the comment. | |
| String | The email address of the user who liked the comment. | ||
| IPAddress | String | The IP address from which the comment was liked. | |
| FirstName | String | The first name of the user who liked the comment. | |
| LastName | String | The last name of the user who liked the comment. | |
| NiceName | String | The URL-friendly version of the user's display name used in WordPress profile links. | |
| SiteID | Int | The unique identifier of the site associated with the user who liked the comment. | |
| IsSiteVisible | Bool | Indicates whether the site associated with the user is publicly visible in WordPress. | |
| ProfileURL | String | The URL linking to the WordPress profile of the user who liked the comment. | |
| DefaultAvatar | Bool | Indicates whether the user is using the default WordPress avatar image. | |
| AvatarURL | String | The URL of the avatar image for the user who liked the comment. | |
| ItemURL | String | The URL linking directly to the comment that was liked. | |
| MetaAggregate | String | Aggregated metadata for the comment like record returned by the WordPress API. |