SiteStatsVideo
Query the SiteStatsVideo in Wordpress.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters.
- PostID supports the '=' comparison.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server side.
SELECT * FROM SiteStatsVideo WHERE PostID=21
Columns
| Name | Type | References | Description |
| PostID [KEY] | Int | The unique identifier of the video post. | |
| PostName | String | The slug or name assigned to the video post. | |
| PostParent | Int | The identifier of the parent post, if this post is part of a hierarchy. | |
| PostPassword | String | The password required to access the post, if it is password-protected. | |
| PostStatus | String | The publication status of the post, such as publish, draft, or private. | |
| PostTitle | String | The title of the video post. | |
| PostType | String | The content type of the post, such as post, page, or a custom post type like video or product. | |
| FieldsAggregate | String | A collection of field definitions that describe the structure of the returned data. | |
| DataAggregate | String | A collection of video-related statistics, including views, plays, and engagement data. | |
| PagesAggregate | String | A list of pages on which the video appears or is embedded. | |
| PostCommentCount | String | The total number of comments made on the post. | |
| PostCommentStatus | String | Indicates whether comments are open or closed for the post. | |
| PostFilter | String | Specifies how the post content is filtered before being returned. | |
| PostGuid | String | The globally unique identifier (GUID) for the post, typically used internally by WordPress. | |
| PostMenuOrder | Int | The numeric value used to determine the post's position in manual sorting or custom menus. | |
| PostPermaLink | String | The full public URL where the post can be viewed in a browser. | |
| PostPingStatus | String | Indicates whether pingbacks and trackbacks are allowed for the post. | |
| PostPinged | String | A list of URLs that have already been pinged by this post. | |
| PostAuthor | String | The user ID or username of the author who created the post. | |
| PostContent | String | The full content of the post, including HTML or text formatting. | |
| PostContentFiltered | String | A filtered version of the post content after WordPress or plugins apply transformations. | |
| PostDate | Datetime | The date and time the post was created, in the site's local timezone. | |
| PostDateGmt | Datetime | The creation date and time of the post in Greenwich Mean Time (GMT). | |
| PostExcerpt | String | A short summary or excerpt of the post content. | |
| PostMimeType | String | The Multipurpose Internet Mail Extensions (MIME) type of the post, used mainly for media attachments such as videos. | |
| PostModified | Datetime | The date and time when the post was last modified, in the site's local timezone. | |
| PostModifiedGmt | Datetime | The last modified date and time of the post in GMT. | |
| PostToPing | String | A list of URLs to notify (ping) when the post is published. |