why are the term_id and term_taxonomy_id doesn’t match on custom taxonomies, but are duplicates on categories

  1. term_id is a unique ID for the term.
  2. term_taxonomy_id is a unique ID for the term+taxonomy pair.

A taxonomy consists of sometimes many terms, so basically the term_taxonomy_id links the term_id to the taxonomy.

All info on these can be found here:

http://codex.wordpress.org/WordPress_Taxonomy

Related Posts:

  1. Custom columns on edit-tags.php main page
  2. Is there a way to ‘Lock’ a Taxonomy?
  3. get_query_var(‘paged’) always returns empty
  4. Return only the custom sub-term for custom post type, do not echo term-parent
  5. wp_insert_term is adding a term that has no name
  6. Get total number of comments from posts in a specific custom taxonomy
  7. Display one post from each term in a custom taxonomy [closed]
  8. Is it possible to add taxonomies to user profiles?
  9. Get terms from multiple taxonomies
  10. Connect Users and Taxonomies
  11. WordPress json api taxonomy index method
  12. get_terms showing link to category even if all posts are drafts
  13. How to restrict on selecting child taxonomy
  14. Retrieving custom taxonomy in order, but excluding specific tax IDs
  15. Sort Custom Taxonomy Terms in admin by custom order
  16. Is it possible to sort the post based on a custom field?
  17. How do I get terms as a list for a specific post?
  18. Change in custom taxonomy permalink causes 404 error for another custom taxonomy
  19. Display sub-taxonomies based on SELECTED parent-taxonomy
  20. Checking if a Page has an Associated Term?
  21. Displaying ACF image field [closed]
  22. How get custom field from custom taxonomy?
  23. What are terms and taxonomy, how they related to post and how these three are stored in database?
  24. Get multiple term objects by ids
  25. Echo custom taxonomy term name
  26. Taxonomy.php issue with search and filters
  27. Move terms from one taxonomy to another keeping the hierarchy
  28. How can I get WP to build a feed based on multiple taxonomy terms
  29. Getting the selected terms for custom taxonomies in the editor
  30. Catchable fatal error on custom category post
  31. How to add contents of a custom field to a taxonomy term list?
  32. How to target parent product category and its children using WooCommerce?
  33. wordpress testimonials
  34. Custom Taxonomies not retaining hierarchy while importing from one site to another
  35. Output single post custom taxonomy child terms
  36. Website loading slowly – Advanced Custom Fields images
  37. saving meta/custom field to tag
  38. Get taxonomy name for the current post
  39. How to get posts that contain multiple terms from multiple taxonomies?
  40. Cannot delete or edit a single term in a custom taxonomy, taxonomy name is wrong?
  41. View the complete list of a taxonomy in the navigation menu
  42. Duplicate slug/permalink issue
  43. Getting taxonomies associated with a specified post type
  44. Changing input type from text to multi select dropdown – skill taxonomy
  45. Get name of taxonomies of current page
  46. How to list the taxonomy terms that fit the custom query?
  47. What’s the best way to add taxonomy’s image in 2017?
  48. Count of posts by different parameters?
  49. Geographic search with taxonomy structure [duplicate]
  50. Add custom taxonomy as a css class
  51. Wp_query…a type of term a different div
  52. Taxonomy page shows category in title
  53. SQL / wp_update_post: change post custom field to CPT post taxonomy
  54. Proper way to create taxonomy queries
  55. search using multiple taxonomies and keyword
  56. Need equivalent of single_term_slug
  57. Custom Permalink Structure for terms/taxonomies of custom post type
  58. register_taxonomy for both ‘Post’ & ‘Page’
  59. List one post only from each subcategory using get_posts?
  60. Multiple Drop-Down custom taxonomies search
  61. Issue adding custom taxonomies to custom post type (PHP)
  62. Taxonomy URL rewrite whilst keeping filtered posts?
  63. Search custom taxonomy via query-string?
  64. how do you pull data from two taxonomies?
  65. problem : Custom taxonomy template not showing
  66. How to loop custom posts that have an exact match in taxonomy terms?
  67. True or F False Setting of ‘with_front’ Parameter of Rewrite Is returning Exact Same result
  68. WordPress not saving tags for custom taxonomy term description
  69. How to Implement Custom Taxonomy Conditional Page?
  70. wp_insert_post not adding taxonomy (using wp_set_object_terms)
  71. Filter “get_terms” query
  72. Display multiple taxonomies in a function
  73. Remove Custom metabox from particular page template is used
  74. generate random slug when adding taxonomy
  75. Add and Custom category for posts “PAGE”
  76. Exporting Custom Taxonomy Description without Plugin
  77. How do I display post count of a custom post type with custom category taxonomy in wp_menu_nav?
  78. WordPress Main Menu with dynamic url
  79. wp_insert_post and custom taxonomy
  80. Custom Taxonomy – Dropdown
  81. Error 404 in Custom taxonomy with pagination
  82. Best Method to Switch Between Terms (Custom Taxonomy)
  83. Custom post type term names with ampersand in the term name
  84. WordPress Taxonomy Permalinks – Custom?
  85. Need help understanding a rewrite with multi-level taxonomy
  86. Getting the parent terms adds additional empty markup [closed]
  87. How to query authors by custom taxonomy?
  88. Display custom post term or taxonomy
  89. Attaching meta box to specific category/taxonomy in custom post type
  90. Change Permalink to Value of Custom Field
  91. Display custom post taxonomies
  92. Custom Taxonomy type in nav menu
  93. Advanced search: roles and multiple taxonomies
  94. Using post type archive page for taxonomy archive
  95. Custom Fields link to other pages, not search
  96. Removing fields from category/taxonomy edit form
  97. Taxonomy archive link from term id
  98. Remove ‘portfolio’ from URL
  99. Two taxonomies with the same slug
  100. Hook function when taxonomy terms change