Is is possible to rebuild wp_term_relationships table?

If your AUTO_INCREMENT value wasn’t reset and your new posts will still have unique IDs and you can do:

SELECT tr.*, p.ID
FROM wp_term_relationships AS tr
    LEFT JOIN wp_posts AS p ON tr.object_id = p.ID
WHERE p.ID is NULL;

to see which term relationships are orphans and use a DELETE FROM to fix it.

Related Posts:

  1. How do I display a tag cloud under my post that only shows tags from that post?
  2. Display list of most used tags in the last 30 days
  3. Check if current page has given tag ID
  4. Stop WordPress From Removing HTML Comments In Content
  5. How can I let my audience tag my posts?
  6. How do I change the output of get_the_tag_list()?
  7. Query all posts with specific tag
  8. How to query with get_posts() for posts with any tag
  9. Change tooltip in tag cloud
  10. Getting an ordered list of tags – via wp_tag_cloud or not?
  11. Is it possible to filter get_adjacent_post() with tags?
  12. How to allow user to perform search by more than one tag
  13. get_post_ancestors returns empty
  14. Combining tags from post types
  15. Display tags belonging to a specific post type only
  16. List ‘n’ number of posts from a Tag, each with a different class or ID
  17. Creating a Lightweight Media Tags Plugin with a Custom Taxonomy
  18. Displaying the most recently used tags
  19. Limit tag word count
  20. Can’t Get ‘tag’ Page To Display only Tagged Posts
  21. Tags as a dropdown with set tags
  22. Exclude a specific tag from the get_the_tags list
  23. Efficient Tag Management?
  24. Query all posts which do not have tags assigned to them
  25. Tag subscription option in wordpress. How?
  26. How to allow html5 tag in WordPress
  27. Do not change the order of the tags in the editor
  28. How can I show post excerpts on the tags page?
  29. Tags, use both union and intersection at the same time
  30. How can I prevent wordpress from creating tag pages?
  31. how can i add all my tags to tagcloud?
  32. Blog post : Remove comma between Tag names [closed]
  33. Why does the count property of get_the_tags always return 0?
  34. Why word can’t be displayed in wordpress?
  35. How to add prefix or suffix to post_tag slug?
  36. Get all terms if product of that term contains a specific category
  37. How to get popular post tags
  38. Remove URL from Tag
  39. CPT UI – elementor tags archive template not working
  40. Get count of custom post tags
  41. WP API: Get posts excluding those with a tag or category name
  42. How to echo tag description on loop-page.php using WPeC 3.8
  43. How do I add a related tags list to a wordpress tag page
  44. I want a query to list tags
  45. Remove href tag from wp_postmeta in 34,000 posts?
  46. Global changing of H Tags
  47. May I change the order of the tags?
  48. Display get_the_tag_list by order entered in the backend
  49. get posts that doesn’t contain a specific tag
  50. Remove commas between tags
  51. How to return tags containing one, two or three exact and specific words using get_tags
  52. how to output tags that has specific value in slug
  53. Need sql to remove tags from older posts
  54. wordpress str_replace the content with tag
  55. Highlight current tag using get_tags()
  56. show tags on “single”-template sidebar only
  57. Split function “the_tags” in 2 columns
  58. Is there any way of making post tags (or custom post type tags) pop up as suggestion as in StackExchange sites?
  59. How to display tags with post_content
  60. Exclude Specific Tag On Homepage
  61. Code to check how many posts a tag has?
  62. Change Size of P Tag on One Page Template [closed]
  63. How to list all tags except the current tag in tag.php
  64. tag is working in chrome but not in firefix..What is the problem? [closed]
  65. How to add keyword field in custom form programmatically?
  66. How to add meta tags on password-protected homepage? [closed]
  67. Adding Related Articles to post
  68. WordPress title as keywords (tags) with excluded stop words
  69. Separate the tag by comma [duplicate]
  70. Add/remove tags on frontend programmatically
  71. No line breaks in tags in tag cloud
  72. Custom text for certain tags
  73. get_edit_tag_link does not return anything
  74. get an attachment’s media tags or check if it has a media tag?
  75. Anyway to retrieve a feed of posts that have BOTH tags?
  76. Top ten tags ala Delicious
  77. Links from the_tag not working
  78. Is it possible to embed a wordpress tag page on wordpress?
  79. limit number of tags shown in tag.php
  80. Remove H1 site-tittle tag from product page with a function SEO
  81. Display text if title in archive has specific word
  82. Tag pages with regular editor
  83. How to remove base tags at the wordpress
  84. How to select tags in the frontend
  85. How are special characters encoded in tag-URL?
  86. Open graph ‘image’ content appears empty on debugger and filled in web source
  87. Is there a way to change the Tag selector from text input to checkmarks?
  88. how to see P and BR tags in tinymce?
  89. WordPress tinyMCE Keep Wrapping Tags To HTML Codes When Saving
  90. Neverending tag problem
  91. Exclude Tags by Array
  92. Update tags to 10,000+ posts with wpdb?
  93. Create another TAG widget for posts
  94. Need to display tag group as first name, last name but sort on last name
  95. Assign tags records that have a keyword
  96. HTML5 Summary tag in editor
  97. How to list Tags using get_tags in an html table?
  98. How can i get tag without />?
  99. How to add tags to identify custom post types in archives?
  100. WordPress Title Tag Not Changing