wordpress post status inquery

That is called as Revision in WordPress.

Whenever you update your post, the older content of that post is treated as Revision and a new record for revision is inserted in posts table.

And we can check our revisions from Revision meta box.

More detail : https://codex.wordpress.org/Revisions

For – How to solve it to make only publish post?

You can define the number of revision you want to create and also can disable revision for wp posts by adding below lines in wp-config.php

define( 'WP_POST_REVISIONS', 3 ); // max 3 revision will be stored.

define( 'WP_POST_REVISIONS', false ); // disable revision system

Related Posts:

  1. Is it possible to have more “levels” of draft/published statuses?
  2. What is a “protected” post status?
  3. how to assign a status/mark to post?
  4. Why doesn’t wp_update_post() update the post_status field?
  5. register_post_status and show_in_admin_all_list
  6. Changing post status in one click
  7. How can I run custom function when post status is changed?
  8. WP_Post_List_Table::get_views – Have post counts account for filters?
  9. Creating/editing custom ‘post-state’
  10. Using arbitrary post status without registering it
  11. Get a list of ALL Statuses both registered and built-in
  12. Adding custom post status to visibility in publish meta box
  13. Changing post status
  14. Change scheduled posts to published
  15. Include Drafts or Future posts with count_user_posts?
  16. Remove ‘private’ and ‘pending review’ options from post status dropdown
  17. Can not get future_to_publish to work
  18. Which is the better way to get the status of a post?
  19. “Publish immediately” with custom post status
  20. Modify Post Status Arguments
  21. Additional page and post status types
  22. Add a simple JS Alert Box on Post Submission
  23. Function to change post status IF current user and post author are the same
  24. Schedule future post to custom post status instead of publish?
  25. Why does get_post_status display published when attachment is in trash?
  26. Force Custom Post Type Status to ‘Future’ on first Save or Publish
  27. Workflow for attachments in WordPress
  28. how to transition to custom post status on post save
  29. How to change custom post type status when non-admin updates post?
  30. Custom post status filter links always show a count of all posts in the site with that status, not the logged in users count
  31. Multiple Post Status
  32. retrieve post details in loop
  33. Any way to change post/page status when editing page?
  34. How to change post status from “draft” to “publish”?
  35. transition_post_status doesn’t work with bulk updates
  36. Submitted for Review back to a Draft page
  37. How to Add Custom Post Status in WordPress Admin
  38. Auto draft posts when scheduled date is reached
  39. Changing a post status name
  40. How to update post status to draft if user role is “pending’
  41. How to create posts with a specific date in bulk
  42. How to check if a user (not current user) is logged in?
  43. New post status for custom post type
  44. How to Display a List of Users Who Have Made at Least 1 Post?
  45. How to check if page has status published
  46. How to 301 private posts rather than 404?
  47. get_terms(); show private posts when logged in
  48. delete custom post based on custom field date
  49. Why this plugin doesn’t work with media upload page?
  50. Error after deleting Custom Post Type with a function (no trash used)
  51. How to set default status to custom post type
  52. How to display future posts – modified query still yields 404
  53. How can a guest view the “Pending Review” Post?
  54. 1 day after custom date change post status to draft
  55. Can’t get drafts with WP_Query using post_status parameter
  56. How to Modify this $wpdb query to accept an array of post statuses
  57. Allow users mark posts as “complete”?
  58. Automatically remove a canceled order in Woocommerce
  59. Change Visibility to Private
  60. Show scheduled posts in main loop but not in WP_Query?
  61. wp_query ignoring custom post_status
  62. WordPress post_status is future, manually added
  63. Custom post type suppress transition from future to publish
  64. transition_post_status not working via Quick Edit
  65. How to update all posts but the current one (post__not_in not working?)
  66. Posts and Attachments with “Published” status in Search
  67. How to use same page template if post status other than ‘publish’?
  68. Get publish post link?
  69. Restrict edit, but allow preview for custom post status
  70. Show user info in a hovercard [closed]
  71. Do action for only switch status for publish_post
  72. Ajax function on #publish only saves as draft – how to make it publish?
  73. Accessing private posts through REST API, same code that works in remote doesn’t in local
  74. Remove Save Draft & Preview Buttions.. and also Statius: Draft & Visibility: Public
  75. wp_dropdown_pages : choose post status to list in dropdown
  76. Restrict access to a post once it is tagged as a given status
  77. What function publishes a post when you click the publish button?
  78. WP_Query will not display draft posts
  79. How can I restore posts from ‘trash’ with their previous post_status? – WordPress
  80. Set Post Private if no linked Post Objects (ACF)
  81. Updating post status via rest api
  82. How to hide private posts even if user is admin
  83. edit.php all post not working
  84. If click on Save/Publish change Post Status to Pending Review instead Publish
  85. Bulk edit orders to ‘wc-processing’ status
  86. Custom Post Status not getting displayed after post update
  87. Send default WooCommerce email when switching from custom order status
  88. How to save post_status using action save_post?
  89. Why transition_post_type hook is called twice for the same post?
  90. Modify loop to include all post statuses not just ‘published’
  91. Implement post status update as frontend news announcement
  92. Custom Post Status & Taxonomies
  93. How to filter posts in admin by before date or by post status ‘future’?
  94. Excluding certain post status’s from pagination
  95. Enforce conditions only for draft posts using WyPiekacz, ignore pending and published posts
  96. get_posts includes “auto drafts”?
  97. hide woo commerce dashboard status and reports from woo commerce from specific users but display to other users
  98. Post Format Status [closed]
  99. Change a Post’s Status based on the date from a custom field? (for Event posts)
  100. Give attachments an archive page, and exclude unattached ones