TaxonomyTerms
List all terms of the taxonomies.
Table Specific Information
SELECT
The 本製品 uses the WordPress API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. Note: Taxonomy is required to fetch TaxonomyTerms. Use the slug values from the taxonomies view to retrieve the taxonomy column value.
For example, the following queries are processed server side.
SELECT * FROM TaxonomyTerms WHERE Taxonomy = 'books'; SELECT * from WordPress.taxonomyterms WHERE taxonomy in ('post_tag','Category');
Columns
Name | Type | Description |
id | Integer | The id of the term in the taxonomy. |
Count | Integer | Count of it's presence. |
Link | String | Labels for the taxonomy for various contexts. |
Name | String | The title for the taxonomy term. |
Slug | String | An alphanumeric identifier for the taxonomy term. |
Taxonomy | String | Taxonomy in which this term is present |
Parent | Integer | The id of the parent taxonomy |
Description | String | A description of the taxonomy term. |