UserSitesPosts
List the UserSitesPosts for the WordPressOnline website.
Table Specific Information
SELECT
The server uses the WordPress API to process some of the filters.
- AuthorId supports the '=' comparison.
- Status supports the '=' comparison.
The server processes other filters client-side within the server.
For example, the following queries are processed server side.
SELECT * FROM UserSitesPosts
SELECT * FROM UserSitesPosts where AuthorId = 21
Columns
| Name | Type | References | Description |
| ID [KEY] | Int | The unique identifier of the post. | |
| SiteID [KEY] | Int | The unique identifier of the WordPress site the post belongs to. | |
| AuthorAvatarURL | String | The URL of the author's avatar image. | |
| IsAuthorEmailAvailable | Boolean | Indicates whether the author's email address is available. | |
| AuthorFirstName | String | The author's first name. | |
| AuthorID | Int | The unique identifier of the post author. | |
| AuthorLastName | String | The author's last name. | |
| AuthorLogin | String | The author's WordPress login name. | |
| AuthorName | String | The display name of the author, typically shown on posts and comments. | |
| AuthorNiceName | String | A URL-friendly version of the author's display name. | |
| AuthorProfileURL | String | The full URL to the author's public WordPress profile. | |
| AuthorSiteID | Int | The unique identifier of the author's primary WordPress site. | |
| AuthorURL | String | The author's website or profile URL. | |
| Date | Datetime | The date and time the post was created, in the site's local timezone. | |
| Modified | Datetime | The date and time the post was last updated. | |
| Title | String | The title of the post. | |
| URL | String | The full permalink URL to the post. | |
| ShortURL | String | The WordPress shortlink (wp.me) version of the post URL. | |
| Content | String | The full content of the post, in HTML or plain text format. | |
| Excerpt | String | A short excerpt or summary of the post content. | |
| Slug | String | The post's slug — the URL-friendly name used in its permalink. | |
| Guid | String | The globally unique identifier (GUID) for the post. | |
| Status | String | The publication status of the post, such as publish, draft, or private. | |
| IsSticky | Boolean | Indicates whether the post is marked as sticky (pinned to the top of the blog). | |
| Password | String | The password required to view the post, if it is password protected. | |
| HasParent | Boolean | Indicates whether the post has a parent (for hierarchical post types). | |
| Type | String | The post type, such as post, page, or a registered custom type. | |
| DiscussionCommentCount | Int | The total number of comments associated with the post. | |
| DiscussionCommentStatus | String | The current comment status, such as open or closed. | |
| HasDiscussionCommentsOpen | Boolean | Indicates whether new comments can be added to the post. | |
| DiscussionPingStatus | String | The pingback or trackback status for the post. | |
| HasDiscussionPingsOpen | Boolean | Indicates whether pingbacks or trackbacks are allowed. | |
| HasLikesEnabled | Boolean | Indicates whether the post can receive likes. | |
| HasSharingEnabled | Boolean | Indicates whether social sharing buttons are enabled for this post. | |
| LikeCount | Int | The total number of likes the post has received. | |
| ILike | Boolean | Indicates whether the current user has liked the post. | |
| IsFollowing | Boolean | Indicates whether the current user follows the blog containing this post. | |
| IsReblogged | Boolean | Indicates whether the current user has reblogged this post. | |
| GlobalID | String | A unique WordPress.com-wide identifier for the post. | |
| FeaturedImage | String | The URL of the post's featured image, if available. | |
| PostThumbnail | String | The attachment object representing the post's featured image. | |
| Format | String | The post format, such as standard, image, quote, video, or gallery. | |
| HasGeo | Boolean | Indicates whether the post includes geolocation data. | |
| MenuOrder | Int | The order value used to arrange pages hierarchically or in menus. | |
| PageTemplate | String | The page template assigned to this post, if applicable. | |
| PublicizeURLsAggregates | String | An array of URLs to posts shared via connected Publicize services (for example, Facebook). | |
| CategoriesAggregates | String | A collection of categories assigned to the post, keyed by category name. | |
| TermsCategoryAggregates | String | A taxonomy mapping that lists category terms applied to the post. | |
| TermsPostTagAggregates | String | A taxonomy mapping that lists tag terms applied to the post. | |
| TermsPostFormatAggregates | String | A taxonomy mapping that lists post format terms applied to the post. | |
| TermsMentionsAggregates | String | A taxonomy mapping that lists mention terms applied to the post. | |
| TagsAggregates | String | A collection of tags applied to the post, keyed by tag name. | |
| Attachments | String | A list of attachment objects (keyed by attachment ID), limited to the most recent 20 items. | |
| AttachmentCount | Int | The total number of media attachments associated with this post. | |
| MetadataAggregates | String | A collection of post metadata key-value pairs. | |
| HasCapabilitiesDeletePost | String | Indicates whether the current user has permission to delete the post. | |
| HasCapabilitiesEditPost | String | Indicates whether the current user has permission to edit the post. | |
| HasCapabilitiesPublishPost | String | Indicates whether the current user has permission to publish the post. |